Tom Lane <[EMAIL PROTECTED]> writes:
> Jerry Sievers <[EMAIL PROTECTED]> writes:
>
> > I believe what's happening here is that the server doesn't realize
> > that the new column is going to have all nulls and that the check
> > constraint allows nulls. As such, the check evidently is being
> > e
Jerry Sievers <[EMAIL PROTECTED]> writes:
> I believe what's happening here is that the server doesn't realize
> that the new column is going to have all nulls and that the check
> constraint allows nulls. As such, the check evidently is being
> evaluated for each row of the table.
Yup, that's ri
EnterpriseDB 8.2.4
create domain foodomain text check (value in ('val1', 'val2'));
alter table bigtable add foodomain;
I believe what's happening here is that the server doesn't realize
that the new column is going to have all nulls and that the check
constraint allows nulls. As such, the check