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