On Tue, 2012-06-12 at 22:35 +0200, Philipp Kraus wrote: > Hello, > > I have created a view and on this view a trigger, which is called on an > insert command on the view. > Within the trigger I run an insert on a table and one of the table fields > uses a serial sequence, that > creates values. If I run in the trigger after the insert a "return NEW", the > field (id) which should > be set by the serial on the table is 0, so how can I get the new created > serial on the insert command > within the trigger function?
It's hard for me to tell exactly what problem you're describing, but it sounds similar to the one solved here: http://people.planetpostgresql.org/dfetter/index.php?/archives/66-VIEW-triggers-RETURNING....html If I misunderstood, please be more descriptive about what you are trying to do, what code you wrote, and what went wrong. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
