Re: foreign key on pg_shadow - Mailing list pgsql-sql

From Tom Lane
Subject Re: foreign key on pg_shadow
Date
Msg-id 27838.1118756242@sss.pgh.pa.us
Whole thread Raw
In response to foreign key on pg_shadow  ("M.D.G. Lange" <mlange@dltmedia.nl>)
List pgsql-sql
"M.D.G. Lange" <mlange@dltmedia.nl> writes:
> No matter what ON DELETE constraint I created, the system will not allow 
> me to create a foreign key, as pg_shadow is a system catalog.

We do not support foreign keys (or indeed triggers of any kind) on
system catalogs.  I don't foresee that happening in the near future
either, though I think there is something about it on the TODO list.
        regards, tom lane


pgsql-sql by date:

Previous
From: PFC
Date:
Subject: Re: SELECT very slow
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: getting details about integrity constraint violation