pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Álvaro Herrera <alvherre@kurilemu.de>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: pg_dump: include comments on not-null constraints on domains, to
Date: Mon, 21 Jul 2025 09:35:54 +0000
Message-ID: <E1udmw5-0000VB-3B@gemulon.postgresql.org> (raw)

pg_dump: include comments on not-null constraints on domains, too

Commit e5da0fe3c22b introduced catalog entries for not-null constraints
on domains; but because commit b0e96f311985 (the original work for
catalogued not-null constraints on tables) forgot to teach pg_dump to
process the comments for them, this one also forgot.  Add that now.

We also need to teach repairDependencyLoop() about the new type of
constraints being possible for domains.

Backpatch-through: 17
Co-authored-by: jian he <jian.universality@gmail.com>
Co-authored-by: Álvaro Herrera <alvherre@kurilemu.de>
Reported-by: jian he <jian.universality@gmail.com>
Discussion: https://postgr.es/m/CACJufxF-0bqVR=j4jonS6N2Ka6hHUpFyu3_3TWKNhOW_4yFSSg@mail.gmail.com

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/6b755d8d70b2ceffeb4798cbb6907d2704c2e6c4

Modified Files
--------------
src/bin/pg_dump/pg_dump.c        | 160 +++++++++++++++++++++++++++++----------
src/bin/pg_dump/pg_dump.h        |   4 +-
src/bin/pg_dump/pg_dump_sort.c   |  15 ++--
src/bin/pg_dump/t/002_pg_dump.pl |  30 +++++++-
4 files changed, 160 insertions(+), 49 deletions(-)



view thread (3+ messages)  latest in thread

Message-ID: <E1udmw5-0000VB-3B@gemulon.postgresql.org>
Permalink:  ../E1udmw5-0000VB-3B@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1udmw5-0000VB-3B@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: alvherre@kurilemu.de, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: pg_dump: include comments on not-null constraints on domains, to
  In-Reply-To: <E1udmw5-0000VB-3B@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox