From: | Peter Keller <peter(dot)keller(at)bvv(dot)bayern(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | oid in PL/pgSQL |
Date: | 1999-06-16 08:27:41 |
Message-ID: | 37675FFD.812E7546@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
Vermessungsrat z.A. 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/
--
From | Date | Subject | |
---|---|---|---|
Next Message | Ming-Hung Eng | 1999-06-16 09:54:00 | HELP needed : COPY datas from file |
Previous Message | Peter Keller | 1999-06-16 08:15:48 | oid in PL/pgSQL |