Re: psql swallowed my "BEGIN;" on reset... user beware?

[Moshe Jacobson <moshe@xxxxxxxxxxxx>]

On Sun, Sep 29, 2013 at 2:18 AM, Ken Tanzer <ken.tanzer@xxxxxxxxx> wrote:

After restarting the server in another window, I was surprised that my command did not run in a transaction:

spc_test_scratch=# BEGIN; DROP VIEW IF EXISTS ptest_mip ; DROP VIEW rent_info; \i create.view.rent_info.sql

FATAL:  terminating connection due to administrator command

server closed the connection unexpectedly

        This probably means the server terminated abnormally

        before or while processing the request.

The connection to the server was lost. Attempting reset: Succeeded.

NOTICE:  view "ptest_mip" does not exist, skipping

DROP VIEW

DROP VIEW

CREATE VIEW

spc_test_scratch=# commit;

WARNING:  there is no transaction in progress

COMMIT

This seems like a pretty serious issue. My opinion is that psql should refuse to execute further commands on a line of input if any of them fails due to a terminated connection.

Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering

2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@xxxxxxxxxxxx | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle