| Lists: | pgsql-bugs |
|---|
| From: | "Duncan Crombie" <duncan(at)chirp(dot)com(dot)au> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #1933: ADD COLUMN with DEFAULT resets table oids |
| Date: | 2005-10-02 13:44:23 |
| Message-ID: | 20051002134423.648C7F0FAE@svr2.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
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;
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Duncan Crombie" <duncan(at)chirp(dot)com(dot)au> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1933: ADD COLUMN with DEFAULT resets table oids |
| Date: | 2005-10-03 02:46:39 |
| Message-ID: | 12249.1128307599@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Duncan Crombie" <duncan(at)chirp(dot)com(dot)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