pgsql: Fix citext upgrade script to update derived copies of pg_type.ty

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix citext upgrade script to update derived copies of pg_type.ty
Date: 2011-11-21 16:25:33
Message-ID: E1RSWgX-0007os-7S@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2011-11-21 20:08:33 Re: pgsql: Do missed autoheader run for previous commit.
Previous Message Tom Lane 2011-11-21 04:50:53 pgsql: Further code review for range types patch.