Catching "UPDATE 0"

From: <enio(at)pmpf(dot)rs(dot)gov(dot)br>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Catching "UPDATE 0"
Date: 2003-11-10 13:56:04
Message-ID: 20031110135604.65F2346E30@mail.passofundo.rs.gov.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,
I am trying to catch the "UPDATE 0" condition in postgresql.
I have tried it using triggers, but they are only fired when there
effectively is an update. So, an Update 0 does not fire triggers.
Is it possible to make the backend raise and exception when the
Update 0 happens? This would be useful for knowing when records
were not updated as those which are in concurrent transactions.
By the way, How do I know if a transaction was really committed
and not rollbacked?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2003-11-10 14:18:31 Re: Experimental patch for inter-page delay in VACUUM
Previous Message Jan Wieck 2003-11-10 13:46:36 Re: Experimental patch for inter-page delay in VACUUM