ALTER TYPE ... USING(NULL) / NOT NULL violation

From: "Alexander M(dot) Pravking" <fduch(at)antar(dot)bryansk(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: ALTER TYPE ... USING(NULL) / NOT NULL violation
Date: 2006-07-04 11:03:02
Message-ID: 20060704110302.GB87356@dyatel.antar.bryansk.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

If a column type is being changed with USING (NULL) clause,
NOT NULL constraint seems not to be checked:

fduch(at)~=# CREATE table test (x integer not null);
CREATE TABLE
fduch(at)~=# INSERT INTO test VALUES (1);
INSERT 0 1
fduch(at)~=# ALTER TABLE test ALTER x TYPE boolean USING (NULL);
ALTER TABLE
fduch(at)~=# \d test
Table "public.test"
Column | Type | Modifiers
--------+---------+-----------
x | boolean | not null

fduch(at)~=# SELECT * from test;
x
---

(1 row)

fduch(at)~=# SELECT version();
version
------------------------------------------------------------------------------------------------
PostgreSQL 8.1.4 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC) 3.4.4 [FreeBSD] 20050518
(1 row)

8.0 branch has the same behavour.

--
Fduch M. Pravking

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-07-04 13:56:29 Re: query very slow when enable_seqscan=on
Previous Message Tomasz Ostrowski 2006-07-04 08:37:33 Re: query very slow when enable_seqscan=on