Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Antonio José García Lagar
Date:
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

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

From
Tom Lane
Date:
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

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

From
Antonio José García Lagar
Date:
> > 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