Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1433: domain check constraint not checked when adding new column - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1433: domain check constraint not checked when adding new column
Date
Msg-id 26837.1106608980@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1433: domain check constraint not checked when adding new column  ("craig perras" <craigp98072@yahoo.com>)
List pgsql-bugs
Tree view 
"craig perras" <craigp98072@yahoo.com> 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

pgsql-bugs by date:

Previous
From: Edmund Bacon
Date:
Subject: Re: BUG #1440: ecpg seg faults
Next
From: Tom Lane
Date:
Subject: Re: BUG #1435: Optimizer not using index on large tables when inner joining two views