Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension - Mailing list pgsql-admin

From Rudolf van der Leeden
Subject Re: Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension
Date
Msg-id CAPHWM5_8KKgaFp8ibXVyXGZU9UQ0SKMe_7TK9HH_LWttyOEC4A@mail.gmail.com
Whole thread Raw
In response to Re: Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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.


pgsql-admin by date:

Previous
From: Jean-Armel Luce
Date:
Subject: Re: rsync and streaming replication
Next
From: "Skusa, Andre"
Date:
Subject: silent installer