On 2016/12/08 3:33, Robert Haas wrote:
> On Wed, Dec 7, 2016 at 1:30 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> -- partitioned table cannot partiticipate in regular inheritance
>> CREATE TABLE partitioned2 (
>> a int
>> --- 392,411 ----
>> c text,
>> d text
>> ) PARTITION BY RANGE (a oid_ops, plusone(b), c collate "default", d
>> collate "en_US");
>> + ERROR: collation "en_US" for encoding "SQL_ASCII" does not exist
> ...
>> No idea why yet, but I'll try to figure it out.
>
> And of course that'd be because relying on en_US isn't portable. Sigh.
Should've thought about the non-portability of locales. Thanks for
catching and fixing anyway!
Thanks,
Amit