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 null
r_d_id | integer | not null
r_de_id | integer | not null
r_s_id | integer | not null
r_registration | character varying(12) |
r_chassis | character varying(17) |
r_c_id | integer | not null
r_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 IMMEDIATE
FOR 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 EACH
ROW 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 EACH
ROW 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
