CREATE COLLATION mycoll2 ( LC_COLLATE = "POSIX", LC_CTYPE = "POSIX" );

CREATE COLLATION mycoll3 FROM "default"; -- intentionally unsupported

ERROR: collation "default" cannot be copied

CREATE COLLATION mycoll4 ( LOCALE = "no_such_locale" ); -- fail

ERROR: could not create locale "no_such_locale": No such file or directory

DETAIL: The operating system could not find any locale data for the locale name "no_such_locale".

DROP COLLATION mycoll1;

CREATE TABLE collate_test23 (f1 text collate mycoll2);

DROP COLLATION mycoll2; -- fail

CREATE COLLATION mycoll1FROM"C";

CREATE COLLATION mycoll2 ( LC_COLLATE="POSIX", LC_CTYPE="POSIX" );

CREATE COLLATION mycoll3FROM"default";-- intentionally unsupported

CREATE COLLATION mycoll4 ( LOCALE="no_such_locale" );-- fail

DROP COLLATION mycoll1;

CREATETABLEcollate_test23 (f1text collate mycoll2);