Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vknnO-002K2L-0Y for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Jan 2026 18:28:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vknnM-00FalH-10 for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Jan 2026 18:28:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vknnM-00Fal9-01 for pgsql-hackers@lists.postgresql.org; Tue, 27 Jan 2026 18:28:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vknnJ-00000000kXF-3wOp for pgsql-hackers@lists.postgresql.org; Tue, 27 Jan 2026 18:28:08 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vknnH-007fr5-0w for pgsql-hackers@lists.postgresql.org; Tue, 27 Jan 2026 18:28:04 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vknnH-0062Rc-2F for pgsql-hackers@lists.postgresql.org; Tue, 27 Jan 2026 18:28:03 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: [PATCH] pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement To: pgsql-hackers@lists.postgresql.org From: Haritabh Gupta Cc: Florin Irion , Tim Waizenegger Date: Tue, 27 Jan 2026 18:27:15 +0000 User-Agent: pgcommitfest X-cfsender: haritabhgupta In-Reply-To: <5dbba701-c93b-4625-b35b-76d52131535e@gmail.com> References: <5dbba701-c93b-4625-b35b-76d52131535e@gmail.com> Message-ID: <176953843500.1247419.17388294117341687241.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGVsbG8sDQpQbGVhc2UgZmluZCBiZWxvdyBzb21lIGNvbW1lbnRzIChtb3N0bHkgbWlub3Igb25l cyk6DQoNCjEuIFdlIG5lZWQgdG8gYWRkIHRoZSBmb2xsb3dpbmcgY29tbWEgaW4gdGhlIGRvY3Mg Y2hhbmdlLiBzbyB0aGF0IGl0IGxvb2tzIHNhbWUgYXMgb3RoZXIgZnVuY3Rpb25zOg0KZGlmZiAt LWdpdCBhL2RvYy9zcmMvc2dtbC9mdW5jL2Z1bmMtaW5mby5zZ21sIGIvZG9jL3NyYy9zZ21sL2Z1 bmMvZnVuYy1pbmZvLnNnbWwNCmluZGV4IDI1Zjg3Yjc4MzQ0Li5iYzAxYzczZjRlYSAxMDA2NDQN Ci0tLSBhL2RvYy9zcmMvc2dtbC9mdW5jL2Z1bmMtaW5mby5zZ21sDQorKysgYi9kb2Mvc3JjL3Nn bWwvZnVuYy9mdW5jLWluZm8uc2dtbA0KQEAgLTM4NjEsNyArMzg2MSw3IEBAIGFjbCAgICAgIHwg e3Bvc3RncmVzPWFyd2REeHRtL3Bvc3RncmVzLGZvbz1yL3Bvc3RncmVzfQ0KICAgICAgICAgIDxw cmltYXJ5PnBnX2dldF9kb21haW5fZGRsPC9wcmltYXJ5Pg0KICAgICAgICAgPC9pbmRleHRlcm0+ DQogICAgICAgICA8ZnVuY3Rpb24+cGdfZ2V0X2RvbWFpbl9kZGw8L2Z1bmN0aW9uPiAoIDxwYXJh bWV0ZXI+ZG9tYWluPC9wYXJhbWV0ZXI+IDx0eXBlPnJlZ3R5cGU8L3R5cGU+DQotICAgICAgICAg PG9wdGlvbmFsPiA8cGFyYW1ldGVyPnByZXR0eTwvcGFyYW1ldGVyPiA8dHlwZT5ib29sZWFuPC90 eXBlPiA8L29wdGlvbmFsPikNCisgICAgICAgICA8b3B0aW9uYWw+LCA8cGFyYW1ldGVyPnByZXR0 eTwvcGFyYW1ldGVyPiA8dHlwZT5ib29sZWFuPC90eXBlPiA8L29wdGlvbmFsPikNCiAgICAgICAg IDxyZXR1cm52YWx1ZT50ZXh0PC9yZXR1cm52YWx1ZT4NCiAgICAgICAgPC9wYXJhPg0KICAgICAg ICA8cGFyYT4NCg0KDQoyLiBJbiB0aGUgZnVuY3Rpb24gc2lnbmF0dXJlIHRoZXJlIGlzIGBpbnQg cHJldHR5RmxhZ3NgIGFyZ3VtZW50LCB3aGlsZSB0aGUgZG9jIHN1Z2dlc3RzIGBwcmV0dHlgOg0K Ky8qDQorICogZ2V0X2Zvcm1hdHRlZF9zdHJpbmcNCisgKg0KKyAqIFJldHVybiBhIGZvcm1hdHRl ZCB2ZXJzaW9uIG9mIHRoZSBzdHJpbmcuDQorICoNCisgKiBwcmV0dHkgLSBJZiBwcmV0dHkgaXMg dHJ1ZSwgdGhlIG91dHB1dCBpbmNsdWRlcyB0YWJzIChcdCkgYW5kIG5ld2xpbmVzIChcbikuDQor ICogbm9PZlRhYkNoYXJzIC0gaW5kZW50IHdpdGggc3BlY2lmaWVkIG5vIG9mIHRhYnMuDQorICog Zm10IC0gcHJpbnRmLXN0eWxlIGZvcm1hdCBzdHJpbmcgdXNlZCBieSBhcHBlbmRTdHJpbmdJbmZv VkEuDQorICovDQorc3RhdGljIHZvaWQNCitnZXRfZm9ybWF0dGVkX3N0cmluZyhTdHJpbmdJbmZv IGJ1ZiwgaW50IHByZXR0eUZsYWdzLCBpbnQgbm9PZlRhYkNoYXJzLCBjb25zdCBjaGFyICpmbXQs Li4uKQ0KDQoNCjMuIEluIGEgc2ltaWxhciBwYXRjaCAoaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5v cmcvbWVzc2FnZS1pZC9mbGF0L0NBTnhvTERkSnNSSnFuak1YVjN5anNrMDdaNWlSV3hHLWMyaFpK QzdiQUtxZjhaWGpfQUBtYWlsLmdtYWlsLmNvbSksIGF1dGhvciBoYXMgZGVmaW5lZCBhIHNlcGFy YXRlIG1hY3JvIHRvIG1ha2UgdGhlIHVzYWdlIG9mIGBHRVRfUFJFVFRZX0ZMQUdTYCBjbGVhbmVy LCBXZSBjYW4gdXNlIHRoZSBzYW1lIGluIGZ1bmN0aW9uIGBwZ19nZXRfZG9tYWluX2RkbF9leHRg Og0KKyNkZWZpbmUgR0VUX0RETF9QUkVUVFlfRkxBR1MocHJldHR5KSBcDQorICAgICgocHJldHR5 KSA/IChQUkVUVFlGTEFHX1BBUkVOIHwgUFJFVFRZRkxBR19JTkRFTlQgfCBQUkVUVFlGTEFHX1ND SEVNQSkgXA0KKyAgICAgOiAwKQ0KDQorRGF0dW0NCitwZ19nZXRfcG9saWN5X2RkbChQR19GVU5D VElPTl9BUkdTKQ0KK3sNCisgICAgT2lkICAgICAgICAgICAgdGFibGVJRCA9IFBHX0dFVEFSR19P SUQoMCk7DQorICAgIE5hbWUgICAgICAgIHBvbGljeU5hbWUgPSBQR19HRVRBUkdfTkFNRSgxKTsN CisgICAgYm9vbCAgICAgICAgcHJldHR5ID0gUEdfR0VUQVJHX0JPT0woMik7DQorICAgIGludCAg ICAgICAgICAgIHByZXR0eUZsYWdzOw0KKyAgICBjaGFyICAgICAgICpyZXM7DQorDQorICAgIHBy ZXR0eUZsYWdzID0gR0VUX0RETF9QUkVUVFlfRkxBR1MocHJldHR5KTsNCg0KNC4gVXN1YWxseSB0 aGUgdGVzdHMgZm9yIHRoZSBmdW5jdGlvbiB0byBnZXQgdGhlIERETCBkZWZpbml0aW9uIG9mIGFu IG9iamVjdCBhcmUgcHJlc2VudCBpbiB0aGUgc2FtZSB0ZXN0Y2FzZSBmaWxlIHdoZXJlIHRoZSBg Q1JFQVRFLi4uYCBjb21tYW5kIGV4aXN0cywgZS5nLiB0ZXN0IGZvciBgcGdfZ2V0X2luZGV4ZGVm YCBleGlzdHMgaW4gYGNyZWF0ZV9pbmRleC5zcWxgIGZpbGUuIFNpbWlsYXJseSB0ZXN0cyBmb3Ig YHBnX2dldF9mdW5jdGlvbmRlZmAgZXhpc3RzIGluIGBjcmVhdGVfcHJvY2VkdXJlLnNxbGAgZmls ZSBhbmQgc28gb24uIEN1cnJlbnRseSBpbiB0aGUgcGF0Y2gsIHRoZSB0ZXN0cyBmb3IgYHBnX2dl dF9kb21haW5fZGRsYCBhcmUgcHV0IGluIGEgbmV3IGZpbGUgYG9iamVjdF9kZGwuc3FsYCBidXQg SSBndWVzcyBpdCBjYW4gYmUgcHV0IGluIHRoZSBleGlzdGluZyBmaWxlIGBkb21haW4uc3FsYCBi ZWNhdXNlIHRoYXQgaXMgd2hlcmUgdGhlIGBDUkVBVEUgRE9NQUlOLi4uYCB0ZXN0cyByZXNpZGUu