"craig perras" <[EMAIL PROTECTED]> writes:
> 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
Fixed for 8.0.1.
regards, tom lane
-
"craig perras" <[EMAIL PROTECTED]> writes:
> Domain check constraint not checked when adding new column.
Hmm. It does work for cases like
regression=# create domain posint int check (value > 0);
CREATE DOMAIN
regression=# alter table foo add column f5 posint default 0;
ERROR: value for domain p
The following bug has been logged online:
Bug reference: 1433
Logged by: craig perras
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0 release
Operating system: win2000
Description:domain check constraint not checked when adding new
column
Details:
Domain ch
