Re: blocking referencing system catalogs in 8.4 breaks my code - Mailing list pgsql-hackers

From Tom Lane
Subject Re: blocking referencing system catalogs in 8.4 breaks my code
Date
Msg-id 13124.1244238087@sss.pgh.pa.us
Whole thread Raw
In response to blocking referencing system catalogs in 8.4 breaks my code  ("J. Greg Davidson" <jgd@well.com>)
List pgsql-hackers
"J. Greg Davidson" <jgd@well.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


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Documentation: GiST extension implementation
Next
From: Dimitri Fontaine
Date:
Subject: Re: pg_migrator issue with contrib