On 2018/07/11 4:50, Alvaro Herrera wrote:
> On 2018-Jul-10, Tom Lane wrote:
>
>> And what about those partition bound values? They are now illegal
>> for the domain, so I would expect a dump/reload to fail, regardless
>> of whether there are any values in the table.
>
> Hmm, true.
There is a patch to overhaul how partition bound values are parsed:
https://commitfest.postgresql.org/18/1620/
With that patch, the error you reported upthread goes away (that is, one
can successfully create partitions), but the problem that Tom mentioned
above then appears.
What's the solution here then? Prevent domains as partition key?
Thanks,
Amit