From: | Andreas Kalsch <andreaskalsch(at)gmx(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Using pg_catalog to define things across schemas |
Date: | 2009-10-08 20:30:43 |
Message-ID: | 4ACE4BF3.3000901@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am currently trying to solve the problem by using different schemas,
but then I have to consider all the GIS stuff. Putting the same things
in different schemas is no problem, but comparing the same type defined
in different schemas will lead to confusion, because Postgres treats
them as different types. So what about moving them to pg_catalog:
SET search_path TO pg_catalog;
CREATE LANGUAGE plpgsql;
CREATE LANGUAGE plpythonu;
\i /usr/share/postgresql-8.3-postgis/lwpostgis.sql
\i /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:2222: ERROR:
permission denied to create "pg_catalog.geometry_dump"
DETAIL: System catalog modifications are currently disallowed.
psql:/usr/share/postgresql-8.3-postgis/lwpostgis.sql:2228: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
...
How can I enable system catalog modifications?
Thanks for your help, so far.
Andi
Tom Lane schrieb:
> Andreas Kalsch <andreaskalsch(at)gmx(dot)de> writes:
>
>> But with this operation you will recreate the whole index. - I have
>> found out, that the name of the constraint's index is the same as the
>> constraint, so that I can simply rename the index.
>>
>
> You'd probably better rename the constraint too to avoid confusion.
> Failing anything else, there's always direct UPDATE of the pg_constraint
> catalog.
>
> regards, tom lane
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Leonardo M. Ramé | 2009-10-08 20:41:04 | Re: Query inside RTF |
Previous Message | Merlin Moncure | 2009-10-08 20:22:26 | Re: interface for "non-SQL people" |