Re: pg_dump misses comments on NOT NULL constraints

On 2025-Jun-18, Fujii Masao wrote:

> On 2025/06/18 9:13, Fujii Masao wrote:

> > In v18, we can now add comments on NOT NULL constraints. However, I noticed
> > that pg_dump doesn't include those comments in its output. For example:

This is definitely a bug, thanks for reporting.

> I ran into another issue related to comments on NOT NULL constraints.
> When using CREATE TABLE ... (LIKE ... INCLUDING ALL), the NOT NULL constraints
> are copied, but their comments are not.

... and I agree that it'd be good to fix this one as well.

Jian He just mentioned to me that he's looking into these problems.
Many thanks to him.  I'm pretty much unable to get anything done this
week, but I'll be back online next week.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Java is clearly an example of money oriented programming"  (A. Stepanov)