Postgres Pro
Downloads
Home   >   mailing lists

Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE - Mailing list pgsql-general

From Evan Carroll
Subject Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE
Date
Msg-id CAAiePB7kddhUZyaNXqXM3kip3+uGS69ciQCE1DdRU30Dm9pkMA@mail.gmail.com
Whole thread Raw
In response to Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
I think I can best get around this, if I issue a

> CREATE EXTENSION citext;

And, then load the database with the result of pg_dump. It seems to be
working, but there are some citext related statements from the dump
that fail because the stuff is already there in the DB when you issue
the CREATE EXTENSION.

--
Evan Carroll - me@evancarroll.com
System Lord of the Internets
web: http://www.evancarroll.com
ph: 281.901.0011

pgsql-general by date:

Previous
From: Evan Carroll
Date:
Subject: Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE
Next
From: Tom Lane
Date:
Subject: Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE