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

[Michal Zimmermann]

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 <zimmicz at gmail.com> wrote:
> 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
>


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