Re: comparing NEW and OLD (any good this way?) - Mailing list pgsql-general

From Joshua Tolley
Subject Re: comparing NEW and OLD (any good this way?)
Date
Msg-id 20090723151329.GR25450@eddie
Whole thread Raw
In response to comparing NEW and OLD (any good this way?)  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
On Thu, Jul 23, 2009 at 01:40:45PM +0200, Willy-Bas Loos wrote:
> Is there anything to say against this, or can i go ahead and recommend
> this to everyone who wants to check if anything changed before doing
> what their update triggers do?

Perhaps 8.4's suppress_redundant_updates_trigger() could be helpful in this
case:

http://www.postgresql.org/docs/8.4/interactive/functions-trigger.html

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

Attachment

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: problem with pg_restore?
Next
From: Andrew Klaassen
Date:
Subject: Re: table.column in query results?