Re: odd error updating - varchar

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: odd error updating - varchar
Date: 2007-12-14 17:17:42
Message-ID: 9089.1197652662@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2007-12-14 17:24:14 Re: SELECT MAX returns wrong value
Previous Message Gary Stainburn 2007-12-14 17:02:52 odd error updating - varchar