I have a table with existing data for which I need to:
1) drop the single primary key column (int4)
2) recreate the column with the pk (not null) constraint deferred
3) repopulate the column from a sequence
4) enable the constraint
When I issue this command to add the column:
alter table <table_name> add column id INT4 NOT NULL;
I get an error saying:
ERROR: column "id" contains null values.
Is there a way to issue the "alter table..." command and defer the
constraint (did not see in online docs)
and then at some point enable it?
What would be the best approach here?