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