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