From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | elein <elein(at)norcov(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #1118: Misleading Commit message |
Date: | 2004-03-28 03:41:38 |
Message-ID: | 200403280341.i2S3fcx02653@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
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 (elein(at)varlena(dot)com) 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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-03-28 15:23:26 | Re: BUG #1118: Misleading Commit message |
Previous Message | PostgreSQL Bugs List | 2004-03-28 03:24:08 | BUG #1118: Misleading Commit message |
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2004-03-28 04:50:58 | Re: default enconding |
Previous Message | PostgreSQL Bugs List | 2004-03-28 03:24:08 | BUG #1118: Misleading Commit message |