|
Hi all,
I’m migrating a database from 9.2.4 to 9.3.0 and encountering an issue with an XML field failing to restore.
I’m using pg_dump 9.3.0 as follows (with 9.2.4 on 5433 and 9.3.0 on 5432). I have verified my paths, it’s definitely using the 9.3.0 binaries. Both source and target are using UTF8 encoding.
pg_dump -p 5433 content_xml_test | psql content_xml_test -p 5432 –v _ON_ERROR_STOP_=1
<snipped>
CREATE SEQUENCE
Time: 0.870 ms
ALTER TABLE
Time: 0.199 ms
ALTER SEQUENCE
Time: 0.380 ms
ALTER TABLE
Time: 0.931 ms
Time: 10.883 ms
ERROR: invalid XML content
DETAIL: line 1: StartTag: invalid element name
<!DOCTYPE Catalog SYSTEM "../../../../../../../../test.dtd">
^
CONTEXT: COPY xml_test, line 13, column document: "<!DOCTYPE Catalog SYSTEM "../../../../../../../../test.dtd">
However, if I do the following:
ALTER DATABASE content_xml_test SET XMLOPTION TO DOCUMENT;
ERROR: invalid XML document
DETAIL: line 1: Start tag expected, '<' not found
1046710
^
CONTEXT: COPY test_lookup, line 1, column external_ref: "{1046710,1046711}"
Time: 14.828 ms
This is even more interesting, since the external_ref column is a totally different field, and a different type. I suspect the failure is still valid, but it’s reporting the wrong field name as being the culprit.
I suspect this might be resolved in a newer point release of 9.3, however I don’t have the luxury on this particular host right now.
Any suggestions how I might convince 9.3.0 to accept the dump from 9.2.4?
Cheers,
Tim
Tim Kane Senior Development Engineer Lead t: +44 20 7092 8700 m: blinkbox music - the easiest way to listen to the music you love, for free www.blinkboxmusic.com |
