BUG #1433: domain check constraint not checked when adding new column

From: "craig perras" <craigp98072(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1433: domain check constraint not checked when adding new column
Date: 2005-01-22 08:28:24
Message-ID: 200501220828.j0M8SOvJ006967@developer.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1433
Logged by: craig perras
Email address: craigp98072(at)yahoo(dot)com
PostgreSQL version: 8.0 release
Operating system: win2000
Description: domain check constraint not checked when adding new
column
Details:

Domain check constraint not checked when adding new column.

repro:
add domain 'string' of base type text with non-null constraint
add column of type 'string' to table with existing rows
works; all rows have new column's value set to null

expected:
error: cannot add column due to non-null constraint in domain 'string'

notes:
could not insert a new row with non-null value for 'string' column (as
expected)
trying to add a column of type text with non-null constraint produces
expected error message

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Treat 2005-01-22 19:37:59 inconsitent tab completion in psql
Previous Message Sam Hahn 2005-01-22 02:25:27 BUG #1432: type "cube" does not exist