|
|
 | | From: | craig perras | | Subject: | BUG #1433: domain check constraint not checked when adding new column | | Date: | Sat, 22 Jan 2005 08:28:24 GMT |
|
|
 |
The following bug has been logged online:
Bug reference: 1433
Logged by: craig perras
Email address: craigp98072@yahoo.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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
|
|
|
