Re: alter table performance

Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> What's wrong with:
> alter table person add column address varchar(64) not null default '';

This:

regression=# alter table person add column address varchar(64) not null default '';
ERROR: Adding columns with defaults is not implemented.
Add the column, then use ALTER TABLE SET DEFAULT.
regression=# \q

This is just one of many many things that could be improved by getting
off of 7.3. In general, complaining about performance (or features)
of a seven-year-old, long since EOL'd release is not a productive use of
anybody's time.

regards, tom lane