| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | jian he <jian(dot)universality(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tender Wang <tndrwang(at)gmail(dot)com> |
| Subject: | Re: not null constraints, again |
| Date: | 2025-04-14 21:33:03 |
| Message-ID: | 202504142133.qeqgu7ujm4ie@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2025-Apr-14, Tom Lane wrote:
> The patch I propose there seems to prevent this, but I wonder if we
> shouldn't look closer into why it's failing in the first place.
> I would not have expected that adding pg_constraint rows implies
> stronger locks than what ALTER ADD PRIMARY KEY was using before,
> and I suspect that doing so will cause more problems than just
> breaking parallel restore.
I wasn't aware of this side effect. I'll investigate this in more
depth. I suspect it might be a bug in the way we run through ALTER
TABLE for the primary key.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"Los cuentos de hadas no dan al niño su primera idea sobre los monstruos.
Lo que le dan es su primera idea de la posible derrota del monstruo."
(G. K. Chesterton)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-04-14 21:39:01 | Re: not null constraints, again |
| Previous Message | Tom Lane | 2025-04-14 21:11:11 | Re: Fix a resource leak (src/backend/utils/adt/rowtypes.c) |