Postgres Pro
Downloads
Home   >   mailing lists

Re: is it possible to create partitioned tables using tables fromdifferent schemas - Mailing list pgsql-general

From pabloa98
Subject Re: is it possible to create partitioned tables using tables fromdifferent schemas
Date
Msg-id CAEjudX4aurPVScmnm9BGJeHeE=jiPRESUiKaSNaQ7JBaj+VP_w@mail.gmail.com
Whole thread Raw
In response to Re: is it possible to create partitioned tables using tables fromdifferent schemas  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-general
Tree view
Thank you David, I will use list.

On Wed, Apr 17, 2019 at 6:42 PM David Rowley <david.rowley@2ndquadrant.com> wrote:
On Thu, 18 Apr 2019 at 10:19, Adrian Klaver <adrian.klaver@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

pgsql-general by date:

Previous
From: pabloa98
Date:
Subject: Re: is it possible to create partitioned tables using tables fromdifferent schemas
Next
From: Michel Pelletier
Date:
Subject: Re: Method to pass data between queries in a multi-statement transaction