double error msg [ 8.0 rc1 ]

Started by G u i d o B a r o s i oabout 21 years ago3 messages
#1G u i d o B a r o s i o
gbarosio@uolsinectis.com.ar

Dear all,

Found a similar message on the archives, but from 2 years ago, and not too much about this.

(8.0 rc1 the guilty one)

guido=# \d test1
Table "public.test1"
Column | Type | Modifiers
--------+---------+------------------------------------------------------
a | integer | not null default nextval('public.test1_a_seq'::text)
b | integer |
Tablespace: "dbspace1"

guido=# insert into test1 (b) values (1);
INSERT 17246 1
guido=# insert into test1 (b) values (b);
ERROR: column "b" does not exist
ERROR: column "b" does not exist

2 ERROR msg's.

Cause I didn't seen a previous discussion about this, I guess that this could be a 'particularly only me' problem. The point cames more strange if I grant that on previous releases (7.4.x) the error msg didn't came to me twice a time.

A direction for this one would be apreciated, a where to look at.

Thanks in advance.

Guido.

#2Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: G u i d o B a r o s i o (#1)
Re: double error msg [ 8.0 rc1 ]

ERROR: column "b" does not exist
ERROR: column "b" does not exist

2 ERROR msg's.

Cause I didn't seen a previous discussion about this, I guess that this could be a 'particularly only me' problem. The point cames more strange if I grant that on previous releases (7.4.x) the error msg didn't came to me twice a time.

A direction for this one would be apreciated, a where to look at.

Sure you're not running psql output and postgres output on the same
terminal?

Chris

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: G u i d o B a r o s i o (#1)
Re: double error msg [ 8.0 rc1 ]

G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar> writes:

guido=# insert into test1 (b) values (b);
ERROR: column "b" does not exist
ERROR: column "b" does not exist

2 ERROR msg's.

The postmaster's stderr is pointed at your terminal, so you're getting
the postmaster log output in addition to what psql prints.

regards, tom lane