Re: Declarative partitioning - another take - Mailing list pgsql-hackers

From Amit Langote
Subject Re: Declarative partitioning - another take
Date
Msg-id 56ec5504-c4d7-534c-8832-696dddfd58d1@lab.ntt.co.jp
Whole thread Raw
In response to Re: Declarative partitioning - another take  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: Declarative partitioning - another take  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2016/11/11 19:30, Amit Langote wrote:
>
> Attached updated patches.

Here is the latest version of the patches with some fixes along with those
mentioned below (mostly in 0003):

- Fixed the logic to skip the attach partition validation scan such that
  it won't skip scanning a list partition *that doesn't accept NULLs* if
  the partition key column is not set NOT NULL (it similarly doesn't skip
  scanning a range partition if either of the partition key columns is not
  set NOT NULL, because a range partition key cannot contain NULLs at all)

- Added some more regression tests for ATTACH PARTITION command

- Some fixes to documentation and source code comments

Thanks,
Amit

Attachment

pgsql-hackers by date:

Previous
From: Rushabh Lathia
Date:
Subject: Re: Push down more UPDATEs/DELETEs in postgres_fdw
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: asynchronous execution