Retrieving a field from the NEW record - Mailing list pgsql-general

From Eric E
Subject Retrieving a field from the NEW record
Date
Msg-id 41ED7DEF.5070800@bonbon.net
Whole thread Raw
Responses Re: Retrieving a field from the NEW record  (Michael Fuhr <mike@fuhr.org>)
List 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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: What is xmin ?
Next
From: Tom Lane
Date:
Subject: Re: high unicode chars