Re: ALTER TABLE ... REPLACE WITH

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: ALTER TABLE ... REPLACE WITH
Дата
Msg-id 1292569505.1193.6949.camel@ebony
обсуждение исходный текст
Ответ на Re: ALTER TABLE ... REPLACE WITH  (bricklen <bricklen@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Thu, 2010-12-16 at 16:19 -0800, bricklen wrote:
> On Wed, Dec 15, 2010 at 2:39 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> > Perhaps a more useful definition would be
> >
> > EXCHANGE TABLE target WITH source;
> >
> > which just swaps the heap and indexes of each table.
> 
> At the risk of stating the obvious, this would work with partition exchange too?

Yes, that is one use case.

-- Simon Riggs           http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Re: Proposed Windows-specific change: Enable crash dumps (like core files)
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Re: Proposed Windows-specific change: Enable crash dumps (like core files)