Re: general question on two-partition table - Mailing list pgsql-general

From Stephen Frost
Subject Re: general question on two-partition table
Date
Msg-id 20090728224442.GR23840@tamriel.snowman.net
Whole thread Raw
In response to Re: general question on two-partition table  (Janet Jacobsen <jsjacobsen@lbl.gov>)
List pgsql-general
* Janet Jacobsen (jsjacobsen@lbl.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

Attachment

pgsql-general by date:

Previous
From: Alan Chandler
Date:
Subject: Field name problem
Next
From: Greg Stark
Date:
Subject: Re: Video available for PGDay SJC '09