Re: pg_dump does not dump domain not-null constraint's comments

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_dump does not dump domain not-null constraint's comments
Date: 2025-05-07 14:56:01
Message-ID: 202505071456.elpjza2ky65d@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ooh, you know what? I ran your the CREATE DOMAIN statement in your new
test and pg_dump'ed that, and as far as I can tell the _name_ of the
not-null constraint is not dumped either. So it's not just the comment
that we're losing. That's a separate bug, and probably needs to be
fixed first, although I'm not sure if that one is going to be
back-patchable. Which means, I withdraw my earlier assessment that the
comment fix is back-patchable as a whole.

--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2025-05-07 15:00:45 Re: PostgreSQL 18 Beta 1 release announcement draft
Previous Message Nathan Bossart 2025-05-07 14:51:19 Re: Horribly slow pg_upgrade performance with many Large Objects