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