| From: | Antonin Houska <ah(at)cybertec(dot)at> |
|---|---|
| To: | Osama Abdul Qader <osamaabdulqader(dot)cs(at)gmail(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)kurilemu(dot)de>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: REPACK (ANALYZE) within transaction block segfaults |
| Date: | 2026-09-03 04:42:06 |
| Message-ID: | 5477.1788410526@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Osama Abdul Qader <osamaabdulqader(dot)cs(at)gmail(dot)com> wrote:
> I have prepared a patch that rejects REPACK (ANALYZE) with PreventInTransactionBlock(), consistent with the existing restriction for
> REPACK (CONCURRENTLY). I also added a regression test covering execution inside a transaction block.
>
> The patch applies cleanly to the current tree and passes git diff --check.
Is this a new version of [1]? If so, I'm not sure it addresses all the
problems mentioned in [2]. And regarding regression tests, it misses the
changes in expected/cluster.out.
[1] https://www.postgresql.org/message-id/49398.1787944525%40localhost
[2] https://www.postgresql.org/message-id/CAHGQGwEezdMUixhJ-N0YO0OFUmh0uPaXRDkds5FS-5dmdwz4Bg%40mail.gmail.com
--
Antonin Houska
Web: https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Филиппов Степан | 2026-09-03 04:54:42 | 028_pitr_timelines.pl might fail when cp interrupted and backup includes required segment |
| Previous Message | Ewan Young | 2026-09-03 04:19:49 | FOR PORTION OF silently ignored on views with DO INSTEAD rules |