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
In-reply-to: 
 <CAOC8YUfELpHXNopHiWQREZiDJmUEHw8po-k3KpZyrL9denm0+w@mail.gmail.com>
References: 
 <CAOC8YUfELpHXNopHiWQREZiDJmUEHw8po-k3KpZyrL9denm0+w@mail.gmail.com>
Comments: In-reply-to "Ian R. Campbell" <ian.campbell@thepathcentral.com>
	message dated "Wed, 24 Nov 2021 17:23:03 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <175809.1637776702.1@sss.pgh.pa.us>
Date: Wed, 24 Nov 2021 12:58:22 -0500
Message-ID: <175810.1637776702@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/175810.1637776702%40sss.pgh.pa.us>
Precedence: bulk

"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