Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> There is a fair amount of collation-related functionality that is only
> being tested by sql/collate.icu.utf8.sql and sql/collate.linux.utf8.sql,
> which are not run by default. There is more functionality planned in
> this area, so making the testing more straightforward would be useful.
> The reason these tests cannot be run by default (other than that they
> don't apply to each build, which is easy to figure out) is that
> a) They contain UTF8 non-ASCII characters that might not convert to
> every server-side encoding, and
> b) The error messages mention the encoding name ('ERROR: collation
> "foo" for encoding "UTF8" does not exist')
> The server encoding can be set more-or-less arbitrarily for each test
> run, and moreover it is computed from the locale, so it's not easy to
> determine ahead of time from a makefile, say.
> What would be a good way to sort this out? None of these problems are
> terribly difficult on their own, but I'm struggling to come up with a
> coherent solution.
Perhaps set up a separate test run (not part of the core tests) in which
the database is forced to have UTF8 encoding? That could be expanded
to other encodings too if anyone cares.
regards, tom lane