pgsql: Fix citext upgrade script to update derived copies of pg_type.ty - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix citext upgrade script to update derived copies of pg_type.ty
Date
Msg-id E1RSWgX-0007os-7S@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix citext upgrade script to update derived copies of pg_type.typcollation.

If the existing citext type has not merely been created, but used in any
tables, then the upgrade script wasn't doing enough.  We have to update
attcollation for each citext table column, and indcollation for each citext
index column, as well.  Per report from Rudolf van der Leeden.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/9b97b7f8356c63ea0b6704718d75ea01ec3035bf

Modified Files
--------------
contrib/citext/citext--unpackaged--1.0.sql |   42 ++++++++++++++++++++++++++-
1 files changed, 40 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix citext upgrade script to update derived copies of pg_type.ty
Next
From: Bruce Momjian
Date:
Subject: Re: pgsql: Do missed autoheader run for previous commit.