Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: Manu <manuelreyesbravo(at)gmail(dot)com>, Richard Guo <guofenglinux(at)gmail(dot)com>, Richard Guo <rguo(at)postgresql(dot)org>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned
Date: 2026-11-12 04:36:50
Message-ID: CAGRkXqSKuxYN5GNEe=D5FisVaQfqFmT0XxST67Cz8dM5C319UQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Hi Álvaro,

Thanks for both rewrites. v3 follows your suggestion for doc and comment.

> "I'm impressed how quickly you are fixing this obscure issue. I came from
> MS SQL and it would be hard for me to put into words how much of a better
job
> you all are doing on [PostgreSQL]."

Also, just curious. Your emails often end with a nice quote. Does a tool
pick those for you?

Attachment Content-Type Size
v3-0001-Require-partitions-to-use-the-parent-s-virtual-gener.patch application/octet-stream 29.1 KB
nocfbot-v3-REL_18-0001-Require-partitions-to-use-the-parent-s-virtual-gen.patch application/octet-stream 23.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message shihao zhong 2026-11-12 04:40:05 Re: REPACK (CONCURRENTLY) decoding worker is canceled by lock_timeout
Previous Message shihao zhong 2026-11-12 04:30:38 Re: Partitioned index marked valid while a partition is pending detach

Browse pgsql-committers by date

  From Date Subject
Previous Message Etsuro Fujita 2026-11-12 02:18:08 pgsql: postgres_fdw: Update some comments in functions for statistics i