Red Hat Bugzilla – Bug 227688
Attribute type error when updating varchar column
Last modified: 2013-07-02 23:12:08 EDT
+++ This bug was initially created as a clone of Bug #227522 +++
Description of problem:
In a table with a varchar column and a check constraint, updating that column
gives "ERROR: attribute 1 has wrong type".
Version-Release number of selected component (if applicable):
Steps to Reproduce:
> createdb testdb
> psql testdb
Welcome to psql 8.1.7, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
testdb=> create table t (pa_status varchar(100));
testdb=> alter table t add constraint rhpt_projects_pa_status_ck check
(pa_status = 'submitted' or pa_status = 'approved' or pa_status = 'closed');
testdb=> insert into t values ('approved');
INSERT 0 1
testdb=> update t set pa_status = 'approved';
ERROR: attribute 1 has wrong type
DETAIL: Table has type character varying, but query expects character varying.
Error, update fails
Update should work
This worked with the previous FC6 version of PostgreSQL.
-- Additional comment from firstname.lastname@example.org on 2007-02-06 13:18 EST --
Yeah, it's broken :-( ... there'll be an 8.1.8 real soon now ...
This problem also affects our initial attempt to fix bug #225496 in RHEL5 --- it's actually caused by the
security fix, which was being too strict about type matching. Security team, please flag this bug as
approved for rhel-5.1.0 ...
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on the solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.