[postgis-users] Select polygons within polygon with PostGIS 2.0

[Sandro Santilli]

On Thu, Oct 11, 2012 at 09:30:30AM +0200, Michal Zimmermann wrote:
> On 10/11/12, Sandro Santilli <strk at 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