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

[Michal Zimmermann]

Variable search_path for postgistemplate DB has the following values:
"$user", public, topology.

On 10/11/12, Michal Zimmermann <zimmicz at gmail.com> wrote:
> 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
>


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