1CREATE SCHEMA testxmlschema; 2CREATE TABLE testxmlschema.test1 (a int, b text); 3INSERT INTO testxmlschema.test1 VALUES (1, 'one'), (2, 'two'), (-1, null); 4CREATE DOMAIN testxmldomain AS varchar; 5CREATE TABLE testxmlschema.test2 (z int, y varchar(500), x char(6), w numeric(9,2), v smallint, u bigint, t real, s time, r timestamp, q date, p xml, o testxmldomain, n bool, m bytea, aaa text); 6ALTER TABLE testxmlschema.test2 DROP COLUMN aaa; 7INSERT INTO testxmlschema.test2 VALUES (55, 'abc', 'def', 98.6, 2, 999, 0, '21:07', '2009-06-08 21:07:30', '2009-06-08', NULL, 'ABC', true, 'XYZ'); 8SELECT table_to_xml('testxmlschema.test1', false, false, ''); 9ERROR: unsupported XML feature 10DETAIL: This functionality requires the server to be built with libxml support. 11HINT: You need to rebuild PostgreSQL using --with-libxml. 12SELECT table_to_xml('testxmlschema.test1', true, false, 'foo'); 13ERROR: unsupported XML feature 14DETAIL: This functionality requires the server to be built with libxml support. 15HINT: You need to rebuild PostgreSQL using --with-libxml. 16SELECT table_to_xml('testxmlschema.test1', false, true, ''); 17ERROR: unsupported XML feature 18DETAIL: This functionality requires the server to be built with libxml support. 19HINT: You need to rebuild PostgreSQL using --with-libxml. 20SELECT table_to_xml('testxmlschema.test1', true, true, ''); 21ERROR: unsupported XML feature 22DETAIL: This functionality requires the server to be built with libxml support. 23HINT: You need to rebuild PostgreSQL using --with-libxml. 24SELECT table_to_xml('testxmlschema.test2', false, false, ''); 25ERROR: unsupported XML feature 26DETAIL: This functionality requires the server to be built with libxml support. 27HINT: You need to rebuild PostgreSQL using --with-libxml. 28SELECT table_to_xmlschema('testxmlschema.test1', false, false, ''); 29ERROR: unsupported XML feature 30DETAIL: This functionality requires the server to be built with libxml support. 31HINT: You need to rebuild PostgreSQL using --with-libxml. 32SELECT table_to_xmlschema('testxmlschema.test1', true, false, ''); 33ERROR: unsupported XML feature 34DETAIL: This functionality requires the server to be built with libxml support. 35HINT: You need to rebuild PostgreSQL using --with-libxml. 36SELECT table_to_xmlschema('testxmlschema.test1', false, true, 'foo'); 37ERROR: unsupported XML feature 38DETAIL: This functionality requires the server to be built with libxml support. 39HINT: You need to rebuild PostgreSQL using --with-libxml. 40SELECT table_to_xmlschema('testxmlschema.test1', true, true, ''); 41ERROR: unsupported XML feature 42DETAIL: This functionality requires the server to be built with libxml support. 43HINT: You need to rebuild PostgreSQL using --with-libxml. 44SELECT table_to_xmlschema('testxmlschema.test2', false, false, ''); 45ERROR: unsupported XML feature 46DETAIL: This functionality requires the server to be built with libxml support. 47HINT: You need to rebuild PostgreSQL using --with-libxml. 48SELECT table_to_xml_and_xmlschema('testxmlschema.test1', false, false, ''); 49ERROR: unsupported XML feature 50DETAIL: This functionality requires the server to be built with libxml support. 51HINT: You need to rebuild PostgreSQL using --with-libxml. 52SELECT table_to_xml_and_xmlschema('testxmlschema.test1', true, false, ''); 53ERROR: unsupported XML feature 54DETAIL: This functionality requires the server to be built with libxml support. 55HINT: You need to rebuild PostgreSQL using --with-libxml. 56SELECT table_to_xml_and_xmlschema('testxmlschema.test1', false, true, ''); 57ERROR: unsupported XML feature 58DETAIL: This functionality requires the server to be built with libxml support. 59HINT: You need to rebuild PostgreSQL using --with-libxml. 60SELECT table_to_xml_and_xmlschema('testxmlschema.test1', true, true, 'foo'); 61ERROR: unsupported XML feature 62DETAIL: This functionality requires the server to be built with libxml support. 63HINT: You need to rebuild PostgreSQL using --with-libxml. 64SELECT query_to_xml('SELECT * FROM testxmlschema.test1', false, false, ''); 65ERROR: unsupported XML feature 66DETAIL: This functionality requires the server to be built with libxml support. 67HINT: You need to rebuild PostgreSQL using --with-libxml. 68SELECT query_to_xmlschema('SELECT * FROM testxmlschema.test1', false, false, ''); 69ERROR: unsupported XML feature 70DETAIL: This functionality requires the server to be built with libxml support. 71HINT: You need to rebuild PostgreSQL using --with-libxml. 72SELECT query_to_xml_and_xmlschema('SELECT * FROM testxmlschema.test1', true, true, ''); 73ERROR: unsupported XML feature 74DETAIL: This functionality requires the server to be built with libxml support. 75HINT: You need to rebuild PostgreSQL using --with-libxml. 76DECLARE xc CURSOR WITH HOLD FOR SELECT * FROM testxmlschema.test1 ORDER BY 1, 2; 77SELECT cursor_to_xml('xc'::refcursor, 5, false, true, ''); 78ERROR: unsupported XML feature 79DETAIL: This functionality requires the server to be built with libxml support. 80HINT: You need to rebuild PostgreSQL using --with-libxml. 81SELECT cursor_to_xmlschema('xc'::refcursor, false, true, ''); 82ERROR: unsupported XML feature 83DETAIL: This functionality requires the server to be built with libxml support. 84HINT: You need to rebuild PostgreSQL using --with-libxml. 85MOVE BACKWARD ALL IN xc; 86SELECT cursor_to_xml('xc'::refcursor, 5, true, false, ''); 87ERROR: unsupported XML feature 88DETAIL: This functionality requires the server to be built with libxml support. 89HINT: You need to rebuild PostgreSQL using --with-libxml. 90SELECT cursor_to_xmlschema('xc'::refcursor, true, false, ''); 91ERROR: unsupported XML feature 92DETAIL: This functionality requires the server to be built with libxml support. 93HINT: You need to rebuild PostgreSQL using --with-libxml. 94SELECT schema_to_xml('testxmlschema', false, true, ''); 95ERROR: unsupported XML feature 96DETAIL: This functionality requires the server to be built with libxml support. 97HINT: You need to rebuild PostgreSQL using --with-libxml. 98SELECT schema_to_xml('testxmlschema', true, false, ''); 99ERROR: unsupported XML feature 100DETAIL: This functionality requires the server to be built with libxml support. 101HINT: You need to rebuild PostgreSQL using --with-libxml. 102SELECT schema_to_xmlschema('testxmlschema', false, true, ''); 103ERROR: unsupported XML feature 104DETAIL: This functionality requires the server to be built with libxml support. 105HINT: You need to rebuild PostgreSQL using --with-libxml. 106SELECT schema_to_xmlschema('testxmlschema', true, false, ''); 107ERROR: unsupported XML feature 108DETAIL: This functionality requires the server to be built with libxml support. 109HINT: You need to rebuild PostgreSQL using --with-libxml. 110SELECT schema_to_xml_and_xmlschema('testxmlschema', true, true, 'foo'); 111ERROR: unsupported XML feature 112DETAIL: This functionality requires the server to be built with libxml support. 113HINT: You need to rebuild PostgreSQL using --with-libxml. 114-- test that domains are transformed like their base types 115CREATE DOMAIN testboolxmldomain AS bool; 116CREATE DOMAIN testdatexmldomain AS date; 117CREATE TABLE testxmlschema.test3 118 AS SELECT true c1, 119 true::testboolxmldomain c2, 120 '2013-02-21'::date c3, 121 '2013-02-21'::testdatexmldomain c4; 122SELECT xmlforest(c1, c2, c3, c4) FROM testxmlschema.test3; 123ERROR: unsupported XML feature 124DETAIL: This functionality requires the server to be built with libxml support. 125HINT: You need to rebuild PostgreSQL using --with-libxml. 126SELECT table_to_xml('testxmlschema.test3', true, true, ''); 127ERROR: unsupported XML feature 128DETAIL: This functionality requires the server to be built with libxml support. 129HINT: You need to rebuild PostgreSQL using --with-libxml. 130