From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | Amit Langote <amitlangote09(at)gmail(dot)com> |
Cc: | Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, jian he <jian(dot)universality(at)gmail(dot)com> |
Subject: | Re: ALTER TABLE ONLY .. DROP CONSTRAINT on partitioned tables |
Date: | 2024-09-30 10:01:20 |
Message-ID: | 202409301001.3nirfbzcbib3@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
On 2024-Sep-27, Amit Langote wrote:
> On Fri, Sep 27, 2024 at 2:52 AM Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> > While studying a review note from Jian He on not-null constraints, I
> > came across some behavior introduced by commit 9139aa19423b[1] that I
> > think is mistaken.
> Yeah, I don’t quite recall why I thought the behavior for both ADD and
> DROP had to be the same. I went back and reviewed the thread, trying
> to understand why DROP was included in the decision, but couldn’t find
> anything that explained it. It also doesn’t seem to be related to the
> pg_dump issue that was being discussed at the time.
Right.
> So, I think you might be right that the restriction on DROP is
> overkill, and we should consider removing it, at least in the master
> branch.
Thanks for looking! I have pushed the removal now.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
<inflex> really, I see PHP as like a strange amalgamation of C, Perl, Shell
<crab> inflex: you know that "amalgam" means "mixture with mercury",
more or less, right?
<crab> i.e., "deadly poison"
From | Date | Subject | |
---|---|---|---|
Next Message | Hayato Kuroda (Fujitsu) | 2024-09-30 10:03:42 | RE: long-standing data loss bug in initial sync of logical replication |
Previous Message | Daniel Gustafsson | 2024-09-30 09:59:48 | Re: Doc: typo in config.sgml |