pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedodd error updating - varchar
2+ messages / 2 participants
[nested] [flat]
* odd error updating - varchar
@ 2007-12-14 17:02 Gary Stainburn <gary.stainburn@ringways.co.uk>
2007-12-14 17:17 ` Re: odd error updating - varchar Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Gary Stainburn @ 2007-12-14 17:02 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: odd error updating - varchar
2007-12-14 17:02 odd error updating - varchar Gary Stainburn <gary.stainburn@ringways.co.uk>
@ 2007-12-14 17:17 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2007-12-14 17:17 UTC (permalink / raw)
To: Gary Stainburn <gary.stainburn@ringways.co.uk>; +Cc: pgsql-sql
Gary Stainburn <gary.stainburn@ringways.co.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-12-14 17:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-12-14 17:02 odd error updating - varchar Gary Stainburn <gary.stainburn@ringways.co.uk>
2007-12-14 17:17 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox