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

[Michal Zimmermann]

How do I find out?

On 10/11/12, Sandro Santilli <strk at keybit.net> wrote:
> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
Michal Zimmermann (zimmi)
WWW: http://www.zimmi.cz