From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ian R. Campbell <ian.campbell@thepathcentral.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: PG 14 range partitions creation works but subsequently can't be found correctly
Date: Wed, 24 Nov 2021 12:58:22 -0500
Message-ID: <175810.1637776702@sss.pgh.pa.us> (raw)
In-Reply-To: <CAOC8YUfELpHXNopHiWQREZiDJmUEHw8po-k3KpZyrL9denm0+w@mail.gmail.com>
References: <CAOC8YUfELpHXNopHiWQREZiDJmUEHw8po-k3KpZyrL9denm0+w@mail.gmail.com>
"Ian R. Campbell" <ian.campbell@thepathcentral.com> writes:
> The following executes without problem:
> CREATE TABLE part (
> h "char" not null,
> val int4 not null
> ) PARTITION BY RANGE (h);
> create table part_00 partition of part FOR VALUES FROM ((-128)::"char") to
> ((-113)::"char");
> create table part_01 partition of part FOR VALUES FROM ((-112)::"char") to
> ((-97)::"char");
> ...
This works for me in psql, modulo the fact that your boundary conditions
are off-by-one. (That is, I can store h = -114 and -112, but not -113,
in this table.)
> In pgAdmin 4, navigating to "Partitions" (after refreshing) results only in
> a spinning wheel.
That sounds like a pgAdmin bug --- but this list is not the place
to report pgAdmin problems.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, ian.campbell@thepathcentral.com, pgsql-bugs@lists.postgresql.org
Subject: Re: PG 14 range partitions creation works but subsequently can't be found correctly
In-Reply-To: <175810.1637776702@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox