Re: BUG #19098: Can't create unique gist index, where pg_indexes says that WITHOUT OVERLAPS does exacly that - Mailing list pgsql-bugs

On Wed, 29 Oct 2025 at 16:31, Laurenz Albe <laurenz.albe@cybertec.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