Procedure for adding a column

Поиск
Список
Период
Сортировка
От david_shadovitz@xontech.com (David Shadovitz)
Тема Procedure for adding a column
Дата
Msg-id 8b37e2e5.0310090805.257d4b6f@posting.google.com
обсуждение исходный текст
Ответы Re: Procedure for adding a column
Список pgsql-general
I need to add a column to a table.  This table holds several thousand
records, has several indexes, and serves as the parent table to a few
child tables.

When I've done this in the past, it has taken quite a long time for
the ALTER TABLE command to complete.

So, what is the correct procedure for adding a column?  Drop the
indexes, add the column, and recreate the indexes?

Thanks.
-David

В списке pgsql-general по дате отправления:

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Response from MySql AB (Re: Humor me: Postgresql vs.
Следующее
От: Francois Suter
Дата:
Сообщение: Re: suggestions for tracking down syntax errors?