Re: psql's \r does not reset parenthesis depth counter - Mailing list 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