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

BUG #2980: check constraint fails on update

From: "Walter Cruz" <walter(dot)php(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2980: check constraint fails on update
Date: 2007-02-07 16:22:57
Message-ID: 200702071622.l17GMvZP079941@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

Responses

pgsql-bugs by date

Next:From: Marcio A. SeppDate: 2007-02-07 16:37:41
Subject: ENC: Possible problem with type bigserial in pg_dump/pg_restore
Previous:From: Marcio A. SeppDate: 2007-02-07 14:51:22
Subject: Possible problem with type bigserial in pg_dump/pg_restore

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