pgsql: Don't disallow dropping NOT NULL for a list partition key.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Don't disallow dropping NOT NULL for a list partition key.
Date: 2017-02-14 17:22:08
Message-ID: E1cdgno-0002Wc-GH@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Don't disallow dropping NOT NULL for a list partition key.

Range partitioning doesn't support nulls in the partitioning columns,
but list partitioning does.

Amit Langote, per a complaint from Amul Sul

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/e28b1156122f4d48d6f6f7a7f26381ee7af65a91

Modified Files
--------------
src/backend/commands/tablecmds.c | 22 +++++++++++++---------
src/test/regress/expected/alter_table.out | 4 ++++
src/test/regress/sql/alter_table.sql | 5 +++++
3 files changed, 22 insertions(+), 9 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2017-02-14 17:43:47 pgsql: Minor fixes for WAL consistency checking.
Previous Message Robert Haas 2017-02-14 17:08:04 Re: Re: [COMMITTERS] pgsql: Remove all references to "xlog" from SQL-callable functions in p