Re: psql's \r does not reset parenthesis depth counter

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: psql's \r does not reset parenthesis depth counter
Дата
Msg-id 200203190013.g2J0D5g09953@candle.pha.pa.us
обсуждение исходный текст
Ответ на psql's \r does not reset parenthesis depth counter  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Tom Lane wrote:
> In current sources:
>
> regression=# create table tt1 (i2 int2, i4 int4, f8 float8,
> regression(# \r
> Query buffer reset (cleared).
> regression(# select 2;
> regression(# -- nothing happens because psql still wants a right paren
>
> Not sure if there is any other state that needs to be reset along
> with the paren counter.

Are you sure you are running current?

    test=>  create table tt1 (i2 int2, i4 int4, f8 float8,
    test(> \r
    Query buffer reset (cleared).
    test=> select 2;
     ?column?
    ----------
            2
    (1 row)

This was fixed in my post 7.2 patch.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

Предыдущее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: Bug #622: jdbc driver exception: failed to get datetime field from a table
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: referential constraint bug