For the TODO list

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL Hacker <pgsql-hackers(at)postgreSQL(dot)org>
Subject: For the TODO list
Date: 1998-12-11 16:48:17
Message-ID: 36714CD1.1B02A9D6@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-12-11 16:50:24 Re: [HACKERS] Sigh, build is broken again
Previous Message Bruce Momjian 1998-12-11 16:38:39 Re: [HACKERS] psql \d command