From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stefan Sylla <stefansylla@gmx.de>
cc: pgsql-sql@postgresql.org
Subject: Re: update column based on postgis query on anther table
In-reply-to: <51E4B5A5.4040805@gmx.de>
References: <51E4B5A5.4040805@gmx.de>
Comments: In-reply-to Stefan Sylla <stefansylla@gmx.de>
 message dated "Tue, 16 Jul 2013 09:53:25 +0700"
Date: Tue, 16 Jul 2013 01:24:33 -0400
Message-ID: <317.1373952273@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Stefan Sylla <stefansylla@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