MIME-Version: 1.0
From: Kirill Reshke <reshkekirill@gmail.com>
Date: Tue, 12 Nov 2024 17:54:46 +0500
Message-ID: <CALdSSPh4jUSDsWu3K58hjO60wnTRR0DuO4CKRcwa8EVuOSfXxg@mail.gmail.com>
Subject: CREATE SCHEMA ... CREATE DOMAIN support
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="00000000000072cdce0626b6b9ec"
Archived-At: <https://www.postgresql.org/message-id/CALdSSPh4jUSDsWu3K58hjO60wnTRR0DuO4CKRcwa8EVuOSfXxg%40mail.gmail.com>
Precedence: bulk

--00000000000072cdce0626b6b9ec
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi hackers!

This copy of my reply mail from pgsql-general[0], & [1] which was held
for moderation for some reason.

Here it goes as-is :

=3D=3D begin
Hi =C3=81lvaro, thanks for the detailed explanation.

So, IIUC you are suggesting to support SQL standard features before
any work with PostgreSQL extension.
Ok, I will try to go this way. PFA patch implementing CREATE DOMAIN
support for CREATE SCHEMA statement.
Of all other options, CREATE DOMAIN support looks like the most stranfoward=
 one.

Patch obviously leaks doc & regression tests, but I'm posting it to
see if this contribution is needed in PostgreSQL

=3D=3D end


[0] https://www.postgresql.org/message-id/CALdSSPgxcRkooZ2iQ5A7XhYoexVAdbiT=
6znZDqJTE8hxUVjz_A%40mail.gmail.com

[1] https://www.postgresql.org/message-id/202411111009.ckna4vp7ahyk%40alvhe=
rre.pgsql
--=20
Best regards,
Kirill Reshke

--00000000000072cdce0626b6b9ec
Content-Type: application/octet-stream; 
	name="v1-0001-Extend-CREATE-SCHEMA-element-with-DOMAIN-support.patch"
Content-Disposition: attachment; 
	filename="v1-0001-Extend-CREATE-SCHEMA-element-with-DOMAIN-support.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_m3egebrs0>
X-Attachment-Id: f_m3egebrs0

