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: 36714CD1.1B02A9D6@flex.ro (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group