Postgres Pro
Downloads
Home   >   mailing lists

Re: odd error updating - varchar - Mailing list pgsql-sql

From Tom Lane
Subject Re: odd error updating - varchar
Date
Msg-id 9089.1197652662@sss.pgh.pa.us
Whole thread Raw
In response to odd error updating - varchar  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: odd error updating - varchar
Next
From: "Scott Marlowe"
Date:
Subject: Re: SELECT MAX returns wrong value