On Wed, Apr 24, 2013 at 8:49 AM, François Beausoleil
wrote:
> Presently, I'm migrating each partition individually to add NOT NULL, set a
> default value and update the table to have correct values. Essentially, I'm
> doing this:
>
> ALTER TABLE parent ADD COLUMN new_field int; -- adds the field
Hi all!
I have a partitioned table with millions of rows per weekly partition. I am
adding new fields, with null values and no default values to ensure I had a
reasonable migration time. All downstream code knows how to work with null
fields.
Presently, I'm migrating each partition individuall