Hello PostgreSQL XML Experts,
I was exploring xml support in postgreSQL and ran into few questions answer to which I couldn’t find easily in the documentation. I would appreciate responses to following queries:
1) Can xml column be constrained to be DOCUMENT or CONTENT type?
XMLPARSE/XMLSERIALIZE functions allows to set XML option DOCUMENT or CONTENT type. Can we do the same when defining an xml column level?
2) Is there plan in near future to support XML schema validation i.e to ensure inserted xml document conforms to a preregistered set of XML schemas.
3) Support for XQuery – I know it is asking for too much but when do you see it happening in the future.
4) Support for xml indexes – Is it something that is being worked upon for next release?
Our application support many underlying databases and I would hate to list out the stuff users cannot do when using xml datatype in postgresql. So far for non-xml functionality we haven’t had to this and I hope I don’t need to do it for xml as well.
Thanks,
Brijesh