Re: Best Approach for Swapping a Table with its Copy - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Best Approach for Swapping a Table with its Copy
Date
Msg-id CAKAnmmLcD9y9WMTNCuPfhGOW17KS-+9kKo44Ve85CHu+YJ8WCA@mail.gmail.com
Whole thread Raw
In response to Re: Best Approach for Swapping a Table with its Copy  (Michał Kłeczek <michal@kleczek.org>)
List pgsql-general
On Fri, Feb 14, 2025 at 1:02 AM Michał Kłeczek <michal@kleczek.org> wrote:
Create index concurrently and then fiddle with the catalog tables to define the constraint using this index?

You mean an ALTER TABLE ... ADD CONSTRAINT ... EXCLUDE without actually doing an ALTER TABLE. Nope, that's far worse than the pg_repack shenanigans, as we would be creating new catalog objects.

Ideally would be that someone adds support for USING INDEX for an exclusion constraint. 

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Best Approach for Swapping a Table with its Copy
Next
From: Yongye Serkfem
Date:
Subject: Bash profile