Forum OpenACS Q&A: Re: new to acs, need help with xowiki toc

Collapse
Posted by Nima Mazloumi on
the correct call must look like this:
exec /pathto/psql < /usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql
Collapse
Posted by Matthew Smith on
I think I got it to run by using this cvommand:
exec psql &gt; /usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql

However, this was the generated output:
------------------------------------------------------------
ERROR:
SELECT ''::ltree;
SELECT '1'::ltree;
SELECT '1.2'::ltree;
SELECT '1.2._3'::ltree;
SELECT ltree2text('1.2.3.34.sdf');
SELECT text2ltree('1.2.3.34.sdf');
SELECT subltree('Top.Child1.Child2',1,2);
SELECT subpath('Top.Child1.Child2',1,2);
SELECT subpath('Top.Child1.Child2',-1,1);
SELECT subpath('Top.Child1.Child2',0,-2);
SELECT subpath('Top.Child1.Child2',0,-1);
SELECT subpath('Top.Child1.Child2',0,0);
SELECT subpath('Top.Child1.Child2',1,0);
SELECT subpath('Top.Child1.Child2',0);
SELECT subpath('Top.Child1.Child2',1);
SELECT index('1.2.3.4.5.6','1.2');
SELECT index('a.1.2.3.4.5.6','1.2');
SELECT index('a.1.2.3.4.5.6','1.2.3');
SELECT index('a.1.2.3.4.5.6','1.2.3.j');
SELECT index('a.1.2.3.4.5.6','1.2.3.j.4.5.5.5.5.5.5');
SELECT index('a.1.2.3.4.5.6','1.2.3');
SELECT index('a.1.2.3.4.5.6','6');
SELECT index('a.1.2.3.4.5.6','6.1');
SELECT index('a.1.2.3.4.5.6','5.6');
SELECT index('0.1.2.3.5.4.5.6','5.6');
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',3);
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',6);
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',7);
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-7);
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-4);
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-3);
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-2);
SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-20000);
SELECT 'Top.Child1.Child2'::ltree || 'Child3'::text;
SELECT 'Top.Child1.Child2'::ltree || 'Child3'::ltree;
SELECT 'Top_0'::ltree || 'Top.Child1.Child2'::ltree;
SELECT 'Top.Child1.Child2'::ltree || ''::ltree;
SELECT ''::ltree || 'Top.Child1.Child2'::ltree;
SELECT lca('{la.2.3,1.2.3.4.5.6,""}') IS NULL;
SELECT lca('{la.2.3,1.2.3.4.5.6}') IS NULL;
SELECT lca('{1.la.2.3,1.2.3.4.5.6}');
SELECT lca('{1.2.3,1.2.3.4.5.6}');
SELECT lca('1.la.2.3','1.2.3.4.5.6');
SELECT lca('1.2.3','1.2.3.4.5.6');
SELECT lca('1.2.2.3','1.2.3.4.5.6');
SELECT lca('1.2.2.3','1.2.3.4.5.6','');
SELECT lca('1.2.2.3','1.2.3.4.5.6','2');
SELECT lca('1.2.2.3','1.2.3.4.5.6','1');
SELECT '1'::lquery;
SELECT '4|3|2'::lquery;
SELECT '1.2'::lquery;
SELECT '1.4|3|2'::lquery;
SELECT '1.0'::lquery;
SELECT '4|3|2.0'::lquery;
SELECT '1.2.0'::lquery;
SELECT '1.4|3|2.0'::lquery;
SELECT '1.*'::lquery;
SELECT '4|3|2.*'::lquery;
SELECT '1.2.*'::lquery;
SELECT '1.4|3|2.*'::lquery;
SELECT '*.1.*'::lquery;
SELECT '*.4|3|2.*'::lquery;
SELECT '*.1.2.*'::lquery;
SELECT '*.1.4|3|2.*'::lquery;
SELECT '1.*.4|3|2'::lquery;
SELECT '1.*.4|3|2.0'::lquery;
SELECT '1.*.4|3|2.*{1,4}'::lquery;
SELECT '1.*.4|3|2.*{,4}'::lquery;
SELECT '1.*.4|3|2.*{1,}'::lquery;
SELECT '1.*.4|3|2.*{1}'::lquery;
SELECT 'mailto:qwerty%@*.tu';::lquery;
SELECT nlevel('1.2.3.4');
SELECT '1.2'::ltree < '2.2'::ltree;
SELECT '1.2'::ltree <= '2.2'::ltree;
SELECT '2.2'::ltree = '2.2'::ltree;
SELECT '3.2'::ltree >= '2.2'::ltree;
SELECT '3.2'::ltree > '2.2'::ltree;
SELECT '1.2.3'::ltree @> '1.2.3.4'::ltree;
SELECT '1.2.3.4'::ltree @> '1.2.3.4'::ltree;
SELECT '1.2.3.4.5'::ltree @> '1.2.3.4'::ltree;
SELECT '1.3.3'::ltree @> '1.2.3.4'::ltree;
SELECT 'a.b.c.d.e'::ltree ~ 'a.b.c.d.e';
SELECT 'a.b.c.d.e'::ltree ~ 'A.b.c.d.e';
SELECT 'a.b.c.d.e'::ltree ~ 'A@.b.c.d.e';
SELECT 'aa.b.c.d.e'::ltree ~ 'A@.b.c.d.e';
SELECT 'aa.b.c.d.e'::ltree ~ 'A*.b.c.d.e';
SELECT 'aa.b.c.d.e'::ltree ~ 'A*@.b.c.d.e';
SELECT 'aa.b.c.d.e'::ltree ~ 'mailto:A*@|g.b.c.d.e';;
SELECT 'g.b.c.d.e'::ltree ~ 'mailto:A*@|g.b.c.d.e';;
SELECT 'a.b.c.d.e'::ltree ~ 'a.b.c.d.e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*.e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{3}.e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2}.e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{4}.e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{,4}.e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,}.e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,4}.e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,3}.e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,3}';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,4}';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,5}';
SELECT 'a.b.c.d.e'::ltree ~ '*{2,3}.e';
SELECT 'a.b.c.d.e'::ltree ~ '*{2,4}.e';
SELECT 'a.b.c.d.e'::ltree ~ '*{2,5}.e';
SELECT 'a.b.c.d.e'::ltree ~ '*.e';
SELECT 'a.b.c.d.e'::ltree ~ '*.e.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.d.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.d.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.!d.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.!d';
SELECT 'a.b.c.d.e'::ltree ~ '!d.*';
SELECT 'a.b.c.d.e'::ltree ~ '!a.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.!e';
SELECT 'a.b.c.d.e'::ltree ~ '*.!e.*';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!d';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!d.*';
SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!f.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.!f.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.!d.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.a.!d.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.a.!d';
SELECT 'a.b.c.d.e'::ltree ~ 'a.!d.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.!d.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.c.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.c.*';
SELECT 'a.b.c.d.e'::ltree ~ '!b.*.c.*';
SELECT 'a.b.c.d.e'::ltree ~ '!b.b.*';
SELECT 'a.b.c.d.e'::ltree ~ '!b.*.e';
SELECT 'a.b.c.d.e'::ltree ~ '!b.!c.*.e';
SELECT 'a.b.c.d.e'::ltree ~ '!b.*.!c.*.e';
SELECT 'a.b.c.d.e'::ltree ~ '*{2}.!b.*.!c.*.e';
SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*.!c.*.e';
SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*{1}.!c.*.e';
SELECT 'a.b.c.d.e'::ltree ~ 'a.!b.*{1}.!c.*.e';
SELECT 'a.b.c.d.e'::ltree ~ '!b.*{1}.!c.*.e';
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*{1}.!c.*.e';
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.!c.*.e';
SELECT 'a.b.c.d.e'::ltree ~ '!b.!c.*';
SELECT 'a.b.c.d.e'::ltree ~ '!b.*.!c.*';
SELECT 'a.b.c.d.e'::ltree ~ '*{2}.!b.*.!c.*';
SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*.!c.*';
SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*{1}.!c.*';
SELECT 'a.b.c.d.e'::ltree ~ 'a.!b.*{1}.!c.*';
SELECT 'a.b.c.d.e'::ltree ~ '!b.*{1}.!c.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*{1}.!c.*';
SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.!c.*';
SELECT 'QWER_TY'::ltree ~ 'q%@*';
SELECT 'QWER_TY'::ltree ~ 'Q_t%@*';
SELECT 'QWER_GY'::ltree ~ 'q_t%@*';
--ltxtquery
SELECT '!tree & aWdf@*'::ltxtquery;
SELECT 'tree & aw_qw%*'::ltxtquery;
SELECT 'ltree.awdfg'::ltree @ '!tree & aWdf@*'::ltxtquery;
SELECT 'tree.awdfg'::ltree @ '!tree & aWdf@*'::ltxtquery;
SELECT 'tree.awdfg'::ltree @ '!tree | aWdf@*'::ltxtquery;
SELECT 'tree.awdfg'::ltree @ 'tree | aWdf@*'::ltxtquery;
SELECT 'tree.awdfg'::ltree @ 'tree & aWdf@*'::ltxtquery;
SELECT 'tree.awdfg'::ltree @ 'tree & aWdf@'::ltxtquery;
SELECT 'tree.awdfg'::ltree @ 'tree & aWdf*'::ltxtquery;
SELECT 'tree.awdfg'::ltree @ 'tree & aWdf'::ltxtquery;
SELECT 'tree.awdfg'::ltree @ 'tree & awdf*'::ltxtquery;
SELECT 'tree.awdfg'::ltree @ 'tree & aWdfg@'::ltxtquery;
SELECT 'tree.awdfg_qwerty'::ltree @ 'tree & aw_qw%*'::ltxtquery;
SELECT 'tree.awdfg_qwerty'::ltree @ 'tree & aw_rw%*'::ltxtquery;
--arrays
SELECT '{1.2.3}'::ltree[] @> '1.2.3.4';
SELECT '{1.2.3.4}'::ltree[] @> '1.2.3.4';
SELECT '{1.2.3.4.5}'::ltree[] @> '1.2.3.4';
SELECT '{1.3.3}'::ltree[] @> '1.2.3.4';
SELECT '{5.67.8, 1.2.3}'::ltree[] @> '1.2.3.4';
SELECT '{5.67.8, 1.2.3.4}'::ltree[] @> '1.2.3.4';
SELECT '{5.67.8, 1.2.3.4.5}'::ltree[] @> '1.2.3.4';
SELECT '{5.67.8, 1.3.3}'::ltree[] @> '1.2.3.4';
SELECT '{1.2.3, 7.12.asd}'::ltree[] @> '1.2.3.4';
SELECT '{1.2.3.4, 7.12.asd}'::ltree[] @> '1.2.3.4';
SELECT '{1.2.3.4.5, 7.12.asd}'::ltree[] @> '1.2.3.4';
SELECT '{1.3.3, 7.12.asd}'::ltree[] @> '1.2.3.4';
SELECT '{ltree.asd, tree.awdfg}'::ltree[] @ 'tree & aWdfg@'::ltxtquery;
SELECT '{j.k.l.m, g.b.c.d.e}'::ltree[] ~ 'mailto:A*@|g.b.c.d.e';;
SELECT 'a.b.c.d.e'::ltree ? '{A.b.c.d.e}';
SELECT 'a.b.c.d.e'::ltree ? '{a.b.c.d.e}';
SELECT 'a.b.c.d.e'::ltree ? '{A.b.c.d.e, a.*}';
SELECT '{a.b.c.d.e,B.df}'::ltree[] ? '{A.b.c.d.e}';
SELECT '{a.b.c.d.e,B.df}'::ltree[] ? '{A.b.c.d.e,*.df}';
--exractors
SELECT ('{3456,1.2.3.34}'::ltree[] ?@> '1.2.3.4') is null;
SELECT '{3456,1.2.3}'::ltree[] ?@> '1.2.3.4';
SELECT '{3456,1.2.3.4}'::ltree[] ?<@ '1.2.3';
SELECT ('{3456,1.2.3.4}'::ltree[] ?<@ '1.2.5') is null;
SELECT '{ltree.asd, tree.awdfg}'::ltree[] ?@ 'tree & aWdfg@'::ltxtquery;
SELECT '{j.k.l.m, g.b.c.d.e}'::ltree[] ?~ 'mailto:A*@|g.b.c.d.e';;
CREATE TABLE ltreetest (t ltree);
\copy ltreetest FROM 'data/ltree.data'
SELECT * FROM ltreetest WHERE t < '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t <= '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t = '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t >= '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t > '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t @> '1.1.1' order by t asc;
SELECT * FROM ltreetest WHERE t <@ '1.1.1' order by t asc;
SELECT * FROM ltreetest WHERE t @ '23 & 1' order by t asc;
SELECT * FROM ltreetest WHERE t ~ '1.1.1.*' order by t asc;
SELECT * FROM ltreetest WHERE t ~ '*.1' order by t asc;
SELECT * FROM ltreetest WHERE t ~ '23.*{1}.1' order by t asc;
SELECT * FROM ltreetest WHERE t ~ '23.*.1' order by t asc;
SELECT * FROM ltreetest WHERE t ~ '23.*.2' order by t asc;
SELECT * FROM ltreetest WHERE t ? '{23.*.1,23.*.2}' order by t asc;
create unique index tstidx on ltreetest (t);
set enable_seqscan=off;
SET
SELECT * FROM ltreetest WHERE t < '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t <= '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t = '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t >= '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t > '12.3' order by t asc;
drop index tstidx;
create index tstidx on ltreetest using gist (t);
set enable_seqscan=off;
SET
SELECT * FROM ltreetest WHERE t < '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t <= '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t = '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t >= '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t > '12.3' order by t asc;
SELECT * FROM ltreetest WHERE t @> '1.1.1' order by t asc;
SELECT * FROM ltreetest WHERE t <@ '1.1.1' order by t asc;
SELECT * FROM ltreetest WHERE t @ '23 & 1' order by t asc;
SELECT * FROM ltreetest WHERE t ~ '1.1.1.*' order by t asc;
SELECT * FROM ltreetest WHERE t ~ '*.1' order by t asc;
SELECT * FROM ltreetest WHERE t ~ '23.*{1}.1' order by t asc;
SELECT * FROM ltreetest WHERE t ~ '23.*.1' order by t asc;
SELECT * FROM ltreetest WHERE t ~ '23.*.2' order by t asc;
SELECT * FROM ltreetest WHERE t ? '{23.*.1,23.*.2}' order by t asc;
create table _ltreetest (t ltree[]);
\copy _ltreetest FROM 'data/_ltree.data'
SELECT count(*) FROM _ltreetest WHERE t @> '1.1.1' ;
SELECT count(*) FROM _ltreetest WHERE t <@ '1.1.1' ;
SELECT count(*) FROM _ltreetest WHERE t @ '23 & 1' ;
SELECT count(*) FROM _ltreetest WHERE t ~ '1.1.1.*' ;
SELECT count(*) FROM _ltreetest WHERE t ~ '*.1' ;
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*{1}.1' ;
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.1' ;
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.2' ;
SELECT count(*) FROM _ltreetest WHERE t ? '{23.*.1,23.*.2}' ;
create index _tstidx on _ltreetest using gist (t);
set enable_seqscan=off;
SET
SELECT count(*) FROM _ltreetest WHERE t @> '1.1.1' ;
SELECT count(*) FROM _ltreetest WHERE t <@ '1.1.1' ;
SELECT count(*) FROM _ltreetest WHERE t @ '23 & 1' ;
SELECT count(*) FROM _ltreetest WHERE t ~ '1.1.1.*' ;
SELECT count(*) FROM _ltreetest WHERE t ~ '*.1' ;
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*{1}.1' ;
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.1' ;
SELECT count(*) FROM _ltreetest WHERE t ~ '23.*.2' ;
SELECT count(*) FROM _ltreetest WHERE t ? '{23.*.1,23.*.2}' ;
ltree.sql: No such file or directory
ERROR: type "ltree" does not exist
LINE 1: SELECT ''::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '1'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '1.2'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '1.2._3'::ltree;
^
ERROR: function ltree2text("unknown") does not exist
LINE 1: SELECT ltree2text('1.2.3.34.sdf');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function text2ltree("unknown") does not exist
LINE 1: SELECT text2ltree('1.2.3.34.sdf');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function subltree("unknown", integer, integer) does not exist
LINE 1: SELECT subltree('Top.Child1.Child2',1,2);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function subpath("unknown", integer, integer) does not exist
LINE 1: SELECT subpath('Top.Child1.Child2',1,2);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function subpath("unknown", integer, integer) does not exist
LINE 1: SELECT subpath('Top.Child1.Child2',-1,1);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function subpath("unknown", integer, integer) does not exist
LINE 1: SELECT subpath('Top.Child1.Child2',0,-2);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function subpath("unknown", integer, integer) does not exist
LINE 1: SELECT subpath('Top.Child1.Child2',0,-1);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function subpath("unknown", integer, integer) does not exist
LINE 1: SELECT subpath('Top.Child1.Child2',0,0);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function subpath("unknown", integer, integer) does not exist
LINE 1: SELECT subpath('Top.Child1.Child2',1,0);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function subpath("unknown", integer) does not exist
LINE 1: SELECT subpath('Top.Child1.Child2',0);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function subpath("unknown", integer) does not exist
LINE 1: SELECT subpath('Top.Child1.Child2',1);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown") does not exist
LINE 1: SELECT index('1.2.3.4.5.6','1.2');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown") does not exist
LINE 1: SELECT index('a.1.2.3.4.5.6','1.2');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown") does not exist
LINE 1: SELECT index('a.1.2.3.4.5.6','1.2.3');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown") does not exist
LINE 1: SELECT index('a.1.2.3.4.5.6','1.2.3.j');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown") does not exist
LINE 1: SELECT index('a.1.2.3.4.5.6','1.2.3.j.4.5.5.5.5.5.5');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown") does not exist
LINE 1: SELECT index('a.1.2.3.4.5.6','1.2.3');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown") does not exist
LINE 1: SELECT index('a.1.2.3.4.5.6','6');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown") does not exist
LINE 1: SELECT index('a.1.2.3.4.5.6','6.1');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown") does not exist
LINE 1: SELECT index('a.1.2.3.4.5.6','5.6');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown") does not exist
LINE 1: SELECT index('0.1.2.3.5.4.5.6','5.6');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown", integer) does not exist
LINE 1: SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',3);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown", integer) does not exist
LINE 1: SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',6);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown", integer) does not exist
LINE 1: SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',7);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown", integer) does not exist
LINE 1: SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-7);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown", integer) does not exist
LINE 1: SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-4);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown", integer) does not exist
LINE 1: SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-3);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown", integer) does not exist
LINE 1: SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-2);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function index("unknown", "unknown", integer) does not exist
LINE 1: SELECT index('0.1.2.3.5.4.5.6.8.5.6.8','5.6',-20000);
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: type "ltree" does not exist
LINE 1: SELECT 'Top.Child1.Child2'::ltree || 'Child3'::text;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'Top.Child1.Child2'::ltree || 'Child3'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'Top_0'::ltree || 'Top.Child1.Child2'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'Top.Child1.Child2'::ltree || ''::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT ''::ltree || 'Top.Child1.Child2'::ltree;
^
ERROR: function lca("unknown") does not exist
LINE 1: SELECT lca('{la.2.3,1.2.3.4.5.6,""}') IS NULL;
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function lca("unknown") does not exist
LINE 1: SELECT lca('{la.2.3,1.2.3.4.5.6}') IS NULL;
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function lca("unknown") does not exist
LINE 1: SELECT lca('{1.la.2.3,1.2.3.4.5.6}');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function lca("unknown") does not exist
LINE 1: SELECT lca('{1.2.3,1.2.3.4.5.6}');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function lca("unknown", "unknown") does not exist
LINE 1: SELECT lca('1.la.2.3','1.2.3.4.5.6');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function lca("unknown", "unknown") does not exist
LINE 1: SELECT lca('1.2.3','1.2.3.4.5.6');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function lca("unknown", "unknown") does not exist
LINE 1: SELECT lca('1.2.2.3','1.2.3.4.5.6');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function lca("unknown", "unknown", "unknown") does not exist
LINE 1: SELECT lca('1.2.2.3','1.2.3.4.5.6','');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function lca("unknown", "unknown", "unknown") does not exist
LINE 1: SELECT lca('1.2.2.3','1.2.3.4.5.6','2');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: function lca("unknown", "unknown", "unknown") does not exist
LINE 1: SELECT lca('1.2.2.3','1.2.3.4.5.6','1');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: type "lquery" does not exist
LINE 1: SELECT '1'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '4|3|2'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.2'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.4|3|2'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.0'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '4|3|2.0'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.2.0'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.4|3|2.0'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.*'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '4|3|2.*'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.2.*'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.4|3|2.*'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '*.1.*'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '*.4|3|2.*'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '*.1.2.*'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '*.1.4|3|2.*'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.*.4|3|2'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.*.4|3|2.0'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.*.4|3|2.*{1,4}'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.*.4|3|2.*{,4}'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.*.4|3|2.*{1,}'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT '1.*.4|3|2.*{1}'::lquery;
^
ERROR: type "lquery" does not exist
LINE 1: SELECT 'mailto:qwerty%@*.tu';::lquery;
^
ERROR: function nlevel("unknown") does not exist
LINE 1: SELECT nlevel('1.2.3.4');
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
ERROR: type "ltree" does not exist
LINE 1: SELECT '1.2'::ltree < '2.2'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '1.2'::ltree <= '2.2'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '2.2'::ltree = '2.2'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '3.2'::ltree >= '2.2'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '3.2'::ltree > '2.2'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '1.2.3'::ltree @> '1.2.3.4'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '1.2.3.4'::ltree @> '1.2.3.4'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '1.2.3.4.5'::ltree @> '1.2.3.4'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT '1.3.3'::ltree @> '1.2.3.4'::ltree;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.b.c.d.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'A.b.c.d.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'A@.b.c.d.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'aa.b.c.d.e'::ltree ~ 'A@.b.c.d.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'aa.b.c.d.e'::ltree ~ 'A*.b.c.d.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'aa.b.c.d.e'::ltree ~ 'A*@.b.c.d.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'aa.b.c.d.e'::ltree ~ 'mailto:A*@|g.b.c.d.e';;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'g.b.c.d.e'::ltree ~ 'mailto:A*@|g.b.c.d.e';;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.b.c.d.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*{3}.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2}.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*{4}.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*{,4}.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,}.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,4}.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,3}.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,3}';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,4}';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*{2,5}';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*{2,3}.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*{2,4}.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*{2,5}.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.e.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.d.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.d.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!d.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!d';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!d.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!a.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!e.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!d';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!d.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.*.!f.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.!f.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.!d.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.a.!d.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.a.!d';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.!d.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.a.*.!d.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!b.c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!b.*.c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!b.b.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!b.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!b.!c.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!b.*.!c.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*{2}.!b.*.!c.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*.!c.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*{1}.!c.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.!b.*{1}.!c.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!b.*{1}.!c.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*{1}.!c.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.!c.*.e';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!b.!c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!b.*.!c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*{2}.!b.*.!c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*.!c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*{1}.!b.*{1}.!c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ 'a.!b.*{1}.!c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '!b.*{1}.!c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*{1}.!c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ~ '*.!b.*.!c.*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'QWER_TY'::ltree ~ 'q%@*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'QWER_TY'::ltree ~ 'Q_t%@*';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'QWER_GY'::ltree ~ 'q_t%@*';
^
ERROR: type "ltxtquery" does not exist
LINE 1: SELECT '!tree & aWdf@*'::ltxtquery;
^
ERROR: type "ltxtquery" does not exist
LINE 1: SELECT 'tree & aw_qw%*'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'ltree.awdfg'::ltree @ '!tree & aWdf@*'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg'::ltree @ '!tree & aWdf@*'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg'::ltree @ '!tree | aWdf@*'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg'::ltree @ 'tree | aWdf@*'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg'::ltree @ 'tree & aWdf@*'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg'::ltree @ 'tree & aWdf@'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg'::ltree @ 'tree & aWdf*'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg'::ltree @ 'tree & aWdf'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg'::ltree @ 'tree & awdf*'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg'::ltree @ 'tree & aWdfg@'::ltxtquery;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg_qwerty'::ltree @ 'tree & aw_qw%*'::ltxtqu...
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'tree.awdfg_qwerty'::ltree @ 'tree & aw_rw%*'::ltxtqu...
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{1.2.3}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{1.2.3.4}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{1.2.3.4.5}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{1.3.3}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{5.67.8, 1.2.3}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{5.67.8, 1.2.3.4}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{5.67.8, 1.2.3.4.5}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{5.67.8, 1.3.3}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{1.2.3, 7.12.asd}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{1.2.3.4, 7.12.asd}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{1.2.3.4.5, 7.12.asd}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{1.3.3, 7.12.asd}'::ltree[] @> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{ltree.asd, tree.awdfg}'::ltree[] @ 'tree & aWdfg@':...
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{j.k.l.m, g.b.c.d.e}'::ltree[] ~ 'mailto:A*@|g.b.c.d.e';;
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ? '{A.b.c.d.e}';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ? '{a.b.c.d.e}';
^
ERROR: type "ltree" does not exist
LINE 1: SELECT 'a.b.c.d.e'::ltree ? '{A.b.c.d.e, a.*}';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{a.b.c.d.e,B.df}'::ltree[] ? '{A.b.c.d.e}';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{a.b.c.d.e,B.df}'::ltree[] ? '{A.b.c.d.e,*.df}';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT ('{3456,1.2.3.34}'::ltree[] ?@> '1.2.3.4') is null;
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{3456,1.2.3}'::ltree[] ?@> '1.2.3.4';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{3456,1.2.3.4}'::ltree[] ?<@ '1.2.3';
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT ('{3456,1.2.3.4}'::ltree[] ?<@ '1.2.5') is null;
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{ltree.asd, tree.awdfg}'::ltree[] ?@ 'tree & aWdfg@'...
^
ERROR: type "ltree[]" does not exist
LINE 1: SELECT '{j.k.l.m, g.b.c.d.e}'::ltree[] ?~ 'mailto:A*@|g.b.c.d.e';;
^
ERROR: type "ltree" does not exist
LINE 1: CREATE TABLE ltreetest (t ltree);
^
data/ltree.data: No such file or directory
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: index "tstidx" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: relation "ltreetest" does not exist
ERROR: type "ltree[]" does not exist
LINE 1: create table _ltreetest (t ltree[]);
^
data/_ltree.data: No such file or directory
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
ERROR: relation "_ltreetest" does not exist
while executing
"exec psql < /usr/local/src/postgresql-8.2.1/contrib/ltree/sql/ltree.sql"
("uplevel" body line 1)
invoked from within
"uplevel 1 $script"