Re: use pg_catalog for foreign key constraint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jonathan Hedstrom <jhedstrom(at)desc(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: use pg_catalog for foreign key constraint
Date: 2004-12-16 18:38:57
Message-ID: 26774.1103222337@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jonathan Hedstrom <jhedstrom(at)desc(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2004-12-16 18:39:38 Re: pl/pgsql oddity
Previous Message Jonathan Hedstrom 2004-12-16 18:25:17 use pg_catalog for foreign key constraint