OID in $_TD->{new}/$_TD->{old}

Started by Antonio José García Lagarover 16 years ago3 messagesgeneral
Jump to latest

It is posible to access to the row OID of the row which fired a pl/perl
trigger?

If I try to access to $_TD->{new}{oid} or $_TD->{old}{oid} I have no
result.

Thanks in advance!
--
Antonio José García Lagar <antonio@c17.net>
Compact Software International SA
http://www.c17.net

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Antonio José García Lagar (#1)
Re: OID in $_TD->{new}/$_TD->{old}

Antonio =?ISO-8859-1?Q?Jos=E9_Garc=EDa?= Lagar <antonio@c17.net> writes:

It is posible to access to the row OID of the row which fired a pl/perl
trigger?

If I try to access to $_TD->{new}{oid} or $_TD->{old}{oid} I have no
result.

It looks to me like plperl_hash_from_tuple considers only user
attributes. Not sure if this would be worth changing.

regards, tom lane

In reply to: Tom Lane (#2)
Re: OID in $_TD->{new}/$_TD->{old}

It is posible to access to the row OID of the row which fired a pl/perl
trigger?

If I try to access to $_TD->{new}{oid} or $_TD->{old}{oid} I have no
result.

It looks to me like plperl_hash_from_tuple considers only user
attributes. Not sure if this would be worth changing.

regards, tom lane

And is there any other way to access to the row OID from the trigger?

Thanks
--
Antonio José García Lagar <antonio@c17.net>
Compact Software International SA
http://www.c17.net