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

From: zengman <zengman(at)halodbtech(dot)com>
To: tim(dot)waizenegger <tim(dot)waizenegger(at)enterprisedb(dot)com>, florin(dot)irion <florin(dot)irion(at)enterprisedb(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: [PATCH] pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement
Date: 2025-11-20 06:42:15
Message-ID: tencent_64301BB7627E58CD256CE15F@qq.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello everyone,

I have tested the v4 patch and observed that the following scenario requires support. Accordingly, I have prepared version v5: v5-0001 is fully consistent with the v4 patch, and v5-0002 restricts input to domains exclusively, with an additional simple test case attached.

```sql
postgres=# create table test_table(a int);
CREATE TABLE
postgres=# SELECT pg_get_domain_ddl('test_table');
ERROR: cache lookup failed for type 0
```

--
Regrads,
Man Zeng

Attachment Content-Type Size
v5-0001-Add-pg_get_domain_ddl-function-to-reconstruct-CRE.patch application/octet-stream 39.2 KB
v5-0002-Add-pg_get_domain_ddl-function-to-reconstruct-CRE.patch application/octet-stream 2.7 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2025-11-20 06:53:49 Re: Allow GUC settings in CREATE SUBSCRIPTION CONNECTION to take effect
Previous Message Peter Smith 2025-11-20 06:24:12 Re: Skipping schema changes in publication