Postgres Pro
Downloads
Home   >   mailing lists

Re: use pg_catalog for foreign key constraint - Mailing list pgsql-general

From Tom Lane
Subject Re: use pg_catalog for foreign key constraint
Date
Msg-id 26774.1103222337@sss.pgh.pa.us
Whole thread Raw
In response to use pg_catalog for foreign key constraint  (Jonathan Hedstrom <jhedstrom@desc.org>)
List pgsql-general
Tree view 
Jonathan Hedstrom <jhedstrom@desc.org> writes:
> Does anyone know if it is possible to use system catalogs in foreign key
> constraints in Postgres 7.4.1?

It's not.  The system wouldn't enforce the constraint even if you
overrode the permission check, because internal backend catalog updates
don't fire triggers.

            regards, tom lane

pgsql-general by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Postgres not using shared memory
Next
From: Geoffrey
Date:
Subject: Re: pl/pgsql oddity