Retrieving a field from the NEW record

From: Eric E <whalesuit(at)bonbon(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Retrieving a field from the NEW record
Date: 2005-01-18 21:21:51
Message-ID: 41ED7DEF.5070800@bonbon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
I'm tearing my hair out trying to solve the following problem. I
want to be able to retrieve the value of the primary key in a trigger
function. I have tried using PL/PGSQL and PL/PERL, but a PL/PERL
trigger function
crashes the postgress process.
I am able to use TG_RELNAME and dblink_get_pkey to retrieve the name of
the primary key, but I cannot for the life of me figure out how to
reference the primary key name I retrieved in the NEW rowtype variable.

In other words, I want:

NEW.pkName, where pkName is a variable holding the name of my primary key.

Is there any way to do this using PL/PGSQL?

Thanks,

Eric

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matt Casters 2005-01-18 21:32:14 DWH on Postgresql
Previous Message Alvaro Herrera 2005-01-18 21:16:01 Re: What is xmin ?