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