Search Postgresql Archives

Retrieving a field from the NEW record

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux