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

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026