The following bug has been logged online:
Bug reference: 1933
Logged by: Duncan Crombie
Email address: duncan(at)chirp(dot)com(dot)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;