BUG #6328: Wrong error message for insert-sql - Mailing list pgsql-bugs

From eikenberg@golze.de
Subject BUG #6328: Wrong error message for insert-sql
Date
Msg-id E1RXwdb-0007pb-Nq@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #6328: Wrong error message for insert-sql
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6328
Logged by:          Rigoletto Eikenberg
Email address:      eikenberg@golze.de
PostgreSQL version: 9.0.0
Operating system:   windows server 2008 R2
Description:=20=20=20=20=20=20=20=20

The sql
   INSERT INTO auftragpos (orderno,position,item) VALUES
('testorder18',1,00123);
works fine,

but
   INSERT INTO auftragpos (orderno,position,item) VALUES
(testorder18,1,00123);
brings error:
FEHLER:  Spalte =C2=BBtestorder18=C2=AB existiert nicht (Column =C2=BBtesto=
rder18=C2=AB not
exists)
LINE 1: ...T INTO auftragpos (orderno,position,item) VALUES (testorder1...

But =C2=BBtestorder18=C2=AB is a value, not a column-name!?!?
If there is a problem it should bring a message that the value for column
"orderno" has the wrong format.

Regards
Rigoletto

pgsql-bugs by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: BUG #6327: Prefix full-text-search fails for hosts with complicated names
Next
From: Jivendra
Date:
Subject: copy cmd err