Skip site navigation (1) Skip section navigation (2)

Re: fail-safe sql update triggers

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Michael Monnerie" <michael(dot)monnerie(at)is(dot)it-management(dot)at>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: fail-safe sql update triggers
Date: 2010-09-03 16:23:23
Message-ID: 4C80DAAB02000025000351AA@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Michael Monnerie<michael(dot)monnerie(at)is(dot)it-management(dot)at> 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

In response to

Responses

pgsql-admin by date

Next:From: Rob RichardsonDate: 2010-09-03 17:50:54
Subject: Re: fail-safe sql update triggers
Previous:From: Michael MonnerieDate: 2010-09-03 13:03:19
Subject: fail-safe sql update triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group