Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Evan Carroll <me(at)evancarroll(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE
Date: 2012-05-10 19:08:27
Message-ID: 22803.1336676907@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Evan Carroll <me(at)evancarroll(dot)com> writes:
> This is a cross post from: http://dba.stackexchange.com/q/17609/2639
> Just recently I upgraded from Postgresql 8.4.11 to 9.1.3. I used
> pg_dump in the process. Now I'm getting an error:

>> ERROR: no collation was derived for column "vin" with collatable type citext
>> HINT: Use the COLLATE clause to set the collation explicitly.

Could we see the complete context for this?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Prashant Bharucha 2012-05-10 19:12:19 Sequence scan if "OR Condition" in where statement
Previous Message Lee Hachadoorian 2012-05-10 19:00:52 Re: Multiple COPY statements