Re: OLD.oid issues...

On Thu, 18 Jan 2001, Rod Taylor wrote:

> create table example (
>   original_oid oid REFERENCES table(oid)
>         ON UPDATE CASCADE
>         ON DELETE SET NULL
> );
> --
> ERROR:  UNIQUE constraint matching given keys for reference table "table" not found
> 
> Postgresql 7.1beta3.  I'd consider these to be bugs myself but I've not =
> tried them in previous versions to know if it's really just a new =
> feature :)

Actually I know the latter never really should have worked in past
versions.  It may have let you define it before, but I believe it would
have errored on the actual fk constraint when used, now it just won't let
you define it. I think referencing oids is on the todo list (although
you have to give ref actions like the ones you have or the constraint is
pretty ugly).