Group: pgsql.sql


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