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

BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update'

From: "Martin Pitt" <martin(at)piware(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update'
Date: 2007-02-06 07:52:19
Message-ID: 200702060752.l167qJ9o055078@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2971
Logged by:          Martin Pitt
Email address:      martin(at)piware(dot)de
PostgreSQL version: 8.2.2
Operating system:   Linux
Description:        8.1.7/8.2.2 break constraint checking for 'update'
Details: 

Originally reported on https://launchpad.net/bugs/83505:

db> create table foo (bar VARCHAR(20) NOT NULL check (bar in
('FOO','BAR')));
CREATE TABLE

db> insert into foo (bar) values ('FOO');
INSERT 0 1

db> update foo set bar = 'BAR';
ERROR: attribute 1 has wrong type
DETAIL: Table has type character varying, but query expects character
varying.

This worked in the previous versions (8.2.1/8.1.6). I checked that it does
not affect 7.4.16.

Thank you!

Responses

pgsql-bugs by date

Next:From: Tomas SzepeDate: 2007-02-06 09:10:32
Subject: 8.2.2 regression with indices on user functions, 8.2.1 works
Previous:From: William ZHANGDate: 2007-02-06 06:28:15
Subject: BUG #2970: "FETCH ABSOLUTE -1" from a holdable cursor failed

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