Thread: pg_catalog

pg_catalog

From
"Donald Fraser"
Date:
PostgreSQL v 7.3.2

Is there a reason why I can create in the SCHEMA pg_catalog the following o=
bject types?
1) Functions
2) Operators
3) Types

Yet I cannot create tables in the SCHEMA pg_catalog.

Hopefully there is a logical solution rather than a bug.

Before someone shoots me down with "What are you doing modifying system cat=
alogues!".
The short answer is I need to be able specify whether a SCHEMA should get b=
acked up or not, for exactly the same reasons why pg_catalog doesn't get ba=
cked up. Because pg_catalog does not get backed up, I tried to utilise this=
 feature but I came across the problem of not being able to put tables in i=
t.

Regards
Donald Fraser.