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

[Michal Zimmermann]

ALTER ROLE postgres IN DATABASE postgistemplate SET
search_path="$user", public, topology; seems to do the magic.

On 10/11/12, Sandro Santilli <strk at keybit.net> wrote:
> On Thu, Oct 11, 2012 at 09:49:03AM +0200, Michal Zimmermann wrote:
>> Got it! There was no username associated with the search_path and it
>> seems that was causing the trouble.
>
> I don't understand it, can you please tell us more about how you fixed it ?
> The search_path `` "$user", public, topology `` seems sane to me.
>
> --strk;
>
>>
>> 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
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> --
>
>  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