1
CREATE SCHEMA testxmlschema;
2
CREATE TABLE testxmlschema.test1 (a int, b text);
3
INSERT INTO testxmlschema.test1 VALUES (1, 'one'), (2, 'two'), (-1, null);
4
CREATE DOMAIN testxmldomain AS varchar;
5
CREATE 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);
6
ALTER TABLE testxmlschema.test2 DROP COLUMN aaa;
7
INSERT 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');
8
SELECT table_to_xml('testxmlschema.test1', false, false, '');
9
ERROR: unsupported XML feature
10
DETAIL: This functionality requires the server to be built with libxml support.
11
HINT: You need to rebuild PostgreSQL using --with-libxml.
12
SELECT table_to_xml('testxmlschema.test1', true, false, 'foo');
13
ERROR: unsupported XML feature
14
DETAIL: This functionality requires the server to be built with libxml support.
15
HINT: You need to rebuild PostgreSQL using --with-libxml.
16
SELECT table_to_xml('testxmlschema.test1', false, true, '');
17
ERROR: unsupported XML feature
18
DETAIL: This functionality requires the server to be built with libxml support.
19
HINT: You need to rebuild PostgreSQL using --with-libxml.
20
SELECT table_to_xml('testxmlschema.test1', true, true, '');
21
ERROR: unsupported XML feature
22
DETAIL: This functionality requires the server to be built with libxml support.
23
HINT: You need to rebuild PostgreSQL using --with-libxml.
24
SELECT table_to_xml('testxmlschema.test2', false, false, '');
25
ERROR: unsupported XML feature
26
DETAIL: This functionality requires the server to be built with libxml support.
27
HINT: You need to rebuild PostgreSQL using --with-libxml.
28
SELECT table_to_xmlschema('testxmlschema.test1', false, false, '');
29
ERROR: unsupported XML feature
30
DETAIL: This functionality requires the server to be built with libxml support.
31
HINT: You need to rebuild PostgreSQL using --with-libxml.
32
SELECT table_to_xmlschema('testxmlschema.test1', true, false, '');
33
ERROR: unsupported XML feature
34
DETAIL: This functionality requires the server to be built with libxml support.
35
HINT: You need to rebuild PostgreSQL using --with-libxml.
36
SELECT table_to_xmlschema('testxmlschema.test1', false, true, 'foo');
37
ERROR: unsupported XML feature
38
DETAIL: This functionality requires the server to be built with libxml support.
39
HINT: You need to rebuild PostgreSQL using --with-libxml.
40
SELECT table_to_xmlschema('testxmlschema.test1', true, true, '');
41
ERROR: unsupported XML feature
42
DETAIL: This functionality requires the server to be built with libxml support.
43
HINT: You need to rebuild PostgreSQL using --with-libxml.
44
SELECT table_to_xmlschema('testxmlschema.test2', false, false, '');
45
ERROR: unsupported XML feature
46
DETAIL: This functionality requires the server to be built with libxml support.
47
HINT: You need to rebuild PostgreSQL using --with-libxml.
48
SELECT table_to_xml_and_xmlschema('testxmlschema.test1', false, false, '');
49
ERROR: unsupported XML feature
50
DETAIL: This functionality requires the server to be built with libxml support.
51
HINT: You need to rebuild PostgreSQL using --with-libxml.
52
SELECT table_to_xml_and_xmlschema('testxmlschema.test1', true, false, '');
53
ERROR: unsupported XML feature
54
DETAIL: This functionality requires the server to be built with libxml support.
55
HINT: You need to rebuild PostgreSQL using --with-libxml.
56
SELECT table_to_xml_and_xmlschema('testxmlschema.test1', false, true, '');
57
ERROR: unsupported XML feature
58
DETAIL: This functionality requires the server to be built with libxml support.
59
HINT: You need to rebuild PostgreSQL using --with-libxml.
60
SELECT table_to_xml_and_xmlschema('testxmlschema.test1', true, true, 'foo');
61
ERROR: unsupported XML feature
62
DETAIL: This functionality requires the server to be built with libxml support.
63
HINT: You need to rebuild PostgreSQL using --with-libxml.
64
SELECT query_to_xml('SELECT * FROM testxmlschema.test1', false, false, '');
65
ERROR: unsupported XML feature
66
DETAIL: This functionality requires the server to be built with libxml support.
67
HINT: You need to rebuild PostgreSQL using --with-libxml.
68
SELECT query_to_xmlschema('SELECT * FROM testxmlschema.test1', false, false, '');
69
ERROR: unsupported XML feature
70
DETAIL: This functionality requires the server to be built with libxml support.
71
HINT: You need to rebuild PostgreSQL using --with-libxml.
72
SELECT query_to_xml_and_xmlschema('SELECT * FROM testxmlschema.test1', true, true, '');
73
ERROR: unsupported XML feature
74
DETAIL: This functionality requires the server to be built with libxml support.
75
HINT: You need to rebuild PostgreSQL using --with-libxml.
76
DECLARE xc CURSOR WITH HOLD FOR SELECT * FROM testxmlschema.test1 ORDER BY 1, 2;
77
SELECT cursor_to_xml('xc'::refcursor, 5, false, true, '');
78
ERROR: unsupported XML feature
79
DETAIL: This functionality requires the server to be built with libxml support.
80
HINT: You need to rebuild PostgreSQL using --with-libxml.
82
SELECT cursor_to_xml('xc'::refcursor, 5, true, false, '');
83
ERROR: unsupported XML feature
84
DETAIL: This functionality requires the server to be built with libxml support.
85
HINT: You need to rebuild PostgreSQL using --with-libxml.
86
SELECT cursor_to_xmlschema('xc'::refcursor, true, false, '');
87
ERROR: unsupported XML feature
88
DETAIL: This functionality requires the server to be built with libxml support.
89
HINT: You need to rebuild PostgreSQL using --with-libxml.
90
SELECT schema_to_xml('testxmlschema', false, true, '');
91
ERROR: unsupported XML feature
92
DETAIL: This functionality requires the server to be built with libxml support.
93
HINT: You need to rebuild PostgreSQL using --with-libxml.
94
SELECT schema_to_xml('testxmlschema', true, false, '');
95
ERROR: unsupported XML feature
96
DETAIL: This functionality requires the server to be built with libxml support.
97
HINT: You need to rebuild PostgreSQL using --with-libxml.
98
SELECT schema_to_xmlschema('testxmlschema', false, true, '');
99
ERROR: unsupported XML feature
100
DETAIL: This functionality requires the server to be built with libxml support.
101
HINT: You need to rebuild PostgreSQL using --with-libxml.
102
SELECT schema_to_xmlschema('testxmlschema', true, false, '');
103
ERROR: unsupported XML feature
104
DETAIL: This functionality requires the server to be built with libxml support.
105
HINT: You need to rebuild PostgreSQL using --with-libxml.
106
SELECT schema_to_xml_and_xmlschema('testxmlschema', true, true, 'foo');
107
ERROR: unsupported XML feature
108
DETAIL: This functionality requires the server to be built with libxml support.
109
HINT: You need to rebuild PostgreSQL using --with-libxml.