Re: XML schemas and PG column names

Peter Eisentraut wrote:
> On lör, 2009-12-12 at 11:51 -0500, Andrew Dunstan wrote:
>
>> It is certainly legal per XML and XSD specs, and the SQL/XML spec has
>> annotations using appinfo elements. It would be rather surprising if
>> the
>> SQL/XML spec forbade annotations such as I propose. The spec is
>> mind-bogglingly impenetrable, though. Perhaps Peter or Nicholas might
>> know.
>>
>
> I think we can of course add our own annotations. It would be good to
> go through the SQL/XML standard document and check what style they use
> for their annotations so that we can structure and name ours similarly
> and have room for future work, in case someone also wants annotations
> for table names, schema names, etc. (Or was that part of your project as
> well?)
>
>

Well, the standard has an element specifically for annotations
concerning certain objects: sqlxml:sqlname. However, I am not sure if it
can be used in this context. Can you try reading the standard
(<http://www.sqlx.org/SQL-XML-documents/5FCD-14-XML-2004-07.pdf>) and
tell me? :-) If it's not comprehended by the standard then we should at
least use a different namespace, and probably a different element name.
The style can be made to match, though.

I certainly think we could do more of this, although the column names
are what matter to me right now. We can also do it bit by bit.

cheers

andrew