On Mon, 20 May 2024, Alban Hertroys wrote:
That aside, while you’re not absolutely 100% definitely sure that an UPDATE or DELETE statement is going to do exactly what you intended, and for good measure if you are, wrapping such statements in a transaction allows you to ROLLBACK to get back to the state that you started from.
Alban, That's excellent advice and I'll do so in all future data manipulation scripts. In the current situation psql did return that 457 rows had been updated. Much appreciated, Rich
