From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Alter table add column ignores default |
Date: | 2001-05-05 16:23:37 |
Message-ID: | 200105051623.f45GNbf91481@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Vince Vielhaber (vev(at)hub(dot)org) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Alter table add column ignores default
Long Description
Alter table add column ignores the default values in both v7.0x and 7.1. In the example code the table is created with one column having a default value of 'none'. An ALTER TABLE is done adding another varchar column also with a default value. \d table only shows the default from the create, not the alter. An insert also fails to add the default.
Sample Code
foo=# create table foobar(name varchar(20),nickname varchar(10) default 'none');
CREATE
foo=# \d foobar
Table "foobar"
Attribute | Type | Modifier
-----------+-------------+----------------
name | varchar(20) |
nickname | varchar(10) | default 'none'
foo=# alter table foobar add column address varchar(50) default 'none';
ALTER
foo=# \d foobar
Table "foobar"
Attribute | Type | Modifier
-----------+-------------+----------------
name | varchar(20) |
nickname | varchar(10) | default 'none'
address | varchar(50) |
foo=# insert into foobar(name) values('Joe Postgres');
INSERT 313396 1
foo=# select * from foobar;
name | nickname | address
--------------+----------+---------
Joe Postgres | none |
(1 row)
foo=#
No file was uploaded with this report
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-05-05 21:12:17 | Re: Build fails for pl/tcl on OpenBSD |
Previous Message | pgsql-bugs | 2001-05-05 15:32:42 | Bug #307 resolved (concerned timestamp problems) |