Re: pg_dump misses comments on NOT NULL constraints - Mailing list pgsql-hackers

From Álvaro Herrera
Subject Re: pg_dump misses comments on NOT NULL constraints
Date
Msg-id 202506180853.mqm3u7qov52b@alvherre.pgsql
Whole thread Raw
In response to Re: pg_dump misses comments on NOT NULL constraints  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List pgsql-hackers
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)



pgsql-hackers by date:

Previous
From: Jelte Fennema-Nio
Date:
Subject: Re: minimum Meson version
Next
From: Bertrand Drouvot
Date:
Subject: Re: POC: enable logical decoding when wal_level = 'replica' without a server restart