On Thu, Jan 11, 2018 at 8:40 PM, Michael Paquier
wrote:
> On Thu, Jan 11, 2018 at 04:40:30PM +0100, Alban Hertroys wrote:
> > What is a good approach here?
>
> By having a some point an origin and target table in the same cluster,
> you would just need to define things properly. I have not checke
On Thu, Jan 11, 2018 at 04:40:30PM +0100, Alban Hertroys wrote:
> What is a good approach here?
By having a some point an origin and target table in the same cluster,
you would just need to define things properly. I have not checked, but
perhaps this is the kind of use cases where pg_partman
(http
-Original Message-
From: Alban Hertroys [mailto:haram...@gmail.com]
Sent: Thursday, January 11, 2018 10:41 AM
To: Postgres General
Subject: Updating a pre-10 partitioned table to use PG 10 partitioning
I'm trying to update an existing table that was created in PG9.6 using th
I'm trying to update an existing table that was created in PG9.6 using
the old approach with manual inheritance and check constraints to make
use of the new approach in PG 10 using 'partitioned by', 'attach
partition', etc.
I ran into some how-to's on the internet, but they all assume you
start pa
