Is there any easy method for getting a hold of the OID and XID for a given row within a plpgsql (or another type) of function? Statements like NEW.oid appear to fail, and xid isn't to be found. I'd like to use these to create the history of an application which can be rolled back (by the application) which is stored in another table for easy stats generation. The reason for having the database do the work is that we want to keep the actions of the DBA's available to our clients to scrutinize, otherwise the wrappers could do the extra required dirty work to accomplish this. Is there an easier way of doing this? Since there's no environment variable type entity (variables common for an entire transaction) I was wondering if a cursor can flow between multiple functions? Each function uses FETCH -1 FROM transaction_id; to get information. Passing the transaction_id as a parameter isn't really an option as most of the functions() would be run via automated triggers. BEGIN WORK; DECLARE transaction_id CURSOR FOR SELECT 8329; FETCH 1 FROM transaction_id; select function1(); select function2(); select function3(); CLOSE transaction_id; COMMIT WORK; Thanks for your help in advance. -- Rod Taylor There are always four sides to every story: your side, their side, the truth, and what really happened.
BEGIN:VCARD VERSION:2.1 N:Taylor;Rod;B FN:Taylor, Rod B ORG:BarChord Entertainment Inc.;System Operation and Development TITLE:Chief Technical Officer ADR;WORK:;;;Toronto;Ontario;;Canada LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Toronto, Ontario=0D=0ACanada X-WAB-GENDER:2 URL: URL:http://www.barchord.com BDAY:19790401 EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;PREF;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] REV:20010122T195350Z END:VCARD
