Bruce Momjian wrote:
Added to TODO: * Allow XML to accept more liberal DOCTYPE specifications
Is any form of DOCTYPE accepted? We're getting errors on a second line in an XML document that starts like this: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE DOT_OFFICER_CITATION SYSTEM "http://host.domain/dtd/dotdisposition0_02.dtd";> The actual host.domain value is resolved by DNS, and wget of the url works on the server running PostgreSQL. Attempts to cast the document to type xml give: ERROR: invalid XML content DETAIL: Entity: line 2: parser error : StartTag: invalid element name <!DOCTYPE DOT_OFFICER_CITATION SYSTEM "http://host.domain/dtd/dot ^ It would be nice to use the xml type, but we always have DOCTYPE. I understand that PostgreSQL won't validate against the specified DOCTYPE, but it shouldn't error out on it, either. -Kevin
