public inbox for [email protected]
help / color / mirror / Atom feedFrom: Pavel Stehule <[email protected]>
To: Jim Jones <[email protected]>
Cc: Marcos Magueta <[email protected]>
Cc: Andrey Borodin <[email protected]>
Cc: Kirill Reshke <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: WIP - xmlvalidate implementation from TODO list
Date: Wed, 1 Apr 2026 10:10:56 +0200
Message-ID: <CAFj8pRBq4580f5n7DTe7x+SWqCS_d=e1Of7snUNaKk8_L1g28Q@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAN3aFCdx8AapWSVpJ1kaC7OC_v7QwbjgbGw9WfPBBY2GMyOadQ@mail.gmail.com>
<[email protected]>
<[email protected]>
<CAN3aFCecpcPBs4x3KUuxTqvY2VzpCZZKrBphNaQjE5uD8UtEpQ@mail.gmail.com>
<CAN3aFCcb0Nvap1CKShd5RNa+V+pray+ur_LtOON3nkwqdh5NMA@mail.gmail.com>
<[email protected]>
<CAN3aFCdW3_RNgidcV_vWA-NFeYf6p7M5VMG8moSzk3bBJneUxQ@mail.gmail.com>
<[email protected]>
<CAN3aFCfkrkOJ+R39x=9qvXMGLE3yuL9fZdNyRa5V=BAdGGu=-g@mail.gmail.com>
<[email protected]>
<CAN3aFCcvXHmW+FKS7gX=HoUcjku2nr7XKJEZm05DrgsQxy79HQ@mail.gmail.com>
<[email protected]>
<CAFj8pRB3d_fREmgzT1GQwG_wfR1brxyTMVsAV=bbpOzvPkauLg@mail.gmail.com>
<[email protected]>
<CAFj8pRBg6bbO4YiSO633RHMOqQ3jAtVtCq=oN8TPE2FHG9LY2Q@mail.gmail.com>
<[email protected]>
st 1. 4. 2026 v 9:47 odesÃlatel Jim Jones <[email protected]>
napsal:
>
>
> On 31/03/2026 12:57, Pavel Stehule wrote:
> > I found https://www.developpez.net/forums/d540201/bases-donnees/db2/
> > validation-xml-db2-v9-5-a/ <https://www.developpez.net/forums/d540201/
> > bases-donnees/db2/validation-xml-db2-v9-5-a/>
>
> Interesting. In DB2 it looks indeed more like a schema composition.
> Perhaps something to consider once the current approach is ready.
>
It should be considered from the beginning - it means that the relational
identifier is not unique. It can complicate upgrades. And it can
complicate possible ports from db2.
maybe it can be implemented just as an extension - we don't need DDL
commands CREATE XMLSCHEMA - there can be some function. If I understand
correctly, the SQL/XML knows just XMLVALIDATE command - and in the first
step - this can be just a function too.
Theoretically there can be different access - we can introduce a generic
XMLVALIDATE command, that can call some callback. This callback can be
implemented in an extension. One extension can XML storage identified by
relation identifier, another can implement some shared storage on the disc
outside the database etc. So the organization of the patch can be different
1. creating API for extensions for implementing loading the schema from
some sources.
2. implementation XMLVALIDATE that uses this API
3. creating an extension in contrib, that implements XML storage identified
by relational API.
Because we don't have an extensible parser, the XMLVALIDATE command should
be in core, but other parts are not.
XML is a little bit outdated - but the proposed infrastructure can be used
for any documents, so it can theoretically supports json, jsonb too, and
this can helps with accepting XMLVALIDATE to core. I expect something like
XMLVALIDATE will be JSON standard in a few years.
Regards
Pavel
> Best, Jim
>
>
view thread (17+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: WIP - xmlvalidate implementation from TODO list
In-Reply-To: <CAFj8pRBq4580f5n7DTe7x+SWqCS_d=e1Of7snUNaKk8_L1g28Q@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox