Re: ADD/DROP INHERITS

"Jim C. Nasby" <jnasby@pervasive.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