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?
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster