pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedalter table add column implementation undesirable?
2+ messages / 2 participants
[nested] [flat]
* alter table add column implementation undesirable?
@ 2000-11-09 03:55 Forest Wilkinson <fspam@home.com>
2000-11-09 15:31 ` Re: alter table add column implementation undesirable? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Forest Wilkinson @ 2000-11-09 03:55 UTC (permalink / raw)
To: pgsql-sql
A coworker told me that the postgres implementation of ALTER TABLE ADD
COLUMN creates an inefficient database. He said it results in a table
whose new column is stored someplace other than the rest of the columns.
(A hidden auxiliary table?) Is this true in postgres 6.5.3? 7.x? Was it
ever true?
Forest Wilkinson
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: alter table add column implementation undesirable?
2000-11-09 03:55 alter table add column implementation undesirable? Forest Wilkinson <fspam@home.com>
@ 2000-11-09 15:31 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2000-11-09 15:31 UTC (permalink / raw)
To: Forest Wilkinson <fspam@home.com>; +Cc: pgsql-sql
Forest Wilkinson <fspam@home.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-11-09 15:31 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-09 03:55 alter table add column implementation undesirable? Forest Wilkinson <fspam@home.com>
2000-11-09 15:31 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox