]> granicus.if.org Git - postgresql/commit
Repair damage done by citext--1.1--1.2.sql.
authorRobert Haas <rhaas@postgresql.org>
Tue, 26 Jul 2016 19:32:57 +0000 (15:32 -0400)
committerRobert Haas <rhaas@postgresql.org>
Tue, 26 Jul 2016 19:32:57 +0000 (15:32 -0400)
commitfe5e3fce798dccf3f298b65c5d9a132e9646712a
tree3739778192b9fda41e9dbdf5d6cfc182c0e94329
parent4452000f310b8c1c947ee724618c1bc31ed20242
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.
contrib/citext/Makefile
contrib/citext/citext--1.2--1.3.sql [new file with mode: 0644]
contrib/citext/citext--1.3.sql [moved from contrib/citext/citext--1.2.sql with 100% similarity]
contrib/citext/citext.control