"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> On Thu, Jun 08, 2006 at 11:42:49AM -0400, Greg Stark wrote:
> > But I seem to recall some headaches with that approach.
>
> What happens if you
>
> ALTER TABLE ... ADD new_column int DEFAULT 1;
> ALTER TABLE ... ALTER new_column SET DEFAULT 2;
Ah yes. Keeping track of multiple old defaults and when they were in effect
would indeed be quite a headache.
--
greg