Postgres Pro
Downloads
Home   >   mailing lists

Re: COMMIT leads to ROLLBACK - Mailing list pgsql-hackers

From Tom Lane
Subject Re: COMMIT leads to ROLLBACK
Date
Msg-id 6924.1148231242@sss.pgh.pa.us
Whole thread Raw
In response to COMMIT leads to ROLLBACK  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-hackers
Tree view 
"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:
>     Issuing a COMMIT or an END as the last command leads to a
> ROLLBACK. Although the behaviour is correct, shouldn't the user be
> atleast warned about having issued a wrong command to end the
> transaction?

Please see the archives.  This has been discussed ad nauseam before,
and no consensus has emerged to change it.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: COMMIT leads to ROLLBACK
Next
From: "Jaime Casanova"
Date:
Subject: Re: COMMIT leads to ROLLBACK