Re: Declarative partitioning

On 20 October 2015 at 18:34, Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
>
>
> On Wednesday, 21 October 2015, Thom Brown <thom(at)linux(dot)com> wrote:
>>
>> On 18 August 2015 at 12:23, Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
>> > Hi Thom,
>> >
>> > On Tue, Aug 18, 2015 at 8:02 PM, Thom Brown <thom(at)linux(dot)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.
>>
>> This doesn't seem to have materialised. Are you still working on this?
>
>
> Yes, I will be posting to this thread soon. Sorry about the silence.

Thanks. I'd like to test it again.

Thom