Re: Declarative partitioning - Mailing list pgsql-hackers

From Amit Langote
Subject Re: Declarative partitioning
Date
Msg-id CA+HiwqFLNTBwCcxLVHa4sc+uA_raBHiUiPFc1NBB-DDVfhPKiA@mail.gmail.com
Whole thread Raw
In response to Re: Declarative partitioning  (Thom Brown <thom@linux.com>)
Responses Re: Declarative partitioning
List pgsql-hackers
Hi Thom,

On Tue, Aug 18, 2015 at 8:02 PM, Thom Brown <thom@linux.com> wrote:
>
>
> Wow, didn't expect to see that email this morning.
>
> A very quick test:
>
> CREATE TABLE purchases (purchase_id serial, purchase_time timestamp, item
> text) partition by range on ((extract(year from
> purchase_time)),(extract(month from purchase_time)));
> ERROR:  referenced relation "purchases" is not a table or foreign table
>

Thanks for the quick test.

Damn, I somehow missed adding the new relkind to a check in
process_owned_by(). Will fix this and look for any such oversights.

Thanks,
Amit



pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Re: Declarative partitioning
Next
From: Masahiko Sawada
Date:
Subject: Re: Freeze avoidance of very large table.