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

From: Rudolf van der Leeden <rudolf(dot)vanderleeden(at)scoreloop(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org, Rudolf van der Leeden <vanderleeden(at)logicunited(dot)com>
Subject: Re: Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension
Date: 2011-11-21 18:02:12
Message-ID: CAPHWM5_8KKgaFp8ibXVyXGZU9UQ0SKMe_7TK9HH_LWttyOEC4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David Schnur 2011-11-21 18:54:51 Re: How and when are encoding DLLs used on Windows?
Previous Message Jean-Armel Luce 2011-11-21 16:45:59 Re: rsync and streaming replication