Re: [PATCH] pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement

From: solai v <solai(dot)cdac(at)gmail(dot)com>
To: Florin Irion <irionr(at)gmail(dot)com>
Cc: Japin Li <japinli(at)hotmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement
Date: 2026-07-13 09:27:46
Message-ID: CAF0whueHXsGcKgoxzneDbk8DPxjtRmYGBAzy-J7yUVt+H4k+9w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Florin,

I tested v11 of the patch on current master. The patch applied
cleanly, and I was able to build and install PostgreSQL without any
issues.
I tested a few different cases, including domains with CHECK
constraints, DEFAULT values, and NOT NULL constraints. In all cases,
pg_get_domain_ddl() generated the expected CREATE DOMAIN statement.
I also verified both the default and pretty-printed output formats,
and they produced the expected results. Finally, I checked the
behavior with a non-existent domain and confirmed that it returns an
appropriate error.

Overall, the patch worked as expected in my testing.
regards,
Solai

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Akshay Joshi 2026-07-13 09:29:17 Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement
Previous Message Daniel Gustafsson 2026-07-13 09:21:56 Re: Clarify or fix SIGINT handling in data checksums launcher