Re: blocking referencing system catalogs in 8.4 breaks my code

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "J(dot) Greg Davidson" <jgd(at)well(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: blocking referencing system catalogs in 8.4 breaks my code
Date: 2009-06-05 21:41:27
Message-ID: 13124.1244238087@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"J. Greg Davidson" <jgd(at)well(dot)com> writes:
> from my code which has a column
> schema_name name NOT NULL REFERENCES pg_namespace ON DELETE CASCADE

You can't do that; it never has worked and is not likely to work in the
foreseeable future, because we don't support triggers on system catalogs.
Perhaps the system failed to alert you to the fact before, but if it
does so now, that's not a "regression".

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua Tolley 2009-06-05 21:45:33 Re: Using results from DELETE ... RETURNING
Previous Message Dimitri Fontaine 2009-06-05 21:40:52 Re: Documentation: GiST extension implementation