| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
| Cc: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Andrew Bille <andrewbille(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: cataloguing NOT NULL constraints |
| Date: | 2024-05-01 17:49:35 |
| Message-ID: | 202405011749.txscey5apbn6@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2024-Apr-25, Alvaro Herrera wrote:
> > Also, I've found a weird behaviour with a non-inherited NOT NULL
> > constraint for a partitioned table:
> > CREATE TABLE pt(a int NOT NULL NO INHERIT) PARTITION BY LIST (a);
> Ugh. Maybe a way to handle this is to disallow NO INHERIT in
> constraints on partitioned tables altogether. I mean, they are a
> completely useless gimmick, aren't they?
Here are two patches that I intend to push soon (hopefully tomorrow).
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"No me acuerdo, pero no es cierto. No es cierto, y si fuera cierto,
no me acuerdo." (Augusto Pinochet a una corte de justicia)
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Disallow-direct-change-of-NO-INHERIT-of-not-null-con.patch | text/x-diff | 11.1 KB |
| 0002-Disallow-NO-INHERIT-not-null-constraints-on-partitio.patch | text/x-diff | 4.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Imseih (AWS), Sami | 2024-05-01 18:19:03 | Re: New GUC autovacuum_max_threshold ? |
| Previous Message | Jacob Champion | 2024-05-01 17:30:56 | Re: TLS certificate alternate trust paths issue in libpq - certificate chain validation failing |