Thread: BUG #2974: broken CHECK constraint with varchar

The following bug has been logged online:

Bug reference:      2974
Logged by:          Michal Schwarz
Email address:      misch@czechin.cz
PostgreSQL version: 8.1.7
Operating system:   Fedora Core 6
Description:        broken CHECK constraint with varchar
Details:

CREATE TABLE t (c VARCHAR(20));
ALTER TABLE t ADD CONSTRAINT xyz CHECK (c IN ('A','B','C'));
INSERT INTO t VALUES ('A');

Results:
ERROR:  attribute 1 has wrong type
DETAIL:  Table has type character varying, but query expects character
varying.

In previous versions, everything worked correctly. Problem arised in 8.1.7
(maybe only in Fedora release???). When i returned back to 8.1.6, everything
worked again.

Michal Schwarz wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2974
> Logged by:          Michal Schwarz
> Email address:      misch@czechin.cz
> PostgreSQL version: 8.1.7
> Operating system:   Fedora Core 6
> Description:        broken CHECK constraint with varchar
> Details:
>
> CREATE TABLE t (c VARCHAR(20));
> ALTER TABLE t ADD CONSTRAINT xyz CHECK (c IN ('A','B','C'));
> INSERT INTO t VALUES ('A');
>
> Results:
> ERROR:  attribute 1 has wrong type
> DETAIL:  Table has type character varying, but query expects character
> varying.
>
> In previous versions, everything worked correctly. Problem arised in 8.1.7
> (maybe only in Fedora release???). When i returned back to 8.1.6, everything
> worked again.

Please upgrade to 8.1.8.  That was a rush release to fix this bug added
in 8.1.7.

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +