Forest Wilkinson <fspam(at)home(dot)com> writes:
> A coworker told me that the postgres implementation of ALTER TABLE ADD
> COLUMN creates an inefficient database.
Dunno where he got that idea.
There are some problems lurking in ADD COLUMN when used on a table with
inheritance children --- the new column is added to the children too, as
it should be, but in an unexpected column position, which causes trouble
for pg_dump (a dump and reload will do the wrong thing). Perhaps what
you heard is a garbled report of that issue.
regards, tom lane
In response to
pgsql-sql by date
|Next:||From: Peter Eisentraut||Date: 2000-11-09 15:53:47|
|Subject: Re: [SQL] alter pg_shadow|
|Previous:||From: hubert depesz lubaczewski||Date: 2000-11-09 13:20:36|
|Subject: how to write it in most efficient way?|