staticvoidAlterCollationOwner_internal(Relationrel,OidcollationOid,

DefElem*lcctypeEl=NULL;

char*collcollate=NULL;

char*collctype=NULL;

Oidnewoid;

collNamespace=QualifiedNameGetCreationNamespace(names,&collName);

check_encoding_locale_matches(GetDatabaseEncoding(),collcollate,collctype);

CollationCreate(collName,

newoid=CollationCreate(collName,

collNamespace,

GetUserId(),

GetDatabaseEncoding(),

collcollate,

collctype);

CommandCounterIncrement();

pg_newlocale_from_collation(newoid);

}

DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1.

CREATE COLLATION test3 (lc_collate = 'en_US.utf8'); -- fail

ERROR: parameter "lc_ctype" must be specified

CREATE COLLATION testx (locale = 'nonsense'); -- fail

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

CREATE COLLATION test4 FROM nonsense;

ERROR: collation "nonsense" for current database encoding "UTF8" does not exist

CREATE COLLATION test5 FROM test0;

CREATE COLLATION test1 (lc_collate='en_US.utf8', lc_ctype='de_DE.utf8');

CREATE COLLATION test2 (locale='en_US');-- fail

CREATE COLLATION test3 (lc_collate='en_US.utf8');-- fail

CREATE COLLATION testx (locale='nonsense');-- fail

CREATE COLLATION test4FROM nonsense;

CREATE COLLATION test5FROM test0;