On Thu, 2010-12-16 at 16:19 -0800, bricklen wrote: > On Wed, Dec 15, 2010 at 2:39 AM, Simon Riggs <[email protected]> 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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
