Skip site navigation (1) Skip section navigation (2)

Re: BUG #2980: check constraint fails on update

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Walter Cruz <walter(dot)php(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2980: check constraint fails on update
Date: 2007-02-08 16:43:44
Message-ID: 45CB5340.40106@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
This is a known issue with 8.1.7. 8.1.8 was released shortly after 8.1.7 
  because of this.

Walter Cruz wrote:
-> The following bug has been logged online:
> 
> Bug reference:      2980
> Logged by:          Walter Cruz
> Email address:      walter(dot)php(at)gmail(dot)com
> PostgreSQL version: 8.1.7
> Operating system:   Linux
> Description:        check constraint fails on update
> Details: 
> 
> Hi All. A simple table to test:
> 
> CREATE TABLE simples
> (
>   coluna varchar(10)
> ) 
> WITHOUT OIDS;
> 
> ALTER TABLE simples
>   ADD CONSTRAINT simples_coluna_check CHECK (coluna::text = 'girafa'::text
> OR coluna::text = 'bode'::text);
> 
> INSERT INTO simples (coluna) VALUES ('girafa');
> (ok)
> 
> INSERT INTO simples (coluna) VALUES ('bode');
> (ok)
> 
> INSERT INTO simples (coluna) VALUES ('macaco'); (violates constraints, ok).
> 
> 
> UPDATE simples set coluna = 'girafa';
> 
> FAILS!
> 
> ERROR:  attribute 1 has wrong type
> DETAIL:  Table has type character varying, but query expects character
> varying.
> 
> "PostgreSQL 8.1.7 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2
> 20061115 (prerelease) (Debian 4.1.1-21)"
> 
> Works with 8.1.3 windows, 8.1.4 ubuntu, 8.2 windows.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-02-08 16:55:04
Subject: Re: Possible problem with type bigserial in pg_dump/pg_restore
Previous:From: Guillaume SmetDate: 2007-02-08 16:37:16
Subject: Re: BUG #2979: Functional indexes ERROR while updating table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group