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

[Rudolf van der Leeden]

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.