[PATCH] pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement
zengman <zengman@halodbtech.com>
From: zengman <zengman@halodbtech.com>
To: tim.waizenegger <tim.waizenegger@enterprisedb.com>, florin.irion <florin.irion@enterprisedb.com>
Cc: pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-11-20T06:42:15Z
Lists: pgsql-hackers
Attachments
- v5-0001-Add-pg_get_domain_ddl-function-to-reconstruct-CRE.patch (application/octet-stream)
- v5-0002-Add-pg_get_domain_ddl-function-to-reconstruct-CRE.patch (application/octet-stream)
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