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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "craig perras" <craigp98072(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1433: domain check constraint not checked when adding new column
Date: 2005-01-24 23:23:00
Message-ID: 26837.1106608980@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"craig perras" <craigp98072(at)yahoo(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew - Supernews 2005-01-24 23:29:12 incorrect index behaviour with rtree on box values
Previous Message Pavel Stehule 2005-01-24 22:50:34 plperl trigger crash backend 8.0.rc4