oid in PL/pgSQL
| От | Peter Keller |
|---|---|
| Тема | oid in PL/pgSQL |
| Дата | |
| Msg-id | 37675FFD.812E7546@bvv.bayern.de обсуждение исходный текст |
| Список | 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.Keller@bvv.bayern.de
..............................................................
Bezirksfinanzdirektion Muenchen - Vermessungsabteilung
Alexandrastr. 3
80538 Muenchen
Zimmer: 404
www: http://www.bayern.de/vermessung/
--
В списке pgsql-general по дате отправления: