Horton

Re: [COMMITTERS] pgsql: Fix a bug in how we generate partition constraints.

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Robert Haas <rhaas@postgresql.org>
Cc: pgsql-hackers@postgresql.org, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Date: 2017-01-13T19:18:28Z
Lists: pgsql-hackers 
Robert Haas wrote:
> Fix a bug in how we generate partition constraints.
> 
> Move the code for doing parent attnos to child attnos mapping for Vars
> in partition constraint expressions to a separate function
> map_partition_varattnos() and call it from the appropriate places.

Hmm, we were discussing this stuff a few days ago, see
https://www.postgresql.org/message-id/20170109182800.qrkae62kmur3gfeg@alvherre.pgsql
and commit 3957b58b8885441c8d03bc1cfc00e47cf8cd7975.  Part of this code
duplicates that ...

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Avoid some code duplication in map_partition_varattnos().

  2. Fix a bug in how we generate partition constraints.

  3. Fix ALTER TABLE / SET TYPE for irregular inheritance