How does "createlang" interact with different schemas?
От | P Kapat |
---|---|
Тема | How does "createlang" interact with different schemas? |
Дата | |
Msg-id | daef5be80812311214x5c1bf4d9of538e91dc6e0d74a@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: How does "createlang" interact with different schemas?
|
Список | pgsql-novice |
Hi, I am not sure if I should be mailing this to postgis list or this one, but I'll shoot here first: Setup: Postgres 8.11 on RedHat EL 5 + postgis 1.3.2 I do the following to add the postgis functionality to a database: createlang plpgsql dbname psql -d dbname -f /usr/share/pgsql/contrib/lwpostgis.sql psql -d dbname -f /usr/share/pgsql/contrib/spatial_ref_sys.sql This adds a bunch of functions and 2 tables to the public schema of dbname. Later I add a schema to this dbname database. Will all these postgis functions be available to the new schema? What about the 2 tables (geometry_columns and spatial_ref_sys)? How do these interact - are they schema specific or accessible across different schemas in the same database? Now I'll have to admit that I do not know how postgres is setup structurally, that is to say, what are schema, tablespace, catalogs, domains, procedures,..... and hence the question to this list. I have a bigger issue currently, but that will be in another mail. -- Regards PK -------------------------------------- http://counter.li.org #402424
В списке pgsql-novice по дате отправления: