Thank you David, I will use list.
On Wed, Apr 17, 2019 at 6:42 PM David Rowley <david.rowley@xxxxxxxxxxxxxxx> wrote:
On Thu, 18 Apr 2019 at 10:19, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
> CREATE TABLE automatic.measurement_automatic PARTITION OF
> automatic.measurement
> test-# FOR VALUES FROM (1) TO (1)
> test-# PARTITION BY RANGE (origin);
> ERROR: empty range bound specified for partition "measurement_automatic"
> DETAIL: Specified lower bound (1) is greater than or equal to upper
> bound (1).
>
> OOPS, so lets cheat:
Or you could partition by LIST.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
