Fix citext upgrade script to update derived copies of pg_type.typcollation.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 94bdb198813b079467d7ed07c6f72ac896da7161
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2011-11-21T16:25:05Z
Releases: 9.1.2
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.

Files

PathChange+/−
contrib/citext/citext--unpackaged--1.0.sql modified +40 −2