pgsql: Repair damage done by citext--1.1--1.2.sql.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Repair damage done by citext--1.1--1.2.sql.
Date: 2016-07-26 19:39:25
Message-ID: E1bS8CL-0004u2-Cw@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Repair damage done by citext--1.1--1.2.sql.

That script is incorrect in that it sets the combine function for
max(citext) twice instead of setting the combine function for
max(citext) once and the combine functon for min(citext) once. The
consequence is that if you install 1.0 or 1.1 and then update to 1.2,
you end up with min(citext) not having a combine function, contrary to
what was intended. If you install 1.2 directly, you're OK.

Fix things up by defining a new 1.3 version. Upgrading from 1.2 to
1.3 won't change anything for people who first installed the 1.2
version, but people upgrading from 1.0 or 1.1 will get the right
catalog contents once they reach 1.3.

Report and patch by David Rowley, reviewed by Andreas Karlsson.

Branch
------
master

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

Modified Files
--------------
contrib/citext/Makefile | 4 +-
contrib/citext/citext--1.2--1.3.sql | 7 +
contrib/citext/citext--1.2.sql | 493 ------------------------------------
contrib/citext/citext--1.3.sql | 493 ++++++++++++++++++++++++++++++++++++
contrib/citext/citext.control | 2 +-
5 files changed, 503 insertions(+), 496 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2016-07-26 20:11:48 pgsql: Change various deparsing functions to return NULL for invalid in
Previous Message Tom Lane 2016-07-26 19:25:30 pgsql: Fix constant-folding of ROW(...) IS [NOT] NULL with composite fi