From: | pgmail(at)joh(dot)to |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7635: psql -1 and \connect |
Date: | 2012-11-01 13:12:53 |
Message-ID: | E1TTuZp-00008O-4e@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 7635
Logged by: Marko Tiikkaja
Email address: pgmail(at)joh(dot)to
PostgreSQL version: 9.1.6
Operating system: OSX something
Description:
Hi,
With a simple script like this:
\connect postgres
CREATE TABLE foo();
ERROR_HERE;
You get output like this:
You are now connected to database "postgres" as user "postgres".
CREATE TABLE
psql:singletxn.sql:3: ERROR: syntax error at or near "ERROR_HERE"
LINE 1: ERROR_HERE;
^
psql:singletxn.sql:0: WARNING: there is no transaction in progress
Which isn't really what I expected :-(
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.
From | Date | Subject | |
---|---|---|---|
Next Message | pgmail | 2012-11-01 14:04:56 | BUG #7636: \ef doesn't honor ON_ERROR_ROLLBACK |
Previous Message | Dave Page | 2012-11-01 11:38:27 | Re: BUG #7628: Installation of PostgreSQL 9.2.1 on Windows 7 may take too long |