| From: | adwolf1(at)yahoo(dot)com (ad wolf) |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Bug in 7.2.1? -- ERROR: Adding columns with defaults is not implemented. |
| Date: | 2002-07-07 00:33:29 |
| Message-ID: | 5580cd6f.0207061633.2d35f546@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Using pg 7.1.2, I can enter the following statement successfully:
# alter table manufacturer add column dummy integer not null default
1;
However, under 7.2.1, the same statement gets me --
ERROR: Adding columns with defaults is not implemented.
Add the column, then use ALTER TABLE SET DEFAULT.
My question is two-fold -- first, is this new behavior a feature, or a
bug?
Second, what features/fixes would i lose by reverting to 7.1.2?
I'd like to stick with 7.2.1, but this new behavior is making it
difficult for me. I can't simply drop & recreate all my tables just
to add a column!
Any help would be appreciated!
adam
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2002-07-07 01:46:28 | Re: (A) native Windows port |
| Previous Message | Clark C . Evans | 2002-07-06 21:51:07 | fractional timezones |