Re: Fast ALTER TABLE ... ADD COLUMN ... DEFAULT xxx?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <stark(at)enterprisedb(dot)com>
Cc: Sam Mason <sam(at)samason(dot)me(dot)uk>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fast ALTER TABLE ... ADD COLUMN ... DEFAULT xxx?
Date: 2009-05-21 15:22:52
Message-ID: 11039.1242919372@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark <stark(at)enterprisedb(dot)com> writes:
> Schemes like this have been discussed before but I don't think we
> considered applying the limitation that only the "first" default value
> would be covered. We always wanted to be able to handle new defaults
> or making a non-null column nullable later.

Yeah ... I don't see exactly what it would buy to restrict it to just
the first such value.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-05-21 15:38:22 Re: Fast ALTER TABLE ... ADD COLUMN ... DEFAULT xxx?
Previous Message Zdenek Kotala 2009-05-21 15:20:59 Re: psql is broken in 8.4