Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #1933: ADD COLUMN with DEFAULT resets table oids
Date
Msg-id 12249.1128307599@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1933: ADD COLUMN with DEFAULT resets table oids  ("Duncan Crombie" <duncan@chirp.com.au>)
List pgsql-bugs
Tree view 
"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

pgsql-bugs by date:

Previous
From: "William ZHANG"
Date:
Subject: Re: BUG #1932: initdb.log
Next
From: "Jean-Pierre Pelletier"
Date:
Subject: Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2