Subject: odd error updating - varchar
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 12/14/2007 12:17:42 PM
Gary Stainburn <gary.stainburn@ringways.co.uk> writes:
> goole=# update requests set r_chassis = 'GAJD7P26209' where r_id = 18560;
> ERROR: attribute 7 has wrong type
> DETAIL: Table has type character varying, but query expects character
> varying.
This looks like a bug that was fixed awhile ago.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|