Hi Stefan,
As far as I know, following other PostgreSQL contrib modules, PostGIS
currently only installs in the public schema (unless someone has put
some work into this). As I mentioned, this is the same for most other
contrib modules, like tsearch2, btree_gist, or cube. So, if ever you
wanted to install other PostgreSQL extensions, their functions /
datatypes / tables would also install in public, getting mixed up with
tables/functions you've defined there.
The solution here is simple. As a best practice, reserve the public
schema for contrib modules, storing user-defined tables / functions /
objects in user-defined schemas. Following this best practice also
makes upgrading PostGIS significantly simpler since you can simply dump
and restore your user-defined schema (rather than hunting through the
public schema trying to determine which functions are yours, postgis's,
cube's, tsearch2's, etc.)
Cheers,
Kevin
-------------
Kevin Neufeld
Software Developer
Refractions Research Inc.
300-1207 Douglas St.
Victoria, B.C., V8W 2E7
Phone: (250) 383-3022
Email: [EMAIL PROTECTED]
Stefan Schwarzer wrote:
Hi there,
I would like to know if somebody could tell me how I can - by using
the PostGIS MacPort - install the postgis functions not in the schema
"public", but in another schema (to separate it from the tables which
are being inserted into the public schema).
Thanks for any hints,
Stef
____________________________________________________________________
Lean Back and Relax - Enjoy some Nature Photography
http://photoblog.la-famille-schwarzer.de
<http://photoblog.la-famille-schwarzer.de/>
Appetite for Global Data? UNEP GEO Data Portal:
http://geodata.grid.unep.ch <http://geodata.grid.unep.ch/>
____________________________________________________________________
------------------------------------------------------------------------
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
