oid pseudoattribute in rules

Started by Dave Trombleyover 23 years ago2 messagesgeneral

dtrom@bumba.net

over 23 years ago

It seems that the oid attribute is not available from the NEW object
during an ON INSERT TO rule.
Can this be confirmed or denied? Is there any way to get the oid
that the new row will (eventually?) have?

-David J. Tombley
<dtrom@bumba.net>

Tom Lane

tgl@sss.pgh.pa.us

over 23 years ago

In reply to: Dave Trombley (#1)

Re: oid pseudoattribute in rules

"David J. Trombley" <dtrom@bumba.net> writes:

Is there any way to get the oid
that the new row will (eventually?) have?

No, because it hasn't got it yet.

I think you could get the OID in an AFTER trigger, if that helps any.

regards, tom lane