Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results
Date
Msg-id 1083.1006925780@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> So, are we now all agreed that we have to fill in the existing rows with
> the default value?

I think there's no debate that that's what the spec says to do.  There
might be some discontent in the ranks about whether to follow SQL92's
marching orders, however.  Doubling the filesize of the table to apply
changes that the user might not even want seems a heavy penalty.

> If so, I can document that in the TODO list and
> discard this patch.

This is certainly a TODO or TOARGUEABOUT item, not something to be
patched on short notice.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results
Next
From: Tatsuo Ishii
Date:
Subject: Re: Call for platform testing