RnJvbSA4NjUxNWRhYjAzNmU5YTgzMzlkMjUwZjhkYTNhNjE4NWQzYmMwZmYyIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiByZXNoa2Uga2lyaWxsIDxyZXNoa2VAZG91YmxlLmNsb3VkPgpE
YXRlOiBNb24sIDExIE5vdiAyMDI0IDIxOjE4OjU2ICswMDAwClN1YmplY3Q6IFtQQVRDSCB2MV0g
RXh0ZW5kIENSRUFURSBTQ0hFTUEgZWxlbWVudCB3aXRoIERPTUFJTiBzdXBwb3J0LgoKU1FMIHN0
YW5kYXJ0IGFsbG93IGRvbWFpbiB0byBiZSBzcGVjaWZpZWQgd2l0aCBDUkVBVEUgU0NIRU1BCnN0
YXRlbWVudC4gVGhpcyBwYXRjaCBhZGRzIHN1cHBvcnQgaW4gUG9zdGdyZVNRTCBmb3IgdGhhdC4K
LS0tCiBzcmMvYmFja2VuZC9wYXJzZXIvZ3JhbS55ICAgICAgICAgIHwgIDEgKwogc3JjL2JhY2tl
bmQvcGFyc2VyL3BhcnNlX3V0aWxjbWQuYyB8IDE2ICsrKysrKysrKysrKysrKysKIDIgZmlsZXMg
Y2hhbmdlZCwgMTcgaW5zZXJ0aW9ucygrKQoKZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3BhcnNl
ci9ncmFtLnkgYi9zcmMvYmFja2VuZC9wYXJzZXIvZ3JhbS55CmluZGV4IDY3ZWI5NjM5NmEuLmFk
OGQ5MjcwYWMgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3BhcnNlci9ncmFtLnkKKysrIGIvc3Jj
L2JhY2tlbmQvcGFyc2VyL2dyYW0ueQpAQCAtMTU4NCw2ICsxNTg0LDcgQEAgc2NoZW1hX3N0bXQ6
CiAJCQl8IENyZWF0ZVRyaWdTdG10CiAJCQl8IEdyYW50U3RtdAogCQkJfCBWaWV3U3RtdAorCQkJ
fCBDcmVhdGVEb21haW5TdG10CiAJCTsKIAogCmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC9wYXJz
ZXIvcGFyc2VfdXRpbGNtZC5jIGIvc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX3V0aWxjbWQuYwpp
bmRleCAwZjMyNGVlNGUzLi5lNzRiNmY4YTA0IDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC9wYXJz
ZXIvcGFyc2VfdXRpbGNtZC5jCisrKyBiL3NyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV91dGlsY21k
LmMKQEAgLTEwNSw2ICsxMDUsNyBAQCB0eXBlZGVmIHN0cnVjdAogCUxpc3QJICAgKmluZGV4ZXM7
CQkvKiBDUkVBVEUgSU5ERVggaXRlbXMgKi8KIAlMaXN0CSAgICp0cmlnZ2VyczsJCS8qIENSRUFU
RSBUUklHR0VSIGl0ZW1zICovCiAJTGlzdAkgICAqZ3JhbnRzOwkJCS8qIEdSQU5UIGl0ZW1zICov
CisJTGlzdAkgICAqZG9tYWluczsJCS8qIERPTUFJTiBpdGVtcyAqLwogfSBDcmVhdGVTY2hlbWFT
dG10Q29udGV4dDsKIAogCkBAIC00MDM5LDYgKzQwNDAsNyBAQCB0cmFuc2Zvcm1DcmVhdGVTY2hl
bWFTdG10RWxlbWVudHMoTGlzdCAqc2NoZW1hRWx0cywgY29uc3QgY2hhciAqc2NoZW1hTmFtZSkK
IAljeHQuaW5kZXhlcyA9IE5JTDsKIAljeHQudHJpZ2dlcnMgPSBOSUw7CiAJY3h0LmdyYW50cyA9
IE5JTDsKKwljeHQuZG9tYWlucyA9IE5JTDsKIAogCS8qCiAJICogUnVuIHRocm91Z2ggZWFjaCBz
Y2hlbWEgZWxlbWVudCBpbiB0aGUgc2NoZW1hIGVsZW1lbnQgbGlzdC4gU2VwYXJhdGUKQEAgLTQx
MDcsNiArNDEwOSwxOSBAQCB0cmFuc2Zvcm1DcmVhdGVTY2hlbWFTdG10RWxlbWVudHMoTGlzdCAq
c2NoZW1hRWx0cywgY29uc3QgY2hhciAqc2NoZW1hTmFtZSkKIAkJCQljeHQuZ3JhbnRzID0gbGFw
cGVuZChjeHQuZ3JhbnRzLCBlbGVtZW50KTsKIAkJCQlicmVhazsKIAorCQkJY2FzZSBUX0NyZWF0
ZURvbWFpblN0bXQ6CisJCQkJeworCQkJCQlDcmVhdGVEb21haW5TdG10ICplbHAgPSAoQ3JlYXRl
RG9tYWluU3RtdCAqKSBlbGVtZW50OworCisJCQkJCS8qIERPTUFJTiBuYW1lIGNhbiBiZSBhbHJl
YWR5IHF1YWxpZmllZC4gKi8KKwkJCQkJaWYgKGVscC0+ZG9tYWlubmFtZS0+bGVuZ3RoID09IDEp
IHsKKwkJCQkJCWVscC0+ZG9tYWlubmFtZSA9IGxjb25zKG1ha2VTdHJpbmcocHN0cmR1cChjeHQu
c2NoZW1hbmFtZSkpLCBlbHAtPmRvbWFpbm5hbWUpOworCQkJCQl9CisKKwkJCQkJY3h0LmRvbWFp
bnMgPSBsYXBwZW5kKGN4dC5kb21haW5zLCBlbGVtZW50KTsKKwkJCQl9CisJCQkJYnJlYWs7CisK
IAkJCWRlZmF1bHQ6CiAJCQkJZWxvZyhFUlJPUiwgInVucmVjb2duaXplZCBub2RlIHR5cGU6ICVk
IiwKIAkJCQkJIChpbnQpIG5vZGVUYWcoZWxlbWVudCkpOwpAQCAtNDEyMCw2ICs0MTM1LDcgQEAg
dHJhbnNmb3JtQ3JlYXRlU2NoZW1hU3RtdEVsZW1lbnRzKExpc3QgKnNjaGVtYUVsdHMsIGNvbnN0
IGNoYXIgKnNjaGVtYU5hbWUpCiAJcmVzdWx0ID0gbGlzdF9jb25jYXQocmVzdWx0LCBjeHQuaW5k
ZXhlcyk7CiAJcmVzdWx0ID0gbGlzdF9jb25jYXQocmVzdWx0LCBjeHQudHJpZ2dlcnMpOwogCXJl
c3VsdCA9IGxpc3RfY29uY2F0KHJlc3VsdCwgY3h0LmdyYW50cyk7CisJcmVzdWx0ID0gbGlzdF9j
b25jYXQocmVzdWx0LCBjeHQuZG9tYWlucyk7CiAKIAlyZXR1cm4gcmVzdWx0OwogfQotLSAKMi4z
NC4xCgo=
--00000000000072cdce0626b6b9ec--