-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello
I want to report that psql --single-transaction does not work as one can expect after reading the help information for psql. psql --help says: - -1 ("one"), --single-transaction: execute command file as a single transaction If you run "psql -1 < sql_file.sql" insteed of "psql -1 -f sql_file.sql" the single-transaction parameter will not work. Test case: ========== CREATE DATABASE test; \c test CREATE TABLE check_psql(id int, code text); \q # cat check_psql.sql INSERT INTO check_psql (id,code) VALUES (1,'code1'); INSERT INTO check_psql (id,code) VALUES (2,code2); # psql -1 test -f check_psql.sql INSERT 0 1 psql:check_psql.sql:2: ERROR: column "code2" does not exist LINE 1: INSERT INTO check_psql (id,code) VALUES (2,code2); ^ # psql -1 test -c "SELECT * FROM check_psql" id | code - ----+------ (0 rows) # psql -1 test < /tmp/check_psql.sql INSERT 0 1 ERROR: column "code2" does not exist LINE 1: INSERT INTO check_psql (id,code) VALUES (2,code2); ^ #psql -1 test -c "SELECT * FROM check_psql" id | code - ----+------- 1 | code1 (1 row) The docs for psql at http://www.postgresql.org/docs/current/static/app-psql.html have the right information, ".... -1 --single-transaction When psql executes a script with the -f option ...." I think we should either update the psql --help information for - --single-transaction and say that this parameter only works together with -f or update the psql code so psql -1 < file.sql also works. regards, - -- Rafael Martinez Guerrero Center for Information Technology University of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (GNU/Linux) iEYEARECAAYFAlIKPQEACgkQBhuKQurGihQaGwCggvy+Fgiw1TlseZKM8oq4U/na cgQAnRN4sw9NHBajG57wL0P+08p6Nb3y =cNHB -----END PGP SIGNATURE----- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers