Sent from my iPhone İ On 16 Tem 2013, îat 08:24, Tom Lane <t...@sss.pgh.pa.us> wrote:
> Stefan Sylla <stefansy...@gmx.de> writes: >> Now I want to use a trigger function to automatically update the column >> 'id_test1_poly' in tabel 'test1_point': > >> /**/ >> create or replace function test1_point_get_id_test1_poly() returns >> trigger as $$ >> begin >> new.id_test1_poly=test1_point_get_id_test1_poly(new.id); >> return new; >> end; >> $$ >> language plpgsql volatile; >> -- create trigger for function: >> create trigger test1_point_get_id_test1_poly >> after insert or update on test1_point for each row execute procedure >> test1_point_get_id_test1_poly(); > > I think you need that to be a BEFORE insert or update trigger. In > an AFTER trigger, it's too late to affect the stored row. > > regards, tom lane > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
