Re: [SQL] odd error updating - varchar

2007-12-14 Thread Tom Lane
Gary Stainburn <[EMAIL PROTECTED]> 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.

[SQL] odd error updating - varchar

2007-12-14 Thread Gary Stainburn
I am trying to update a table and I'm getting an odd error. I've narrowed it down to one attribute, but can't see what the prolem is. Anyone got any ideas? goole=# update requests set r_chassis = 'GAJD7P26209' where r_id = 18560; ERROR: attribute 7 has wrong type DETAIL: Table has type charac