Received: from rain (rain.ximian.com [141.154.95.60]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f95B9In85032 for ; Fri, 5 Oct 2001 07:09:19 -0400 (EDT) (envelope-from vladimir@ximian.com) Received: from vladimir by rain with local (Exim 3.12 #1 (Debian)) id 15pSoX-00043B-00 for ; Fri, 05 Oct 2001 07:06:45 -0400 From: Vladimir Vukicevic To: pgsql-sql@postgresql.org Subject: getting OID from PL/PgSQL AFTER trigger Message-Id: Date: Fri, 05 Oct 2001 07:06:45 -0400 X-Archive-Number: 200110/85 X-Sequence-Number: 5040 Howdy, I'm trying to get the OID of the NEW/OLD rows in an AFTER trigger implemented in PL/PgSQL. Unfortunately, those end up as records in the trigger, and I can't just use NEW.oid. Is there any way to do this? I could do it using a trigger written in C, but I'd rather not have to carry around a C .so just for this. Note that I effectively have no knowledge of the format of the record that's passed in new/old, so I can't either add a sequence or use some already existing primary key to identify the row uniquely. One quick hack is to "INSERT INTO dummy VALUES (NULL);" and then GET DIAGNOSTICS z = RESULT_OID; and then use z - 1, but that will get me into lots of trouble with multiple cilents accessing the database. :-) For the time being, I'm going to implement the trigger in C, but I'm open to suggestions on how to implement this in straight PL/PgSQL. Thanks in advance, - Vlad