Re: Updating a pre-10 partitioned table to use PG 10 partitioning

2018-01-12 Thread Keith
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

Re: Updating a pre-10 partitioned table to use PG 10 partitioning

2018-01-11 Thread Michael Paquier
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

RE: Updating a pre-10 partitioned table to use PG 10 partitioning

2018-01-11 Thread Igor Neyman
-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 the old approac