Joe Van Dyk wrote:
> Is there a way to add a NOT NULL constraint to a column without having
> to lock the table while a sequential read happens?
>
> Seems like it should be possible to add an index on the column for
> null values, like:
> create index on t using btree(col_name) where col_name is n
Is there a way to add a NOT NULL constraint to a column without having
to lock the table while a sequential read happens?
Seems like it should be possible to add an index on the column for
null values, like:
create index on t using btree(col_name) where col_name is null;
Then when adding the not
