Search Postgresql Archives

Re : Re : Update columns in same table from update trigger?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you for our help anyway!



De : Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
À : Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Cc : Pablo Romero Abiti <pabiti@xxxxxxxxx>; "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Envoyé le : Dimanche 24 Juillet 2011 4h06
Objet : Re: Re : 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!





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux