Skip site navigation (1) Skip section navigation (2)

Partitioned Tables

From: "Plugge, Joe R(dot)" <JRPlugge(at)west(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Partitioned Tables
Date: 2010-07-13 15:40:08
Message-ID: BD69807DAE0CE44CA00A8338D0FDD08302E4F39BFE@oma00cexmbx03.corp.westworlds.com (view raw or flat)
Thread:
Lists: pgsql-admin
If I create a parent table that lives in a specific tablespace, when I create child tables that inherit the parent and then subsequently index and create a PK on the child, will all of the index objects default to the tablespace that the parent is built in?


Regards,

Joe Plugge

In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2010-07-13 16:35:20
Subject: Re: upgrade postgres 8.1.21 to version 8.3.6
Previous:From: Jens WilkeDate: 2010-07-13 10:58:01
Subject: Re: upgrade postgres 8.1.21 to version 8.3.6

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group