Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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);
test=> insert into students values (1,'bill');
INSERT 39338 1
test=> alter table students add column age int2 default 20;
test=> insert into students values (2,'tom');
INSERT 39340 1
test=> select * from students;
 2|tom |
(2 rows)

The default for age does not work !

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group