Re: general question on two-partition table

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Janet Jacobsen <jsjacobsen(at)lbl(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: general question on two-partition table
Date: 2009-07-28 22:44:42
Message-ID: 20090728224442.GR23840@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Janet Jacobsen (jsjacobsen(at)lbl(dot)gov) wrote:
> I looked at the documentation for partitions - it is the case, right, that I
> have to create the master table and the two partition tables (depending
> on the value of rbscore) and then copy the records from the existing
> table into the two partitions?

That's probably what I'd do. You might be able to alter them to say
'inheirited', I don't recall if that was a new capbility or something
existing though (as in, it might only be in 8.4).

Thanks,

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2009-07-28 22:55:29 Re: Video available for PGDay SJC '09
Previous Message Janet Jacobsen 2009-07-28 22:08:05 Re: general question on two-partition table