Thread: BUG #1933: ADD COLUMN with DEFAULT resets table oids

The following bug has been logged online:

Bug reference:      1933
Logged by:          Duncan Crombie
Email address:      duncan@chirp.com.au
PostgreSQL version: 8.0.1
Operating system:   Darwin (OSX)
Description:        ADD COLUMN with DEFAULT resets table oids
Details:

The following command causes all oids in the affected table to be reset to
new values:

ALTER TABLE items ADD COLUMN publish bool DEFAULT true;

The following causes no problems:

ALTER TABLE items ADD COLUMN publish bool;
ALTER TABLE items ALTER publish SET DEFAULT true;

"Duncan Crombie" <duncan@chirp.com.au> writes:
> The following command causes all oids in the affected table to be reset to
> new values:
> ALTER TABLE items ADD COLUMN publish bool DEFAULT true;

Yup, that's an oversight.  Fix committed, will appear in 8.0.4.
Thanks for the report!

            regards, tom lane