*** /media/linux_hhd/pgsql/releases/9.1/src/test/regress/expected/collate.out 2010-08-01 18:58:50.000000000 -0500 --- /media/linux_hhd/pgsql/releases/9.1/src/test/regress/results/collate.out 2010-08-01 19:23:14.000000000 -0500 *************** *** 6,14 **** a int, b text COLLATE "en_US" ); ! ERROR: collation "en_US" is not applicable to current database encoding "UTF8" ! LINE 3: b text COLLATE "en_US" ! ^ CREATE TABLE collate_test_fail ( a int, b text COLLATE "foo" --- 6,12 ---- a int, b text COLLATE "en_US" ); ! ERROR: collation "en_US" does not exist CREATE TABLE collate_test_fail ( a int, b text COLLATE "foo" *************** *** 25,32 **** --- 23,34 ---- a int, b text COLLATE "sv_SE.utf8" ); + ERROR: collation "sv_SE.utf8" does not exist INSERT INTO collate_test1 VALUES (1, 'abc'), (2, 'äbc'), (3, 'bbc'); INSERT INTO collate_test2 SELECT * FROM collate_test1; + ERROR: relation "collate_test2" does not exist + LINE 1: INSERT INTO collate_test2 SELECT * FROM collate_test1; + ^ SELECT * FROM collate_test1 WHERE b >= 'bbc'; a | b ---+----- *************** *** 34,42 **** (1 row) SELECT * FROM collate_test2 WHERE b >= 'bbc'; ! a | b ! ---+----- ! 2 | äbc ! 3 | bbc ! (2 rows) ! --- 36,41 ---- (1 row) SELECT * FROM collate_test2 WHERE b >= 'bbc'; ! ERROR: relation "collate_test2" does not exist ! LINE 1: SELECT * FROM collate_test2 WHERE b >= 'bbc'; ! ^ ======================================================================