Re: NEW + tableOID - Mailing list pgsql-admin

From Tom Lane
Subject Re: NEW + tableOID
Date
Msg-id 22559.1281735905@sss.pgh.pa.us
Whole thread Raw
In response to NEW + tableOID  (Ricardo Bayley <ricardo.bayley@gmail.com>)
Responses Re: NEW + tableOID  (Ricardo Bayley <ricardo.bayley@gmail.com>)
List pgsql-admin
Ricardo Bayley <ricardo.bayley@gmail.com> writes:
> I do this with triggers. This issue I have is that the tableoid data cannot
> be used with the NEW keyword. I always get value 0 instead of the actual
> tableoid.

That might work in an AFTER trigger, but it definitely won't work in a
BEFORE trigger, because the NEW row isn't actually part of the table at
that point.  You'd probably be better off to rely on the trigger
function TG_RELID parameter instead, anyway.

            regards, tom lane

pgsql-admin by date:

Previous
From: Ricardo Bayley
Date:
Subject: Re: NEW + tableOID
Next
From: Ricardo Bayley
Date:
Subject: Re: NEW + tableOID