Re: Catastrophic changes to PostgreSQL 8.4

Kern Sibbald <kern(at)sibbald(dot)com> writes:
> Concerning the future: I am still a bit concerning about the mention in the
> document of possible future changes concerning SQL_ASCII and LC_CTYPE not C
> or POSIX ("Using this combination of settings is deprecated and may someday
> be forbidden altogether. "), so if you have any suggestions for CREATE
> DATABASE that we can use now that will ensure that for future versions of
> Bacula + PostgreSQL that we will end up with our bacula database created with
> SQL_ASCII, I would much appreciate it.

What you need to do is add
LC_COLLATE = 'C' LC_CTYPE = 'C'
to the command. This is already important in 8.4 to ensure the command
won't fail if the installation default locale is not C.

The difficulty of course is that this is only for 8.4 and up, older
versions won't take it. I don't know the context well enough to suggest
how you might want to deal with version-sensitive commands (probably you
have some plan for that already).

regards, tom lane