Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE
Date
Msg-id 22803.1336676907@sss.pgh.pa.us
Whole thread Raw
In response to Custom Domain; migration from 8.4 to 9.1 and COLLATE  (Evan Carroll <me@evancarroll.com>)
Responses Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE
List pgsql-general
Tree view 
Evan Carroll <me@evancarroll.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

pgsql-general by date:

Previous
From: Lee Hachadoorian
Date:
Subject: Re: Multiple COPY statements
Next
From: Prashant Bharucha
Date:
Subject: Sequence scan if "OR Condition" in where statement