On Tue, Aug 13, 2013 at 04:04:50PM +0200, Rafael Martinez wrote:
-----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.
This will be fixed in PG 9.3; from the release notes:

         Allow the psql --single-transaction mode to work when
         reading from standard input (Fabien Coelho, Robert Haas)

         Previously this option only worked when reading from a file.

--
   Bruce Momjian <bruce@momjian.us> http://momjian.us
   EnterpriseDB http://enterprisedb.com

   + It's impossible for everything to be true. +

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedAug 13, '13 at 2:05p
activeAug 13, '13 at 2:20p
posts2
users2
websitepostgresql.org...
irc#postgresql

2 users in discussion

Bruce Momjian: 1 post Rafael Martinez: 1 post

People

Translate

site design / logo © 2017 Grokbase