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