[GENERAL] trigger on view returning created serial

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

Re: [GENERAL] trigger on view returning created serial

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