pgmail@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.
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.
regards, tom lane