Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BD6302E34A8 for ; Fri, 14 Dec 2007 13:03:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 45192-03-4 for ; Fri, 14 Dec 2007 13:03:49 -0400 (AST) Received: from mail.ringways.co.uk (hub.ringways.co.uk [80.193.83.130]) by postgresql.org (Postfix) with ESMTP id 785232E34AD for ; Fri, 14 Dec 2007 13:03:49 -0400 (AST) Received: from eddie.ringways.co.uk ([10.1.1.115]) by mail.ringways.co.uk with esmtp (Exim 4.62) (envelope-from ) id 1J3DtX-0007bc-MG for pgsql-sql@postgresql.org; Fri, 14 Dec 2007 17:00:15 +0000 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-sql@postgresql.org Subject: odd error updating - varchar Date: Fri, 14 Dec 2007 17:02:52 +0000 User-Agent: KMail/1.9.5 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200712141702.52991.gary.stainburn@ringways.co.uk> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/85 X-Sequence-Number: 29777 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"('', '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"('', '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"('', '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"('', '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"('', '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"('', '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"('', '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"('', '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"('', '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"('', '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"('', '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"('', '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