[postgis-users] Postgis doesn't work after search_path

[franco base]

Hi
I'm working on

"PostgreSQL 9.1.3 on x86_64-suse-linux-gnu, compiled by gcc (SUSE Linux)
4.6.2, 64-bit"

and

"POSTGIS="2.1.0 r11822" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.7.1, 23
September 2009" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8"
LIBJSON="UNKNOWN" TOPOLOGY RASTER"

Postgis is in Public Schema


I run
ALTER DATABASE mydb SET search_path TO 'test'

After Postgis doesn't work


So I give this command
reset search_path

and then
alter database mydb set search_path = "$user", public, topology

This select:
SELECT r.rolname, d.datname, rs.setconfig
FROM   pg_db_role_setting rs
LEFT   JOIN pg_roles      r ON r.oid = rs.setrole
LEFT   JOIN pg_database   d ON d.oid = rs.setdatabase

show that mydb is now ok and the setconfig is the same for all the db:
"{"search_path=\"$user\", public, topology"}"


On the other db Postgis is ok but on 'mydb' postgis doesn't work again.
This is the error (it's the same for all postgis function):

ERROR:  function st_union(public.geometry) does not exist
LINE 33: select st_union(wkb_geometry) AS wkb_geometry


Have you any tips?

Thanks
fb
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150804/4b9c5c37/attachment.html>