Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: psql's \r does not reset parenthesis depth counter
Date: 2002-03-19 00:13:05
Message-ID: 200203190013.g2J0D5g09953@candle.pha.pa.us (view raw or flat)
Thread:
Lists: 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(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

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2002-03-19 02:57:19
Subject: Re: referential constraint bug
Previous:From: pgsql-bugsDate: 2002-03-18 17:18:09
Subject: Bug #622: jdbc driver exception: failed to get datetime field from a table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group