BUG #1933: ADD COLUMN with DEFAULT resets table oids - Mailing list pgsql-bugs

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;