Variable search_path for postgistemplate DB has the following values: "$user", public, topology.
On 10/11/12, Michal Zimmermann <zimm...@gmail.com> wrote: > How do I find out? > > On 10/11/12, Sandro Santilli <s...@keybit.net> wrote: >> On Thu, Oct 11, 2012 at 09:30:30AM +0200, Michal Zimmermann wrote: >>> On 10/11/12, Sandro Santilli <s...@keybit.net> wrote: >>> > On Thu, Oct 11, 2012 at 09:02:58AM +0200, Michal Zimmermann wrote: >>> >> Hi, >>> >> I tried with SELECT CreateTopology('kraje_topo', 4326); and got the >>> >> following error: ERROR: AddGeometryColumn() - invalid SRID. Is there >>> >> something special I need to do before creating topology? >>> > >>> > The SRID must be in spatial_ref_sys. >>> > Did you forget to load spatial_ref_sys.sql ? >>> >>> No, if I try select * from spatial_ref_sys where srid=4326, I get >>> exactly one result. The topology table belongs to topology scheme, >>> while the spatial_ref_sys belongs to public scheme, could that be a >>> problem? >> >> Uhm, good question. Is "public" not in your search path ? >> >> --strk; >> >> http://www.cartodb.com - Map, analyze and build applications with your >> data >> >> ~~ http://strk.keybit.net >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > > -- > Michal Zimmermann (zimmi) > WWW: http://www.zimmi.cz > -- Michal Zimmermann (zimmi) WWW: http://www.zimmi.cz _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users