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

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