BUG #7635: psql -1 and \connect

Поиск
Список
Период
Сортировка
От pgmail@joh.to
Тема BUG #7635: psql -1 and \connect
Дата
Msg-id E1TTuZp-00008O-4e@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7635: psql -1 and \connect  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7635
Logged by:          Marko Tiikkaja
Email address:      pgmail@joh.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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: BUG #7628: Installation of PostgreSQL 9.2.1 on Windows 7 may take too long
Следующее
От: pgmail@joh.to
Дата:
Сообщение: BUG #7636: \ef doesn't honor ON_ERROR_ROLLBACK