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
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 |