| From: | Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Cc: | Suraj Kharage <suraj(dot)kharage(at)enterprisedb(dot)com>, Amul Sul <sulamul(at)gmail(dot)com> |
| Subject: | Re: simplifying grammar for ALTER CONSTRAINT .. SET [NO] INHERIT |
| Date: | 2025-03-25 16:05:17 |
| Message-ID: | 202503251605.e6yngze7aeim@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2025-Mar-25, Álvaro Herrera wrote:
> With commit f4e53e10b6ce we introduced a way to flip the NO INHERIT bit
> on not-null constraints. However, because of the way the grammar
> dealt with ALTER CONSTRAINT, we were too blind to see a way to implement
> it using the existing production.
Patch attached.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"Someone said that it is at least an order of magnitude more work to do
production software than a prototype. I think he is wrong by at least
an order of magnitude." (Brian Kernighan)
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-change-syntax-from-SET-NO-INHERIT-to-just-NO-INHERIT.patch | text/x-diff | 14.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2025-03-25 16:15:43 | Re: AIO v2.5 |
| Previous Message | Álvaro Herrera | 2025-03-25 16:02:49 | simplifying grammar for ALTER CONSTRAINT .. SET [NO] INHERIT |