BUG #6328: Wrong error message for insert-sql

From: eikenberg(at)golze(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6328: Wrong error message for insert-sql
Date: 2011-12-06 15:08:55
Message-ID: E1RXwdb-0007pb-Nq@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6328
Logged by: Rigoletto Eikenberg
Email address: eikenberg(at)golze(dot)de
PostgreSQL version: 9.0.0
Operating system: windows server 2008 R2
Description:

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 »testorder18« existiert nicht (Column »testorder18« not
exists)
LINE 1: ...T INTO auftragpos (orderno,position,item) VALUES (testorder1...

But »testorder18« 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gregg Jaskiewicz 2011-12-06 15:14:56 Re: [BUGS] BUG #6325: Useless Index updates
Previous Message Oleg Bartunov 2011-12-06 14:55:12 Re: BUG #6327: Prefix full-text-search fails for hosts with complicated names