Re: BUG #17339: Assert failed on attempt to detach a sequence concurrently

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>
To: Alexander Lakhin <exclusion@gmail.com>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>, peter.eisentraut@enterprisedb.com, pgsql-bugs@lists.postgresql.org
Date: 2021-12-22T06:58:15Z
Lists: pgsql-bugs
On Tue, Dec 21, 2021 at 07:00:00AM +0300, Alexander Lakhin wrote:
> As detaching a foreign table is a valid scenario (not covered before),
> maybe it's worth to exercise it as following:

Yeah, I was going to add something in the main regression test suite
as of foreign_data.sql, but the detached partitions are used with
constraint checks so that was a bit confusing.  What you are
suggesting is fine by me, so I have included these and pushed a fix
for the issue.
--
Michael

Commits

  1. Remove assertion for ALTER TABLE .. DETACH PARTITION CONCURRENTLY