PostgreSQL Bugs List wrote: > Description: Misleading Commit message > > Details: > > In a block transaction, whether or not there were errors in the transaction > issuing a commit; returns a COMMIT confirmation. > > In a block transaction, after a statement fails, all other statements have > the (frustratingly) nice message ERROR: current transaction is aborted, > commands ignored until end of transaction block > > It seems to me, it would be helpful to change the commit message to reflect > a ROLLBACK if the transaction is not actually committed. > > Let me know if you want an example :-) > > PS: the bug tracking thingo thinks my email ([EMAIL PROTECTED]) is not a > valid address. > Funny I get a whole lotta postgres mail there...
Uh, the tag indicates the COMMIT completed, not that it was a success. If we throw an error on a COMMIT, people willl think we did not close the transacction, and if we return a ROLLBACK, they will think they issued a rollback. I don't think we can easily change the current behavior. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
