Re: update column based on postgis query on anther table

From: ssylla <stefansylla(at)gmx(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: update column based on postgis query on anther table
Date: 2013-07-16 07:57:48
Message-ID: 1373961468438-5763904.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Tom,

I tried changing the trigger to be BEFORE instead of AFTER:

create trigger test1_point_get_id_test1_poly
before insert or update on test1_point for each row execute procedure
test1_point_get_id_test1_poly();

But the problem persits, the column id_test1_poly remains empty.

Stefan

--
View this message in context: http://postgresql.1045698.n5.nabble.com/update-column-based-on-postgis-query-on-anther-table-tp5763886p5763904.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Igor Neyman 2013-07-16 13:45:55 Re: update column based on postgis query on anther table
Previous Message Tom Lane 2013-07-16 05:24:33 Re: update column based on postgis query on anther table