Re : Re : Update columns in same table from update trigger? - Mailing list pgsql-general

From Pablo Romero Abiti
Subject Re : Re : Update columns in same table from update trigger?
Date
Msg-id 1311515736.14003.YahooMailNeo@web161605.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: Re : Update columns in same table from update trigger?  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
Thank you for our help anyway!



De : Alban Hertroys <dalroi@solfertje.student.utwente.nl>
À : Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Cc : Pablo Romero Abiti <pabiti@yahoo.com>; "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Envoyé le : Dimanche 24 Juillet 2011 4h06
Objet : Re: Re : [GENERAL] Update columns in same table from update trigger?

On 24 Jul 2011, at 11:00, Alban Hertroys wrote:

> You can't fire a trigger on non-existant data.


I just realised the above statement is a little inexact: you can't fire row-level triggers on non-existant data.

You can still fire statement-level triggers on them, but with those you won't have information about which row(s) were involved, so it won't help your case.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:1288,4e2be0a412091498931284!




pgsql-general by date:

Previous
From: Yan Chunlu
Date:
Subject: Re: streaming replication does not work across datacenter with 20ms latency?
Next
From: Adarsh Sharma
Date:
Subject: Would it be possible