On Wed, 29 Oct 2025 at 16:31, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
>
> I think I see what you mean:
>
> CREATE TABLE temp (
> id bigint NOT NULL,
> valid tstzrange NOT NULL,
> CONSTRAINT temp_pkey PRIMARY KEY (id, valid WITHOUT OVERLAPS)
> );
>
> SELECT pg_get_indexdef('temp_pkey'::regclass);
>
> pg_get_indexdef
> ----------------------------------------------------------------------
> CREATE UNIQUE INDEX temp_pkey ON laurenz.temp USING gist (id, valid)
>
> That CREATE INDEX statement won't work.
>
> Yours,
> Laurenz Albe
>
>
Yep, this is probably a valid rewording of the first email. Is it a
problem that is worth fixing?
--
Best regards,
Kirill Reshke