Thank you David, I will use list. On Wed, Apr 17, 2019 at 6:42 PM David Rowley <david.row...@2ndquadrant.com> wrote:
> On Thu, 18 Apr 2019 at 10:19, Adrian Klaver <adrian.kla...@aklaver.com> > 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 >
