odd error updating - varchar

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 character varying, but query expects character 
varying.
goole=# \d requests                                           Table "public.requests"    Column     |           Type
      |                             
 
Modifiers
----------------+--------------------------+-------------------------------------------------------------------r_id
     | integer                  | not null default 
 
nextval(('"requests_r_id_seq"'::text)::regclass)r_t_id         | character(1)             | not nullr_d_id         |
integer                 | not nullr_de_id        | integer                  | not nullr_s_id         | integer
       | not nullr_registration | character varying(12)    |r_chassis      | character varying(17)    |r_c_id         |
integer                 | not nullr_vehicle      | character varying(20)    |r_fuel         | character varying(50)
|r_pack_mats   | text                     |r_delivery     | timestamp with time zone |r_salesman     | integer
       |r_created      | timestamp with time zone | default now()r_completed    | timestamp with time zone |r_u_id
  | integer                  |r_plates       | character(1)             |r_book_pack    | boolean                  |
 
Indexes:   "requests_pkey" PRIMARY KEY, btree (r_id)   "request_short_vin" btree ("substring"(r_chassis::text,
'(.{11}$)'::text))  "requests_completed_index" btree (r_completed)   "requests_delivery_index" btree (r_delivery)
"requests_regno_index"btree (r_registration)   "requests_vin_index" btree (r_chassis)
 
Triggers:   "RI_ConstraintTrigger_110446" AFTER INSERT OR UPDATE ON requests FROM 
request_types NOT DEFERRABLE INITIALLY IMMEDIATE
FOR EACH ROW EXECUTE 
PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'requests', 'request_types', 'UNSPECIFIED', 'r_t_id', 't_id
')   "RI_ConstraintTrigger_110449" AFTER INSERT OR UPDATE ON requests FROM 
dealerships NOT DEFERRABLE INITIALLY IMMEDIATE FO
R EACH ROW EXECUTE 
PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'requests', 'dealerships', 'UNSPECIFIED', 'r_d_id', 'd_id')
"RI_ConstraintTrigger_110452"AFTER INSERT OR UPDATE ON requests FROM 
 
departments NOT DEFERRABLE INITIALLY IMMEDIATE FO
R EACH ROW EXECUTE 
PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'requests', 'departments', 'UNSPECIFIED', 'r_de_id', 'de_id')
"RI_ConstraintTrigger_110455"AFTER INSERT OR UPDATE ON requests FROM 
 
request_states NOT DEFERRABLE INITIALLY IMMEDIATEFOR EACH ROW EXECUTE 
PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'requests', 'request_states', 'UNSPECIFIED', 'r_s_id', 's_
id')   "RI_ConstraintTrigger_110458" AFTER INSERT OR UPDATE ON requests FROM 
customers NOT DEFERRABLE INITIALLY IMMEDIATE FOR
EACH ROW EXECUTE 
PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'requests', 'customers', 'UNSPECIFIED', 'r_c_id', 'c_id')
"RI_ConstraintTrigger_110461"AFTER INSERT OR UPDATE ON requests FROM 
 
users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACHROW EXECUTE 
PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'requests', 'users', 'UNSPECIFIED', 'r_salesman', 'u_id')
"RI_ConstraintTrigger_110464"AFTER INSERT OR UPDATE ON requests FROM 
 
users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACHROW EXECUTE 
PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'requests', 'users', 'UNSPECIFIED', 'r_u_id', 'u_id')
"RI_ConstraintTrigger_110468"AFTER DELETE ON requests FROM recipients NOT 
 
DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW
EXECUTE 
PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'recipients', 'requests', 'UNSPECIFIED', 're_id', 'r_id')
"RI_ConstraintTrigger_110469"AFTER UPDATE ON requests FROM recipients NOT 
 
DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW
EXECUTE 
PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'recipients', 'requests', 'UNSPECIFIED', 're_id', 'r_id')
"RI_ConstraintTrigger_110474"AFTER DELETE ON requests FROM comments NOT 
 
DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EX
ECUTE 
PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'comments', 'requests', 'UNSPECIFIED', 'co_r_id', 'r_id')
"RI_ConstraintTrigger_110475"AFTER UPDATE ON requests FROM comments NOT 
 
DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EX
ECUTE 
PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'comments', 'requests', 'UNSPECIFIED', 'co_r_id', 'r_id')
"RI_ConstraintTrigger_110509"AFTER INSERT OR UPDATE ON requests FROM 
 
plates NOT DEFERRABLE INITIALLY IMMEDIATE FOR EAC
H ROW EXECUTE 
PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'requests', 'plates', 'UNSPECIFIED', 'r_plates', 'pl_id')

goole=#
-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000