[postgis-users] Postgis 2.0 wishlist

David William Bitner david.bitner at gmail.com
Tue May 15 14:28:13 PDT 2007


Install postgis into whatever schema you want and set the default search
path in your postgresql configuration to use your postgis schema in the
default search path.  PostGIS is an add-on to PostgreSQL, as such there is
no out-of-the-box schema other than public for it to use.

On 5/15/07, Willy-Bas Loos <willybas at gmail.com> wrote:
>
> >This is doable now, the main problem for newbies seems to be setting
> >the search_path every single time so they have access to them.
> That doesn´t seem logical to me: it´s also a problem for the same newbies
> to restore their PostGIS databases.
>
> It should be a default search_path, just like pg_catalog and public.
> I dont need to set the search_path to use "select int2('25'::text)"
> either.
> Or would that conflict with PostgreSQL policies?
>
> WBL
>
>
> On 5/15/07, Paul Ramsey <pramsey at refractions.net> wrote:
> >
> >
> > On 15-May-07, at 4:33 AM, Willy-Bas Loos wrote:
> >
> > > If you're changing alle the function names, maybe it's time to make
> > > system objects of them, stored in a seperate system schema (along
> > > with the types, operators, etc)?
> >
> > This is doable now, the main problem for newbies seems to be setting
> > the search_path every single time so they have access to them.
> >
> > > Other than that it would be nice to add descriptions to the
> > > functions and operators in SQL, e.g. to indicate what the input for
> > > each function should be when the number of arguments varies for
> > > functions with equal names.
> >
> > How does one recover those descriptions at the commandline? Does \d
> > functionname work?
> >
> > P
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
************************************
David William Bitner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070515/8b1be0c3/attachment.html>


More information about the postgis-users mailing list