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

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