Re: PROPOSAL of xmlvalidate

On Mon, Nov 29, 2010 at 12:56 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
> On 11/29/2010 12:36 PM, Robert Haas wrote:
>> On Mon, Nov 29, 2010 at 12:18 PM, Pavel Stehule<pavel.stehule@gmail.com>
>>  wrote:
>>> 2010/11/29 Robert Haas<robertmhaas@gmail.com>:
>>>> On Sun, Nov 28, 2010 at 5:33 AM, Tomáš Pospíšil<killteck@seznam.cz>
>>>>  wrote:
>>>>> I have idea of creating system table for holding DTDs, XSDs, Relax-NGs
>>>>> (similar as on ORACLE).
>>>>>
>>>>> Is that good idea?
>>>>
>>>> I doubt it.  Why would we want to do that?
>>>
>>> If I understand, it allows a local copy of DTD, .. so then is possible
>>> to provide a fast DTD checking.
>>
>> But that could equally well be stored in a user table rather than a
>> system table.
>
> Yeah. The trouble is you won't be able to use that reliably in a check
> constraint, which I imagine is one of the principal intended purposes. I'm
> not sure how we should go about that.

There is a whole category of things where you might want to write a
check constraint that involves accessing data in some other table, and
therefore it falls down because this makes the constraint
non-immutable.  But not infrequently one knows that, while in theory
the other table could change, in practice it will not, or only in ways
that won't cause the CHECK constraint to be violated.  We need to
think about a sensible way of handling this class of problems.
Putting the data into a system table doesn't really accomplish
anything; system tables aren't read-only either.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company