Got it! There was no username associated with the search_path and it seems that was causing the trouble.
On 10/11/12, Michal Zimmermann <zimm...@gmail.com> wrote: > 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 > -- 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