MIME-Version: 1.0
References: 
 <CAN3aFCdx8AapWSVpJ1kaC7OC_v7QwbjgbGw9WfPBBY2GMyOadQ@mail.gmail.com>
 <CAN3aFCecpcPBs4x3KUuxTqvY2VzpCZZKrBphNaQjE5uD8UtEpQ@mail.gmail.com>
 <CAN3aFCcb0Nvap1CKShd5RNa+V+pray+ur_LtOON3nkwqdh5NMA@mail.gmail.com>
 <2ba05acc-6392-42a4-b59e-61df086b2d4d@uni-muenster.de>
 <CAN3aFCdW3_RNgidcV_vWA-NFeYf6p7M5VMG8moSzk3bBJneUxQ@mail.gmail.com>
 <1d49e214-93bc-4928-945c-27e60251a6ad@uni-muenster.de>
 <CAN3aFCfkrkOJ+R39x=9qvXMGLE3yuL9fZdNyRa5V=BAdGGu=-g@mail.gmail.com>
 <9228b6dc-cfae-4a11-927a-209680f5507e@uni-muenster.de>
 <CAN3aFCcvXHmW+FKS7gX=HoUcjku2nr7XKJEZm05DrgsQxy79HQ@mail.gmail.com>
 <2f8ca841-0956-4e7d-8fa2-038b879c8f4d@uni-muenster.de>
 <CAFj8pRB3d_fREmgzT1GQwG_wfR1brxyTMVsAV=bbpOzvPkauLg@mail.gmail.com>
 <de6dade3-4956-4b57-b51d-1db703e16702@uni-muenster.de>
 <CAFj8pRBg6bbO4YiSO633RHMOqQ3jAtVtCq=oN8TPE2FHG9LY2Q@mail.gmail.com>
 <d8b8cd5c-dc01-40b2-8eb9-edbc0d6fbbf2@uni-muenster.de>
 <CAFj8pRBq4580f5n7DTe7x+SWqCS_d=e1Of7snUNaKk8_L1g28Q@mail.gmail.com>
 <f185992f-a566-4174-a3a8-fbf4b9d04ea3@uni-muenster.de>
 <CAFj8pRDEOmkafV3s7XjCK-DzvnhoxgvHWJ7tChUi=-8zJ20Vog@mail.gmail.com>
In-Reply-To: 
 <CAFj8pRDEOmkafV3s7XjCK-DzvnhoxgvHWJ7tChUi=-8zJ20Vog@mail.gmail.com>
From: Marcos Magueta <maguetamarcos@gmail.com>
Date: Thu, 2 Apr 2026 15:22:32 -0300
Message-ID: 
 <CAN3aFCciiHajOu5J4Qq3zZY03QFtgQZW5m-SmWyo7HE+6XqocQ@mail.gmail.com>
Subject: Re: WIP - xmlvalidate implementation from TODO list
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Jim Jones <jim.jones@uni-muenster.de>,
 Andrey Borodin <x4mmm@yandex-team.ru>,
	Kirill Reshke <reshkekirill@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005c5438064e7e49a9"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN3aFCciiHajOu5J4Qq3zZY03QFtgQZW5m-SmWyo7HE%2B6XqocQ%40mail.gmail.com>
Precedence: bulk

--0000000000005c5438064e7e49a9
Content-Type: text/plain; charset="UTF-8"

Hey Jim and Pavel, thanks for demonstrating interest.

> XML is a little bit outdated - but the proposed infrastructure can be
used for any documents, so it can theoretically supports json, jsonb too
[...]. I expect something like XMLVALIDATE will be JSON standard in a few
years.

That doesn't sound like a bad idea to me. But I suspect I would need to
almost completely revamp the implementation in the patch so far, so I would
like to confirm a few things before committing to anything on that front.

I am still unsure how the permissions would be managed properly with the
API approach. It seems to me we could rely on the ACL like before, but I
sense there's something more arcane around it when it comes to the
extension.

I didn't realize, but DB2 actually gives you decomposition over an xml
hierarchy into tables, which is an insanely valuable feature. I wonder how
we could go with that here using the current catalog approach.

Is there anything else that might be troublesome with changing approaches?

Regards, Marcos.

--0000000000005c5438064e7e49a9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div>Hey Jim and Pavel, thanks for demonstrating inte=
rest.<br><br>&gt;=C2=A0XML is a little bit outdated=C2=A0- but the proposed=
 infrastructure=C2=A0can be used for any documents, so it can theoretically=
 supports json, jsonb too [...]. I expect something like XMLVALIDATE will b=
e JSON standard in a few years.<br><br>That doesn&#39;t sound like a bad id=
ea to me. But I suspect I would need to almost completely revamp the implem=
entation in the patch so far, so I would like to confirm a few things befor=
e committing to anything on that front.<br><br></div>I am still unsure how =
the permissions would be managed properly with the API approach. It seems t=
o me we could rely on the ACL like before, but I sense there&#39;s somethin=
g more arcane around it when it comes to the extension.</div><div><br>I did=
n&#39;t realize, but DB2 actually gives you decomposition over an xml hiera=
rchy into tables, which is an insanely valuable feature. I wonder how we co=
uld go with that here using the current catalog approach.<br><br></div><div=
>Is there anything else that might be troublesome with changing approaches?=
</div><div><br></div>Regards, Marcos.</div>

--0000000000005c5438064e7e49a9--