Horton

Re: [HACKERS] update_pg_pwd trigger does not work very well

Don Baccus <dhogaza@pacifier.com>

View thread
From: Don Baccus <dhogaza@pacifier.com>
To: Jan Wieck <wieck@debis.com>, Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Development <pgsql-hackers@postgreSQL.org>
Date: 2000-02-28T14:16:20Z
Lists: pgsql-hackers 
At 08:34 AM 2/28/00 +0100, Jan Wieck wrote:

>    I consider it a hack, since this particular trigger  needs  a
>    global flag known explicitly by xact routines. I like general
>    solutions instead.

It's very much a hack.  Something like the "on commit execute()" 
solution would be much better.  How crucial is a short-term fix
for this particular problem?  Could it wait until a more generalized
facility is provided?

If not I suppose it could be hacked in with copious notes that it
should be redone later.



- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.