Re: fail-safe sql update triggers

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

 



Michael Monnerie<michael.monnerie@xxxxxxxxxxxxxxxxxxx> wrote:
 
> But that is error prone, because when the "filter" table is
> changed to have a new column, the UPDATE statement would not
> contain it. Is there a fail-proof shortcut?
 
You might draw inspiration for a C-based solution from Andrew
Dunstan's "minimal update" code.  A quick search turned up this, but
you might want to read the whole thread and look for possible later
versions of the code:
 
http://archives.postgresql.org/pgsql-hackers/2008-10/msg01111.php
 
-Kevin

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux