On Thu, 01 Nov 2012 22:29:50 +0100, Tom Lane <t...@sss.pgh.pa.us> wrote:
pgm...@joh.to writes:
I know it's not clear what to do with --single-transaction if a script
is
\connecting to multiple databases in a single file, but IMHO it should
at
least work correctly for the single database case.
Define "correctly" --- I would expect \connect to establish a new
connection even if the same target database is named. We can't change
that behavior without breaking existing scripts, IMO --- for example, \c
is a long-established way to reset GUC settings, prepared statements,
etc.
Hmm.. I only considered the case where the \connect is at the beginning
of the file. I see your point.
Perhaps we should have \connect fail outright in -1 mode. I can see
no way for it to do anything and still maintain the expectation of a
single transaction.
Would supporting a \connect at the very beginning of the file seem
possible? Maybe even only if it's to the same database?
Regards,
Marko Tiikkaja
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
