OLD.oid issues... - Mailing list pgsql-hackers

From Rod Taylor
Subject OLD.oid issues...
Date
Msg-id 03d601c08186$d50d18e0$6500000a@jester
Whole thread Raw
Responses Re: OLD.oid issues...
List pgsql-hackers
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;
    v_tablename :=3D TG_RELNAME;
    v_history_tablename :=3D ''history_'' || v_tablename;

    INSERT INTO v_history_tablename SELECT ''v_operation'' as =
history_change_type
        , OLD.oid as orignal_oid
        , *
        FROM v_tablename
        WHERE oid =3D OLD.oid;

    RETURN NEW;

END;
' LANGUAGE 'plpgsql';
--
ERROR:  record old has no field oid
 

The below also fails.

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 :)
--
Rod Taylor
 
There are always four sides to every story: your side, their side, the truth, and what really happened.
Attachment

pgsql-hackers by date:

Previous
From: Patrick Welche
Date:
Subject: test/locale broken
Next
From: Patrick Welche
Date:
Subject: Re: Autoconf version discrepancies