For the TODO list

Started by Constantin Teodorescuabout 27 years ago3 messages

Maybe you could include on the TODO list the following bug

Alter table add column doesn't save defaults options :

test=> create table students (id int4, name text);
CREATE
test=> insert into students values (1,'bill');
INSERT 39338 1
test=> alter table students add column age int2 default 20;
ADD
test=> insert into students values (2,'tom');
INSERT 39340 1
test=> select * from students;
id|name|age
--+----+---
1|bill|
2|tom |
(2 rows)

The default for age does not work !

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

#2Bruce Momjian
maillist@candle.pha.pa.us
In reply to: Constantin Teodorescu (#1)
Re: [HACKERS] For the TODO list

Maybe you could include on the TODO list the following bug

Added:

* ALTER TABLE ADD COLUMN does not honor DEFAULT

Alter table add column doesn't save defaults options :

test=> create table students (id int4, name text);
CREATE
test=> insert into students values (1,'bill');
INSERT 39338 1
test=> alter table students add column age int2 default 20;
ADD
test=> insert into students values (2,'tom');
INSERT 39340 1
test=> select * from students;
id|name|age
--+----+---
1|bill|
2|tom |
(2 rows)

The default for age does not work !

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
#3Bruce Momjian
maillist@candle.pha.pa.us
In reply to: Constantin Teodorescu (#1)
Re: For the TODO list

Already done. See TODO copy on web page.

Maybe you could include on the TODO list the following bug

Alter table add column doesn't save defaults options :

test=> create table students (id int4, name text);
CREATE
test=> insert into students values (1,'bill');
INSERT 39338 1
test=> alter table students add column age int2 default 20;
ADD
test=> insert into students values (2,'tom');
INSERT 39340 1
test=> select * from students;
id|name|age
--+----+---
1|bill|
2|tom |
(2 rows)

The default for age does not work !

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026