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 по дате отправления: