"Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)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