Using pg_catalog to define things across schemas

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
>
>
>

In response to

Browse pgsql-general by date

  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"