Re: Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension

[Rudolf van der Leeden <rudolf.vanderleeden@xxxxxxxxxxxxx>]

Hi Tom,

This patch seems to fix the case for me:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=94bdb198813b079467d7ed07c6f72ac896da7161

YES. This patch fixes the citext upgrade problem. With the modified  share/extension/citext--unpackaged--1.0.sql  file
just run:  CREATE EXTENSION citext FROM unpackaged;  and the table and indexes can be used as with 9.0.5.

Thanks for your quick help.
Regards,
-Rudolf.