Evan Carroll <me@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
