oid in PL/pgSQL

From: Peter Keller <kel(at)bvv(dot)bayern(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: oid in PL/pgSQL
Date: 1999-06-16 08:15:48
Message-ID: 37675D33.4332C84B@bvv.bayern.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I need the row oid of an insert in an PL/pgSQL function.
For explanation: After an insert I call a PL/pgSQL function (by a
trigger) and I like to insert into an other table the row oid of the
first insert. But I don't know how to get the oid.
Thank you for helping,
Peter

--
CREATE FUNCTION func1() RETURNS OPAQUE AS '
BEGIN
dummy := new.name;
dummy1 := new.oid;
INSERT INTO table VALUES (dummy,dummy1);
RETURN new;
END;'
language 'plpgsql';
--
CREATE TRIGGER test1 AFTER INSERT OR UPDATE OR DELETE
ON person for each row execute procedure pro1('name','oid');
--
begin;
insert into person values ('.........');
end;

=> ERROR: record new has no field oid

--
Peter Keller Tel: (+49) 089-2190-2594
Fax: (+49) 089-2190-2459
mailto:Peter(dot)Keller(at)bvv(dot)bayern(dot)de
..............................................................
Bezirksfinanzdirektion Muenchen - Vermessungsabteilung
Alexandrastr. 3
80538 Muenchen
Zimmer: 404
www: http://www.bayern.de/vermessung/
--

Browse pgsql-general by date

  From Date Subject
Next Message Peter Keller 1999-06-16 08:27:41 oid in PL/pgSQL
Previous Message Robert Chalmers 1999-06-16 05:20:11 initdb in 6.5 not creating 'postgres' db