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 consid
Doesn't appear
that you can use OLD.oid in triggers (actually does more, =but thats good
enough):CREATE FUNCTION history_update_delete() RETURNS OPAQUE AS
'DECLARE v_tablename
varchar(40); v_history_tablename
varchar(48); v_operation
varchar(6);BEGIN v_operation :=3D
TG_OP;
