On 2016/12/08 3:33, Robert Haas wrote: > On Wed, Dec 7, 2016 at 1:30 PM, Robert Haas <robertmh...@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 -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers