OSDN -- Desenvolver e Download de Software Open Source
Estado tradução de Português translation status for pt
  • R/O
  • HTTP
  • SSH
  • HTTPS
Fork

Commit

Tags
No Tags

Frequently used words (click to add to your profile)

javac++androidlinuxc#windowsobjective-ccocoa誰得qtpythonphprubygameguibathyscaphec計画中(planning stage)翻訳omegatframeworktwitterdomtestvb.netdirectxゲームエンジンbtronarduinopreviewer

Commit MetaInfo

Revisão24bdd54c9c6d1fb48d8c4b295c731919f2df0221 (tree)
Hora2014-06-09 15:28:23
AutorKyotaro Horiguchi <horiguchi.kyotaro@lab....>
CommiterKyotaro Horiguchi

Mensagem de Log

Rearrange files

Mudança Sumário

Diff

--- a/Makefile
+++ b/Makefile
@@ -3,6 +3,8 @@
33 MODULE_big = pg_dbms_stats
44 OBJS = pg_dbms_stats.o dump.o import.o
55 DBMSSTATSVER = 1.3.2
6+DOCDIR = doc
7+EXTDIR = ext_scripts
68
79 ifdef UNIT_TEST
810 PG_CPPFLAGS = -DUNIT_TEST
@@ -19,8 +21,8 @@ REGRESS = init-common ut_fdw_init init-$(MAJORVERSION) ut-common \
1921
2022 REGRESS_OPTS = --encoding=UTF8 --temp-config=regress.conf --extra-install=contrib/file_fdw
2123
22-DOCS = export_effective_stats-$(MAJORVERSION).sql.sample \
23- export_plain_stats-$(MAJORVERSION).sql.sample
24+DOCS = $(DOCDIR)/export_effective_stats-$(MAJORVERSION).sql.sample \
25+ $(DOCDIR)/export_plain_stats-$(MAJORVERSION).sql.sample
2426
2527 STARBALL = pg_dbms_stats-$(DBMSSTATSVER).tar.gz
2628 STARBALL94 = pg_dbms_stats94-$(DBMSSTATSVER).tar.gz
@@ -59,11 +61,10 @@ endif
5961 TARSOURCES = Makefile *.c *.h \
6062 $(EXTDIR)/pg_dbms_stats--*-9.*.sql \
6163 pg_dbms_stats.control COPYRIGHT ChangeLog ChangeLog.ja \
62- README.installcheck regress.conf doc/* \
63- expected/init-*.out expected/ut-*.out \
64+ README.installcheck regress.conf \
65+ doc/* expected/init-*.out expected/ut-*.out \
6466 sql/init-*.sql sql/ut-*.sql \
65- input/*.source input/*.csv \
66- output/*.source SPECS/*.spec
67+ input/*.source input/*.csv output/*.source SPECS/*.spec
6768
6869 all: $(DATA) $(DOCS)
6970
@@ -71,7 +72,7 @@ rpms: rpm93 rpm92 rpm91
7172
7273 sourcetar: $(STARBALL)
7374
74-$(DATA): %.sql: %-$(MAJORVERSION).sql
75+$(DATA): %.sql: $(EXTDIR)/%-$(MAJORVERSION).sql
7576 cp $< $@
7677
7778 $(STARBALLS): $(TARSOURCES)
--- a/SPECS/pg_dbms_stats91.spec
+++ b/SPECS/pg_dbms_stats91.spec
@@ -60,8 +60,8 @@ install -m 644 pg_dbms_stats--1.3.2.sql %{buildroot}%{_datadir}/extension/pg_dbm
6060 install -m 644 pg_dbms_stats--1.0--1.3.2.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.0--1.3.2.sql
6161 install -m 644 pg_dbms_stats.control %{buildroot}%{_datadir}/extension/pg_dbms_stats.control
6262 install -d %{buildroot}%{_docdir}/extension
63-install -m 644 export_effective_stats-9.1.sql.sample %{buildroot}%{_docdir}/extension/export_effective_stats-9.1.sql.sample
64-install -m 644 export_plain_stats-9.1.sql.sample %{buildroot}%{_docdir}/extension/export_plain_stats-9.1.sql.sample
63+install -m 644 doc/export_effective_stats-9.1.sql.sample %{buildroot}%{_docdir}/extension/export_effective_stats-9.1.sql.sample
64+install -m 644 doc/export_plain_stats-9.1.sql.sample %{buildroot}%{_docdir}/extension/export_plain_stats-9.1.sql.sample
6565
6666 %clean
6767 rm -rf %{buildroot}
--- a/SPECS/pg_dbms_stats92.spec
+++ b/SPECS/pg_dbms_stats92.spec
@@ -60,8 +60,8 @@ install -m 644 pg_dbms_stats--1.3.2.sql %{buildroot}%{_datadir}/extension/pg_dbm
6060 install -m 644 pg_dbms_stats--1.0--1.3.2.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.0--1.3.2.sql
6161 install -m 644 pg_dbms_stats.control %{buildroot}%{_datadir}/extension/pg_dbms_stats.control
6262 install -d %{buildroot}%{_docdir}/extension
63-install -m 644 export_effective_stats-9.2.sql.sample %{buildroot}%{_docdir}/extension/export_effective_stats-9.2.sql.sample
64-install -m 644 export_plain_stats-9.2.sql.sample %{buildroot}%{_docdir}/extension/export_plain_stats-9.2.sql.sample
63+install -m 644 doc/export_effective_stats-9.2.sql.sample %{buildroot}%{_docdir}/extension/export_effective_stats-9.2.sql.sample
64+install -m 644 doc/export_plain_stats-9.2.sql.sample %{buildroot}%{_docdir}/extension/export_plain_stats-9.2.sql.sample
6565
6666 %clean
6767 rm -rf %{buildroot}
--- a/SPECS/pg_dbms_stats93.spec
+++ b/SPECS/pg_dbms_stats93.spec
@@ -65,8 +65,8 @@ install -m 644 pg_dbms_stats--1.3.2.sql %{buildroot}%{_datadir}/extension/pg_dbm
6565 install -m 644 pg_dbms_stats--1.0--1.3.2.sql %{buildroot}%{_datadir}/extension/pg_dbms_stats--1.0--1.3.2.sql
6666 install -m 644 pg_dbms_stats.control %{buildroot}%{_datadir}/extension/pg_dbms_stats.control
6767 install -d %{buildroot}%{_docdir}/extension
68-install -m 644 export_effective_stats-9.3.sql.sample %{buildroot}%{_docdir}/extension/export_effective_stats-9.3.sql.sample
69-install -m 644 export_plain_stats-9.3.sql.sample %{buildroot}%{_docdir}/extension/export_plain_stats-9.3.sql.sample
68+install -m 644 doc/export_effective_stats-9.3.sql.sample %{buildroot}%{_docdir}/extension/export_effective_stats-9.3.sql.sample
69+install -m 644 doc/export_plain_stats-9.3.sql.sample %{buildroot}%{_docdir}/extension/export_plain_stats-9.3.sql.sample
7070
7171 %clean
7272 rm -rf %{buildroot}
--- /dev/null
+++ b/doc/export_effective_stats-9.4.sql.sample
@@ -0,0 +1,68 @@
1+/*
2+ * If you want the statistics of per-relation or per-column, please modify
3+ * nspname, relname, and attname in 'WHERE' clause.
4+ */
5+
6+BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
7+/*
8+ * If you want to chage the output file name, please modify the following name.
9+ */
10+\o export_stats.dmp
11+
12+COPY (SELECT n2.nspname,
13+ cl.relname,
14+ r.relpages,
15+ r.reltuples,
16+ r.relallvisible,
17+ r.curpages,
18+ r.last_analyze,
19+ r.last_autoanalyze,
20+ COALESCE(a.attname, ''),
21+ n1.nspname AS schemaname_of_atttype,
22+ t.typname,
23+ a.atttypmod,
24+ co.stainherit,
25+ co.stanullfrac,
26+ co.stawidth,
27+ co.stadistinct,
28+ co.stakind1,
29+ co.stakind2,
30+ co.stakind3,
31+ co.stakind4,
32+ co.stakind5,
33+ co.staop1,
34+ co.staop2,
35+ co.staop3,
36+ co.staop4,
37+ co.staop5,
38+ co.stanumbers1,
39+ co.stanumbers2,
40+ co.stanumbers3,
41+ co.stanumbers4,
42+ co.stanumbers5,
43+ co.stavalues1,
44+ co.stavalues2,
45+ co.stavalues3,
46+ co.stavalues4,
47+ co.stavalues5
48+ FROM dbms_stats.column_stats_effective co
49+ JOIN pg_attribute a
50+ ON (co.starelid = a.attrelid AND co.staattnum = a.attnum)
51+ JOIN pg_type t
52+ ON a.atttypid = t.oid
53+ JOIN pg_namespace n1
54+ ON t.typnamespace = n1.oid
55+ RIGHT JOIN dbms_stats.relation_stats_effective r
56+ ON co.starelid = r.relid
57+ JOIN pg_catalog.pg_class cl
58+ ON r.relid = cl.oid
59+ JOIN pg_catalog.pg_namespace n2
60+ ON cl.relnamespace = n2.oid
61+ -- WHERE n2.nspname = 'public'
62+ -- AND cl.relname = 'test'
63+ -- AND a.attname = 'id'
64+ ORDER BY starelid, staattnum)
65+TO STDOUT
66+(FORMAT 'binary');
67+\o
68+COMMIT;
--- /dev/null
+++ b/doc/export_plain_stats-9.4.sql.sample
@@ -0,0 +1,74 @@
1+/*
2+ * If you want the statistics of per-relation or per-column, please modify
3+ * nspname, relname, and attname in 'WHERE' clause.
4+ */
5+
6+BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;
7+/*
8+ * If you want to chage the output file name, please modify the following name.
9+ */
10+\o export_stats.dmp
11+
12+COPY (SELECT n2.nspname,
13+ c.relname,
14+ c.relpages,
15+ c.reltuples,
16+ c.relallvisible,
17+ (pg_relation_size(c.oid) / current_setting('block_size')::int4)::int4
18+ AS curpages,
19+ pg_catalog.pg_stat_get_last_analyze_time(c.oid)
20+ AS last_analyze,
21+ pg_catalog.pg_stat_get_last_autoanalyze_time(c.oid)
22+ AS last_autoanalyze,
23+ COALESCE(a.attname, ''),
24+ n1.nspname AS schemaname_of_atttype,
25+ t.typname,
26+ a.atttypmod,
27+ s.stainherit,
28+ s.stanullfrac,
29+ s.stawidth,
30+ s.stadistinct,
31+ s.stakind1,
32+ s.stakind2,
33+ s.stakind3,
34+ s.stakind4,
35+ s.stakind5,
36+ s.staop1,
37+ s.staop2,
38+ s.staop3,
39+ s.staop4,
40+ s.staop5,
41+ s.stanumbers1,
42+ s.stanumbers2,
43+ s.stanumbers3,
44+ s.stanumbers4,
45+ s.stanumbers5,
46+ s.stavalues1,
47+ s.stavalues2,
48+ s.stavalues3,
49+ s.stavalues4,
50+ s.stavalues5
51+ FROM pg_statistic s
52+ JOIN pg_attribute a
53+ ON (s.starelid = a.attrelid AND s.staattnum = a.attnum)
54+ JOIN pg_type t
55+ ON a.atttypid = t.oid
56+ JOIN pg_namespace n1
57+ ON t.typnamespace = n1.oid
58+ RIGHT JOIN pg_catalog.pg_class c
59+ ON s.starelid = c.oid
60+ JOIN pg_catalog.pg_namespace n2
61+ ON c.relnamespace = n2.oid
62+ WHERE c.relkind IN ('r', 'i', 'f', 'm')
63+ AND NOT n2.nspname IN ('pg_catalog',
64+ 'pg_toast',
65+ 'information_schema',
66+ 'dbms_stats')
67+ -- AND n2.nspname = 'public'
68+ -- AND c.relname = 'test'
69+ -- AND a.attname = 'id'
70+ ORDER BY starelid, staattnum)
71+TO STDOUT
72+(FORMAT 'binary');
73+\o
74+COMMIT;
--- a/input/ut_imp_exp-9.1.source
+++ b/input/ut_imp_exp-9.1.source
@@ -30,80 +30,80 @@ UPDATE dbms_stats._column_stats_locked SET
3030 stavalues2 = stavalues2,
3131 stavalues3 = stavalues1,
3232 stavalues4 = stavalues4;
33-\i export_plain_stats-9.1.sql.sample
33+\i doc/export_plain_stats-9.1.sql.sample
3434 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
3535 SELECT * FROM work_v;
3636 TRUNCATE dbms_stats.work;
3737 -- No.16-1-2
38-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
39-\i export_plain_stats-9.1.sql.sample_test
38+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
39+\i doc/export_plain_stats-9.1.sql.sample_test
4040 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
4141 SELECT * FROM work_v;
4242 TRUNCATE dbms_stats.work;
43-\! rm export_plain_stats-9.1.sql.sample_test
43+\! rm doc/export_plain_stats-9.1.sql.sample_test
4444 -- No.16-1-3
45-\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
46-\i export_plain_stats-9.1.sql.sample_test
45+\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
46+\i doc/export_plain_stats-9.1.sql.sample_test
4747 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
4848 SELECT * FROM work_v;
4949 TRUNCATE dbms_stats.work;
50-\! rm export_plain_stats-9.1.sql.sample_test
50+\! rm doc/export_plain_stats-9.1.sql.sample_test
5151 -- No.16-1-4
52-\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
53-\i export_plain_stats-9.1.sql.sample_test
52+\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
53+\i doc/export_plain_stats-9.1.sql.sample_test
5454 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
5555 SELECT * FROM work_v;
5656 TRUNCATE dbms_stats.work;
57-\! rm export_plain_stats-9.1.sql.sample_test
57+\! rm doc/export_plain_stats-9.1.sql.sample_test
5858 -- No.16-1-5
59-\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
60-\i export_plain_stats-9.1.sql.sample_test
59+\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
60+\i doc/export_plain_stats-9.1.sql.sample_test
6161 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
6262 SELECT * FROM work_v;
6363 TRUNCATE dbms_stats.work;
64-\! rm export_plain_stats-9.1.sql.sample_test
64+\! rm doc/export_plain_stats-9.1.sql.sample_test
6565 -- No.16-1-6
66-\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
67-\i export_plain_stats-9.1.sql.sample_test
66+\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
67+\i doc/export_plain_stats-9.1.sql.sample_test
6868 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
6969 SELECT * FROM work_v;
7070 TRUNCATE dbms_stats.work;
71-\! rm export_plain_stats-9.1.sql.sample_test
71+\! rm doc/export_plain_stats-9.1.sql.sample_test
7272 -- No.16-1-7
73-\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
74-\i export_plain_stats-9.1.sql.sample_test
73+\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
74+\i doc/export_plain_stats-9.1.sql.sample_test
7575 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
7676 SELECT * FROM work_v;
7777 TRUNCATE dbms_stats.work;
78-\! rm export_plain_stats-9.1.sql.sample_test
78+\! rm doc/export_plain_stats-9.1.sql.sample_test
7979 -- No.16-1-8
80-\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
81-\i export_plain_stats-9.1.sql.sample_test
80+\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
81+\i doc/export_plain_stats-9.1.sql.sample_test
8282 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
8383 SELECT * FROM work_v;
8484 TRUNCATE dbms_stats.work;
85-\! rm export_plain_stats-9.1.sql.sample_test
85+\! rm doc/export_plain_stats-9.1.sql.sample_test
8686 -- No.16-1-9
87-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
88-\i export_plain_stats-9.1.sql.sample_test
87+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
88+\i doc/export_plain_stats-9.1.sql.sample_test
8989 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
9090 SELECT * FROM work_v;
9191 TRUNCATE dbms_stats.work;
92-\! rm export_plain_stats-9.1.sql.sample_test
92+\! rm doc/export_plain_stats-9.1.sql.sample_test
9393 -- No.16-1-10
94-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
95-\i export_plain_stats-9.1.sql.sample_test
94+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
95+\i doc/export_plain_stats-9.1.sql.sample_test
9696 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
9797 SELECT * FROM work_v;
9898 TRUNCATE dbms_stats.work;
99-\! rm export_plain_stats-9.1.sql.sample_test
99+\! rm doc/export_plain_stats-9.1.sql.sample_test
100100 -- No.16-1-11
101-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
102-\i export_plain_stats-9.1.sql.sample_test
101+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
102+\i doc/export_plain_stats-9.1.sql.sample_test
103103 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
104104 SELECT * FROM work_v;
105105 TRUNCATE dbms_stats.work;
106-\! rm export_plain_stats-9.1.sql.sample_test
106+\! rm doc/export_plain_stats-9.1.sql.sample_test
107107
108108 /*
109109 * No.16-2 export_effective_stats-9.1.sql.sample
@@ -125,79 +125,79 @@ UPDATE dbms_stats._column_stats_locked
125125 NULL, NULL, NULL, NULL,
126126 NULL, NULL, NULL, NULL)
127127 WHERE starelid = 's0.st0'::regclass;
128-\i export_effective_stats-9.1.sql.sample
128+\i doc/export_effective_stats-9.1.sql.sample
129129 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
130130 SELECT * FROM work_v;
131131 TRUNCATE dbms_stats.work;
132132 -- No.16-2-2
133-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
134-\i export_effective_stats-9.1.sql.sample_test
133+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
134+\i doc/export_effective_stats-9.1.sql.sample_test
135135 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
136136 SELECT * FROM work_v;
137-\! rm export_effective_stats-9.1.sql.sample_test
137+\! rm doc/export_effective_stats-9.1.sql.sample_test
138138 TRUNCATE dbms_stats.work;
139139 -- No.16-2-3
140-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
141-\i export_effective_stats-9.1.sql.sample_test
140+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
141+\i doc/export_effective_stats-9.1.sql.sample_test
142142 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
143143 SELECT * FROM work_v;
144-\! rm export_effective_stats-9.1.sql.sample_test
144+\! rm doc/export_effective_stats-9.1.sql.sample_test
145145 TRUNCATE dbms_stats.work;
146146 -- No.16-2-4
147-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
148-\i export_effective_stats-9.1.sql.sample_test
147+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
148+\i doc/export_effective_stats-9.1.sql.sample_test
149149 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
150150 SELECT * FROM work_v;
151-\! rm export_effective_stats-9.1.sql.sample_test
151+\! rm doc/export_effective_stats-9.1.sql.sample_test
152152 TRUNCATE dbms_stats.work;
153153 -- No.16-2-5
154-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
155-\i export_effective_stats-9.1.sql.sample_test
154+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
155+\i doc/export_effective_stats-9.1.sql.sample_test
156156 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
157157 SELECT * FROM work_v;
158-\! rm export_effective_stats-9.1.sql.sample_test
158+\! rm doc/export_effective_stats-9.1.sql.sample_test
159159 TRUNCATE dbms_stats.work;
160160 -- No.16-2-6
161-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
162-\i export_effective_stats-9.1.sql.sample_test
161+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
162+\i doc/export_effective_stats-9.1.sql.sample_test
163163 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
164164 SELECT * FROM work_v;
165-\! rm export_effective_stats-9.1.sql.sample_test
165+\! rm doc/export_effective_stats-9.1.sql.sample_test
166166 TRUNCATE dbms_stats.work;
167167 -- No.16-2-7
168-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
169-\i export_effective_stats-9.1.sql.sample_test
168+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
169+\i doc/export_effective_stats-9.1.sql.sample_test
170170 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
171171 SELECT * FROM work_v;
172-\! rm export_effective_stats-9.1.sql.sample_test
172+\! rm doc/export_effective_stats-9.1.sql.sample_test
173173 TRUNCATE dbms_stats.work;
174174 -- No.16-2-8
175-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
176-\i export_effective_stats-9.1.sql.sample_test
175+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
176+\i doc/export_effective_stats-9.1.sql.sample_test
177177 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
178178 SELECT * FROM work_v;
179-\! rm export_effective_stats-9.1.sql.sample_test
179+\! rm doc/export_effective_stats-9.1.sql.sample_test
180180 TRUNCATE dbms_stats.work;
181181 -- No.16-2-9
182-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
183-\i export_effective_stats-9.1.sql.sample_test
182+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
183+\i doc/export_effective_stats-9.1.sql.sample_test
184184 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
185185 SELECT * FROM work_v;
186-\! rm export_effective_stats-9.1.sql.sample_test
186+\! rm doc/export_effective_stats-9.1.sql.sample_test
187187 TRUNCATE dbms_stats.work;
188188 -- No.16-2-10
189-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
190-\i export_effective_stats-9.1.sql.sample_test
189+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
190+\i doc/export_effective_stats-9.1.sql.sample_test
191191 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
192192 SELECT * FROM work_v;
193-\! rm export_effective_stats-9.1.sql.sample_test
193+\! rm doc/export_effective_stats-9.1.sql.sample_test
194194 TRUNCATE dbms_stats.work;
195195 -- No.16-2-11
196-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
197-\i export_effective_stats-9.1.sql.sample_test
196+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
197+\i doc/export_effective_stats-9.1.sql.sample_test
198198 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
199199 SELECT * FROM work_v;
200-\! rm export_effective_stats-9.1.sql.sample_test
200+\! rm doc/export_effective_stats-9.1.sql.sample_test
201201 TRUNCATE dbms_stats.work;
202202
203203 /*
--- a/input/ut_imp_exp-9.2.source
+++ b/input/ut_imp_exp-9.2.source
@@ -34,80 +34,80 @@ UPDATE dbms_stats._column_stats_locked SET
3434 stavalues3 = stavalues1,
3535 stavalues4 = stavalues4,
3636 stavalues5 = stavalues5;
37-\i export_plain_stats-9.2.sql.sample
37+\i doc/export_plain_stats-9.2.sql.sample
3838 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
3939 SELECT * FROM work_v;
4040 TRUNCATE dbms_stats.work;
4141 -- No.16-1-2
42-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
43-\i export_plain_stats-9.2.sql.sample_test
42+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
43+\i doc/export_plain_stats-9.2.sql.sample_test
4444 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
4545 SELECT * FROM work_v;
4646 TRUNCATE dbms_stats.work;
47-\! rm export_plain_stats-9.2.sql.sample_test
47+\! rm doc/export_plain_stats-9.2.sql.sample_test
4848 -- No.16-1-3
49-\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
50-\i export_plain_stats-9.2.sql.sample_test
49+\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
50+\i doc/export_plain_stats-9.2.sql.sample_test
5151 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
5252 SELECT * FROM work_v;
5353 TRUNCATE dbms_stats.work;
54-\! rm export_plain_stats-9.2.sql.sample_test
54+\! rm doc/export_plain_stats-9.2.sql.sample_test
5555 -- No.16-1-4
56-\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
57-\i export_plain_stats-9.2.sql.sample_test
56+\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
57+\i doc/export_plain_stats-9.2.sql.sample_test
5858 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
5959 SELECT * FROM work_v;
6060 TRUNCATE dbms_stats.work;
61-\! rm export_plain_stats-9.2.sql.sample_test
61+\! rm doc/export_plain_stats-9.2.sql.sample_test
6262 -- No.16-1-5
63-\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
64-\i export_plain_stats-9.2.sql.sample_test
63+\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
64+\i doc/export_plain_stats-9.2.sql.sample_test
6565 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
6666 SELECT * FROM work_v;
6767 TRUNCATE dbms_stats.work;
68-\! rm export_plain_stats-9.2.sql.sample_test
68+\! rm doc/export_plain_stats-9.2.sql.sample_test
6969 -- No.16-1-6
70-\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
71-\i export_plain_stats-9.2.sql.sample_test
70+\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
71+\i doc/export_plain_stats-9.2.sql.sample_test
7272 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
7373 SELECT * FROM work_v;
7474 TRUNCATE dbms_stats.work;
75-\! rm export_plain_stats-9.2.sql.sample_test
75+\! rm doc/export_plain_stats-9.2.sql.sample_test
7676 -- No.16-1-7
77-\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
78-\i export_plain_stats-9.2.sql.sample_test
77+\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
78+\i doc/export_plain_stats-9.2.sql.sample_test
7979 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
8080 SELECT * FROM work_v;
8181 TRUNCATE dbms_stats.work;
82-\! rm export_plain_stats-9.2.sql.sample_test
82+\! rm doc/export_plain_stats-9.2.sql.sample_test
8383 -- No.16-1-8
84-\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
85-\i export_plain_stats-9.2.sql.sample_test
84+\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
85+\i doc/export_plain_stats-9.2.sql.sample_test
8686 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
8787 SELECT * FROM work_v;
8888 TRUNCATE dbms_stats.work;
89-\! rm export_plain_stats-9.2.sql.sample_test
89+\! rm doc/export_plain_stats-9.2.sql.sample_test
9090 -- No.16-1-10
91-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
92-\i export_plain_stats-9.2.sql.sample_test
91+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
92+\i doc/export_plain_stats-9.2.sql.sample_test
9393 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
9494 SELECT * FROM work_v;
9595 TRUNCATE dbms_stats.work;
96-\! rm export_plain_stats-9.2.sql.sample_test
96+\! rm doc/export_plain_stats-9.2.sql.sample_test
9797 -- No.16-1-11
98-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
99-\i export_plain_stats-9.2.sql.sample_test
98+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
99+\i doc/export_plain_stats-9.2.sql.sample_test
100100 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
101101 SELECT * FROM work_v;
102102 TRUNCATE dbms_stats.work;
103-\! rm export_plain_stats-9.2.sql.sample_test
103+\! rm doc/export_plain_stats-9.2.sql.sample_test
104104 -- No.16-1-12
105-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
106-\i export_plain_stats-9.2.sql.sample_test
105+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
106+\i doc/export_plain_stats-9.2.sql.sample_test
107107 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
108108 SELECT * FROM work_v;
109109 TRUNCATE dbms_stats.work;
110-\! rm export_plain_stats-9.2.sql.sample_test
110+\! rm doc/export_plain_stats-9.2.sql.sample_test
111111
112112 /*
113113 * No.16-2 export_effective_stats-9.2.sql.sample
@@ -129,79 +129,79 @@ UPDATE dbms_stats._column_stats_locked
129129 NULL, NULL, NULL, NULL, NULL,
130130 NULL, NULL, NULL, NULL, NULL)
131131 WHERE starelid = 's0.st0'::regclass;
132-\i export_effective_stats-9.2.sql.sample
132+\i doc/export_effective_stats-9.2.sql.sample
133133 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
134134 SELECT * FROM work_v;
135135 TRUNCATE dbms_stats.work;
136136 -- No.16-2-2
137-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
138-\i export_effective_stats-9.2.sql.sample_test
137+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
138+\i doc/export_effective_stats-9.2.sql.sample_test
139139 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
140140 SELECT * FROM work_v;
141-\! rm export_effective_stats-9.2.sql.sample_test
141+\! rm doc/export_effective_stats-9.2.sql.sample_test
142142 TRUNCATE dbms_stats.work;
143143 -- No.16-2-3
144-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
145-\i export_effective_stats-9.2.sql.sample_test
144+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
145+\i doc/export_effective_stats-9.2.sql.sample_test
146146 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
147147 SELECT * FROM work_v;
148-\! rm export_effective_stats-9.2.sql.sample_test
148+\! rm doc/export_effective_stats-9.2.sql.sample_test
149149 TRUNCATE dbms_stats.work;
150150 -- No.16-2-4
151-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
152-\i export_effective_stats-9.2.sql.sample_test
151+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
152+\i doc/export_effective_stats-9.2.sql.sample_test
153153 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
154154 SELECT * FROM work_v;
155-\! rm export_effective_stats-9.2.sql.sample_test
155+\! rm doc/export_effective_stats-9.2.sql.sample_test
156156 TRUNCATE dbms_stats.work;
157157 -- No.16-2-5
158-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
159-\i export_effective_stats-9.2.sql.sample_test
158+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
159+\i doc/export_effective_stats-9.2.sql.sample_test
160160 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
161161 SELECT * FROM work_v;
162-\! rm export_effective_stats-9.2.sql.sample_test
162+\! rm doc/export_effective_stats-9.2.sql.sample_test
163163 TRUNCATE dbms_stats.work;
164164 -- No.16-2-6
165-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
166-\i export_effective_stats-9.2.sql.sample_test
165+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
166+\i doc/export_effective_stats-9.2.sql.sample_test
167167 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
168168 SELECT * FROM work_v;
169-\! rm export_effective_stats-9.2.sql.sample_test
169+\! rm doc/export_effective_stats-9.2.sql.sample_test
170170 TRUNCATE dbms_stats.work;
171171 -- No.16-2-7
172-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
173-\i export_effective_stats-9.2.sql.sample_test
172+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
173+\i doc/export_effective_stats-9.2.sql.sample_test
174174 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
175175 SELECT * FROM work_v;
176-\! rm export_effective_stats-9.2.sql.sample_test
176+\! rm doc/export_effective_stats-9.2.sql.sample_test
177177 TRUNCATE dbms_stats.work;
178178 -- No.16-2-8
179-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
180-\i export_effective_stats-9.2.sql.sample_test
179+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
180+\i doc/export_effective_stats-9.2.sql.sample_test
181181 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
182182 SELECT * FROM work_v;
183-\! rm export_effective_stats-9.2.sql.sample_test
183+\! rm doc/export_effective_stats-9.2.sql.sample_test
184184 TRUNCATE dbms_stats.work;
185185 -- No.16-2-9
186-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
187-\i export_effective_stats-9.2.sql.sample_test
186+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
187+\i doc/export_effective_stats-9.2.sql.sample_test
188188 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
189189 SELECT * FROM work_v;
190-\! rm export_effective_stats-9.2.sql.sample_test
190+\! rm doc/export_effective_stats-9.2.sql.sample_test
191191 TRUNCATE dbms_stats.work;
192192 -- No.16-2-10
193-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
194-\i export_effective_stats-9.2.sql.sample_test
193+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
194+\i doc/export_effective_stats-9.2.sql.sample_test
195195 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
196196 SELECT * FROM work_v;
197-\! rm export_effective_stats-9.2.sql.sample_test
197+\! rm doc/export_effective_stats-9.2.sql.sample_test
198198 TRUNCATE dbms_stats.work;
199199 -- No.16-2-11
200-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
201-\i export_effective_stats-9.2.sql.sample_test
200+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
201+\i doc/export_effective_stats-9.2.sql.sample_test
202202 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
203203 SELECT * FROM work_v;
204-\! rm export_effective_stats-9.2.sql.sample_test
204+\! rm doc/export_effective_stats-9.2.sql.sample_test
205205 TRUNCATE dbms_stats.work;
206206
207207 /*
--- a/input/ut_imp_exp-9.3.source
+++ b/input/ut_imp_exp-9.3.source
@@ -34,87 +34,87 @@ UPDATE dbms_stats._column_stats_locked SET
3434 stavalues3 = stavalues1,
3535 stavalues4 = stavalues4,
3636 stavalues5 = stavalues5;
37-\i export_plain_stats-9.3.sql.sample
37+\i doc/export_plain_stats-9.3.sql.sample
3838 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
3939 SELECT * FROM work_v;
4040 TRUNCATE dbms_stats.work;
4141 -- No.16-1-2
42-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
43-\i export_plain_stats-9.3.sql.sample_test
42+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
43+\i doc/export_plain_stats-9.3.sql.sample_test
4444 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
4545 SELECT * FROM work_v;
4646 TRUNCATE dbms_stats.work;
47-\! rm export_plain_stats-9.3.sql.sample_test
47+\! rm doc/export_plain_stats-9.3.sql.sample_test
4848 -- No.16-1-3
49-\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
50-\i export_plain_stats-9.3.sql.sample_test
49+\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
50+\i doc/export_plain_stats-9.3.sql.sample_test
5151 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
5252 SELECT * FROM work_v;
5353 TRUNCATE dbms_stats.work;
54-\! rm export_plain_stats-9.3.sql.sample_test
54+\! rm doc/export_plain_stats-9.3.sql.sample_test
5555 -- No.16-1-4
56-\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
57-\i export_plain_stats-9.3.sql.sample_test
56+\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
57+\i doc/export_plain_stats-9.3.sql.sample_test
5858 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
5959 SELECT * FROM work_v;
6060 TRUNCATE dbms_stats.work;
61-\! rm export_plain_stats-9.3.sql.sample_test
61+\! rm doc/export_plain_stats-9.3.sql.sample_test
6262 -- No.16-1-5
63-\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
64-\i export_plain_stats-9.3.sql.sample_test
63+\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
64+\i doc/export_plain_stats-9.3.sql.sample_test
6565 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
6666 SELECT * FROM work_v;
6767 TRUNCATE dbms_stats.work;
68-\! rm export_plain_stats-9.3.sql.sample_test
68+\! rm doc/export_plain_stats-9.3.sql.sample_test
6969 -- No.16-1-6
70-\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
71-\i export_plain_stats-9.3.sql.sample_test
70+\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
71+\i doc/export_plain_stats-9.3.sql.sample_test
7272 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
7373 SELECT * FROM work_v;
7474 TRUNCATE dbms_stats.work;
75-\! rm export_plain_stats-9.3.sql.sample_test
75+\! rm doc/export_plain_stats-9.3.sql.sample_test
7676 -- No.16-1-7
77-\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
78-\i export_plain_stats-9.3.sql.sample_test
77+\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
78+\i doc/export_plain_stats-9.3.sql.sample_test
7979 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
8080 SELECT * FROM work_v;
8181 TRUNCATE dbms_stats.work;
82-\! rm export_plain_stats-9.3.sql.sample_test
82+\! rm doc/export_plain_stats-9.3.sql.sample_test
8383 -- No.16-1-8
84-\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
85-\i export_plain_stats-9.3.sql.sample_test
84+\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
85+\i doc/export_plain_stats-9.3.sql.sample_test
8686 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
8787 SELECT * FROM work_v;
8888 TRUNCATE dbms_stats.work;
89-\! rm export_plain_stats-9.3.sql.sample_test
89+\! rm doc/export_plain_stats-9.3.sql.sample_test
9090 -- No.16-1-9
91-\! sed '/ORDER/i\\ AND c.relname = '"\'smv0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
92-\i export_plain_stats-9.3.sql.sample_test
91+\! sed '/ORDER/i\\ AND c.relname = '"\'smv0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
92+\i doc/export_plain_stats-9.3.sql.sample_test
9393 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
9494 SELECT * FROM work_v;
9595 TRUNCATE dbms_stats.work;
96-\! rm export_plain_stats-9.3.sql.sample_test
96+\! rm doc/export_plain_stats-9.3.sql.sample_test
9797 -- No.16-1-10
98-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
99-\i export_plain_stats-9.3.sql.sample_test
98+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
99+\i doc/export_plain_stats-9.3.sql.sample_test
100100 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
101101 SELECT * FROM work_v;
102102 TRUNCATE dbms_stats.work;
103-\! rm export_plain_stats-9.3.sql.sample_test
103+\! rm doc/export_plain_stats-9.3.sql.sample_test
104104 -- No.16-1-11
105-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
106-\i export_plain_stats-9.3.sql.sample_test
105+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
106+\i doc/export_plain_stats-9.3.sql.sample_test
107107 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
108108 SELECT * FROM work_v;
109109 TRUNCATE dbms_stats.work;
110-\! rm export_plain_stats-9.3.sql.sample_test
110+\! rm doc/export_plain_stats-9.3.sql.sample_test
111111 -- No.16-1-12
112-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
113-\i export_plain_stats-9.3.sql.sample_test
112+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
113+\i doc/export_plain_stats-9.3.sql.sample_test
114114 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
115115 SELECT * FROM work_v;
116116 TRUNCATE dbms_stats.work;
117-\! rm export_plain_stats-9.3.sql.sample_test
117+\! rm doc/export_plain_stats-9.3.sql.sample_test
118118
119119 /*
120120 * No.16-2 export_effective_stats-9.3.sql.sample
@@ -136,86 +136,86 @@ UPDATE dbms_stats._column_stats_locked
136136 NULL, NULL, NULL, NULL, NULL,
137137 NULL, NULL, NULL, NULL, NULL)
138138 WHERE starelid = 's0.st0'::regclass;
139-\i export_effective_stats-9.3.sql.sample
139+\i doc/export_effective_stats-9.3.sql.sample
140140 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
141141 SELECT * FROM work_v;
142142 TRUNCATE dbms_stats.work;
143143 -- No.16-2-2
144-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
145-\i export_effective_stats-9.3.sql.sample_test
144+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
145+\i doc/export_effective_stats-9.3.sql.sample_test
146146 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
147147 SELECT * FROM work_v;
148-\! rm export_effective_stats-9.3.sql.sample_test
148+\! rm doc/export_effective_stats-9.3.sql.sample_test
149149 TRUNCATE dbms_stats.work;
150150 -- No.16-2-3
151-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
152-\i export_effective_stats-9.3.sql.sample_test
151+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
152+\i doc/export_effective_stats-9.3.sql.sample_test
153153 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
154154 SELECT * FROM work_v;
155-\! rm export_effective_stats-9.3.sql.sample_test
155+\! rm doc/export_effective_stats-9.3.sql.sample_test
156156 TRUNCATE dbms_stats.work;
157157 -- No.16-2-4
158-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
159-\i export_effective_stats-9.3.sql.sample_test
158+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
159+\i doc/export_effective_stats-9.3.sql.sample_test
160160 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
161161 SELECT * FROM work_v;
162-\! rm export_effective_stats-9.3.sql.sample_test
162+\! rm doc/export_effective_stats-9.3.sql.sample_test
163163 TRUNCATE dbms_stats.work;
164164 -- No.16-2-5
165-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
166-\i export_effective_stats-9.3.sql.sample_test
165+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
166+\i doc/export_effective_stats-9.3.sql.sample_test
167167 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
168168 SELECT * FROM work_v;
169-\! rm export_effective_stats-9.3.sql.sample_test
169+\! rm doc/export_effective_stats-9.3.sql.sample_test
170170 TRUNCATE dbms_stats.work;
171171 -- No.16-2-6
172-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
173-\i export_effective_stats-9.3.sql.sample_test
172+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
173+\i doc/export_effective_stats-9.3.sql.sample_test
174174 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
175175 SELECT * FROM work_v;
176-\! rm export_effective_stats-9.3.sql.sample_test
176+\! rm doc/export_effective_stats-9.3.sql.sample_test
177177 TRUNCATE dbms_stats.work;
178178 -- No.16-2-7
179-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
180-\i export_effective_stats-9.3.sql.sample_test
179+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
180+\i doc/export_effective_stats-9.3.sql.sample_test
181181 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
182182 SELECT * FROM work_v;
183-\! rm export_effective_stats-9.3.sql.sample_test
183+\! rm doc/export_effective_stats-9.3.sql.sample_test
184184 TRUNCATE dbms_stats.work;
185185 -- No.16-2-8
186-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
187-\i export_effective_stats-9.3.sql.sample_test
186+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
187+\i doc/export_effective_stats-9.3.sql.sample_test
188188 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
189189 SELECT * FROM work_v;
190-\! rm export_effective_stats-9.3.sql.sample_test
190+\! rm doc/export_effective_stats-9.3.sql.sample_test
191191 TRUNCATE dbms_stats.work;
192192 -- No.16-2-9
193-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'smv0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
194-\i export_effective_stats-9.3.sql.sample_test
193+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'smv0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
194+\i doc/export_effective_stats-9.3.sql.sample_test
195195 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
196196 SELECT * FROM work_v;
197-\! rm export_effective_stats-9.3.sql.sample_test
197+\! rm doc/export_effective_stats-9.3.sql.sample_test
198198 TRUNCATE dbms_stats.work;
199199 -- No.16-2-10
200-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
201-\i export_effective_stats-9.3.sql.sample_test
200+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
201+\i doc/export_effective_stats-9.3.sql.sample_test
202202 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
203203 SELECT * FROM work_v;
204-\! rm export_effective_stats-9.3.sql.sample_test
204+\! rm doc/export_effective_stats-9.3.sql.sample_test
205205 TRUNCATE dbms_stats.work;
206206 -- No.16-2-11
207-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
208-\i export_effective_stats-9.3.sql.sample_test
207+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
208+\i doc/export_effective_stats-9.3.sql.sample_test
209209 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
210210 SELECT * FROM work_v;
211-\! rm export_effective_stats-9.3.sql.sample_test
211+\! rm doc/export_effective_stats-9.3.sql.sample_test
212212 TRUNCATE dbms_stats.work;
213213 -- No.16-2-12
214-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
215-\i export_effective_stats-9.3.sql.sample_test
214+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
215+\i doc/export_effective_stats-9.3.sql.sample_test
216216 COPY dbms_stats.work FROM '@abs_srcdir@/export_stats.dmp' (FORMAT 'binary');
217217 SELECT * FROM work_v;
218-\! rm export_effective_stats-9.3.sql.sample_test
218+\! rm doc/export_effective_stats-9.3.sql.sample_test
219219 TRUNCATE dbms_stats.work;
220220
221221 /*
--- a/output/ut_imp_exp-9.1.source
+++ b/output/ut_imp_exp-9.1.source
@@ -49,7 +49,7 @@ UPDATE dbms_stats._column_stats_locked SET
4949 stavalues2 = stavalues2,
5050 stavalues3 = stavalues1,
5151 stavalues4 = stavalues4;
52-\i export_plain_stats-9.1.sql.sample
52+\i doc/export_plain_stats-9.1.sql.sample
5353 /*
5454 * If you want the statistics of per-relation or per-column, please modify
5555 * nspname, relname, and attname in 'WHERE' clause.
@@ -148,8 +148,8 @@ SELECT * FROM work_v;
148148
149149 TRUNCATE dbms_stats.work;
150150 -- No.16-1-2
151-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
152-\i export_plain_stats-9.1.sql.sample_test
151+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
152+\i doc/export_plain_stats-9.1.sql.sample_test
153153 /*
154154 * If you want the statistics of per-relation or per-column, please modify
155155 * nspname, relname, and attname in 'WHERE' clause.
@@ -237,10 +237,10 @@ SELECT * FROM work_v;
237237 (12 rows)
238238
239239 TRUNCATE dbms_stats.work;
240-\! rm export_plain_stats-9.1.sql.sample_test
240+\! rm doc/export_plain_stats-9.1.sql.sample_test
241241 -- No.16-1-3
242-\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
243-\i export_plain_stats-9.1.sql.sample_test
242+\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
243+\i doc/export_plain_stats-9.1.sql.sample_test
244244 /*
245245 * If you want the statistics of per-relation or per-column, please modify
246246 * nspname, relname, and attname in 'WHERE' clause.
@@ -324,10 +324,10 @@ SELECT * FROM work_v;
324324 (8 rows)
325325
326326 TRUNCATE dbms_stats.work;
327-\! rm export_plain_stats-9.1.sql.sample_test
327+\! rm doc/export_plain_stats-9.1.sql.sample_test
328328 -- No.16-1-4
329-\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
330-\i export_plain_stats-9.1.sql.sample_test
329+\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
330+\i doc/export_plain_stats-9.1.sql.sample_test
331331 /*
332332 * If you want the statistics of per-relation or per-column, please modify
333333 * nspname, relname, and attname in 'WHERE' clause.
@@ -403,10 +403,10 @@ SELECT * FROM work_v;
403403 (0 rows)
404404
405405 TRUNCATE dbms_stats.work;
406-\! rm export_plain_stats-9.1.sql.sample_test
406+\! rm doc/export_plain_stats-9.1.sql.sample_test
407407 -- No.16-1-5
408-\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
409-\i export_plain_stats-9.1.sql.sample_test
408+\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
409+\i doc/export_plain_stats-9.1.sql.sample_test
410410 /*
411411 * If you want the statistics of per-relation or per-column, please modify
412412 * nspname, relname, and attname in 'WHERE' clause.
@@ -484,10 +484,10 @@ SELECT * FROM work_v;
484484 (2 rows)
485485
486486 TRUNCATE dbms_stats.work;
487-\! rm export_plain_stats-9.1.sql.sample_test
487+\! rm doc/export_plain_stats-9.1.sql.sample_test
488488 -- No.16-1-6
489-\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
490-\i export_plain_stats-9.1.sql.sample_test
489+\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
490+\i doc/export_plain_stats-9.1.sql.sample_test
491491 /*
492492 * If you want the statistics of per-relation or per-column, please modify
493493 * nspname, relname, and attname in 'WHERE' clause.
@@ -563,10 +563,10 @@ SELECT * FROM work_v;
563563 (0 rows)
564564
565565 TRUNCATE dbms_stats.work;
566-\! rm export_plain_stats-9.1.sql.sample_test
566+\! rm doc/export_plain_stats-9.1.sql.sample_test
567567 -- No.16-1-7
568-\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
569-\i export_plain_stats-9.1.sql.sample_test
568+\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
569+\i doc/export_plain_stats-9.1.sql.sample_test
570570 /*
571571 * If you want the statistics of per-relation or per-column, please modify
572572 * nspname, relname, and attname in 'WHERE' clause.
@@ -642,10 +642,10 @@ SELECT * FROM work_v;
642642 (0 rows)
643643
644644 TRUNCATE dbms_stats.work;
645-\! rm export_plain_stats-9.1.sql.sample_test
645+\! rm doc/export_plain_stats-9.1.sql.sample_test
646646 -- No.16-1-8
647-\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
648-\i export_plain_stats-9.1.sql.sample_test
647+\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
648+\i doc/export_plain_stats-9.1.sql.sample_test
649649 /*
650650 * If you want the statistics of per-relation or per-column, please modify
651651 * nspname, relname, and attname in 'WHERE' clause.
@@ -721,10 +721,10 @@ SELECT * FROM work_v;
721721 (0 rows)
722722
723723 TRUNCATE dbms_stats.work;
724-\! rm export_plain_stats-9.1.sql.sample_test
724+\! rm doc/export_plain_stats-9.1.sql.sample_test
725725 -- No.16-1-9
726-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
727-\i export_plain_stats-9.1.sql.sample_test
726+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
727+\i doc/export_plain_stats-9.1.sql.sample_test
728728 /*
729729 * If you want the statistics of per-relation or per-column, please modify
730730 * nspname, relname, and attname in 'WHERE' clause.
@@ -804,10 +804,10 @@ SELECT * FROM work_v;
804804 (4 rows)
805805
806806 TRUNCATE dbms_stats.work;
807-\! rm export_plain_stats-9.1.sql.sample_test
807+\! rm doc/export_plain_stats-9.1.sql.sample_test
808808 -- No.16-1-10
809-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
810-\i export_plain_stats-9.1.sql.sample_test
809+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
810+\i doc/export_plain_stats-9.1.sql.sample_test
811811 /*
812812 * If you want the statistics of per-relation or per-column, please modify
813813 * nspname, relname, and attname in 'WHERE' clause.
@@ -887,10 +887,10 @@ SELECT * FROM work_v;
887887 (4 rows)
888888
889889 TRUNCATE dbms_stats.work;
890-\! rm export_plain_stats-9.1.sql.sample_test
890+\! rm doc/export_plain_stats-9.1.sql.sample_test
891891 -- No.16-1-11
892-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' export_plain_stats-9.1.sql.sample > export_plain_stats-9.1.sql.sample_test
893-\i export_plain_stats-9.1.sql.sample_test
892+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' doc/export_plain_stats-9.1.sql.sample > doc/export_plain_stats-9.1.sql.sample_test
893+\i doc/export_plain_stats-9.1.sql.sample_test
894894 /*
895895 * If you want the statistics of per-relation or per-column, please modify
896896 * nspname, relname, and attname in 'WHERE' clause.
@@ -966,7 +966,7 @@ SELECT * FROM work_v;
966966 (0 rows)
967967
968968 TRUNCATE dbms_stats.work;
969-\! rm export_plain_stats-9.1.sql.sample_test
969+\! rm doc/export_plain_stats-9.1.sql.sample_test
970970 /*
971971 * No.16-2 export_effective_stats-9.1.sql.sample
972972 */
@@ -1006,7 +1006,7 @@ UPDATE dbms_stats._column_stats_locked
10061006 NULL, NULL, NULL, NULL,
10071007 NULL, NULL, NULL, NULL)
10081008 WHERE starelid = 's0.st0'::regclass;
1009-\i export_effective_stats-9.1.sql.sample
1009+\i doc/export_effective_stats-9.1.sql.sample
10101010 /*
10111011 * If you want the statistics of per-relation or per-column, please modify
10121012 * nspname, relname, and attname in 'WHERE' clause.
@@ -1099,8 +1099,8 @@ SELECT * FROM work_v;
10991099
11001100 TRUNCATE dbms_stats.work;
11011101 -- No.16-2-2
1102-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
1103-\i export_effective_stats-9.1.sql.sample_test
1102+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
1103+\i doc/export_effective_stats-9.1.sql.sample_test
11041104 /*
11051105 * If you want the statistics of per-relation or per-column, please modify
11061106 * nspname, relname, and attname in 'WHERE' clause.
@@ -1181,11 +1181,11 @@ SELECT * FROM work_v;
11811181 s0 | st3 | 0 | 0 | 0 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
11821182 (12 rows)
11831183
1184-\! rm export_effective_stats-9.1.sql.sample_test
1184+\! rm doc/export_effective_stats-9.1.sql.sample_test
11851185 TRUNCATE dbms_stats.work;
11861186 -- No.16-2-3
1187-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
1188-\i export_effective_stats-9.1.sql.sample_test
1187+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
1188+\i doc/export_effective_stats-9.1.sql.sample_test
11891189 /*
11901190 * If you want the statistics of per-relation or per-column, please modify
11911191 * nspname, relname, and attname in 'WHERE' clause.
@@ -1262,11 +1262,11 @@ SELECT * FROM work_v;
12621262 s1 | st0 | 1 | 4 | 1 | num | pg_catalog | int4 | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 22 | 23 | 24 | 21 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | (null) | (null) | {15,25,35,45} | (null)
12631263 (8 rows)
12641264
1265-\! rm export_effective_stats-9.1.sql.sample_test
1265+\! rm doc/export_effective_stats-9.1.sql.sample_test
12661266 TRUNCATE dbms_stats.work;
12671267 -- No.16-2-4
1268-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
1269-\i export_effective_stats-9.1.sql.sample_test
1268+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
1269+\i doc/export_effective_stats-9.1.sql.sample_test
12701270 /*
12711271 * If you want the statistics of per-relation or per-column, please modify
12721272 * nspname, relname, and attname in 'WHERE' clause.
@@ -1335,11 +1335,11 @@ SELECT * FROM work_v;
13351335 ---------+---------+----------+-----------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
13361336 (0 rows)
13371337
1338-\! rm export_effective_stats-9.1.sql.sample_test
1338+\! rm doc/export_effective_stats-9.1.sql.sample_test
13391339 TRUNCATE dbms_stats.work;
13401340 -- No.16-2-5
1341-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
1342-\i export_effective_stats-9.1.sql.sample_test
1341+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
1342+\i doc/export_effective_stats-9.1.sql.sample_test
13431343 /*
13441344 * If you want the statistics of per-relation or per-column, please modify
13451345 * nspname, relname, and attname in 'WHERE' clause.
@@ -1410,11 +1410,11 @@ SELECT * FROM work_v;
14101410 s0 | st0_idx | 2 | 2 | 2 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
14111411 (2 rows)
14121412
1413-\! rm export_effective_stats-9.1.sql.sample_test
1413+\! rm doc/export_effective_stats-9.1.sql.sample_test
14141414 TRUNCATE dbms_stats.work;
14151415 -- No.16-2-6
1416-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
1417-\i export_effective_stats-9.1.sql.sample_test
1416+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
1417+\i doc/export_effective_stats-9.1.sql.sample_test
14181418 /*
14191419 * If you want the statistics of per-relation or per-column, please modify
14201420 * nspname, relname, and attname in 'WHERE' clause.
@@ -1483,11 +1483,11 @@ SELECT * FROM work_v;
14831483 ---------+---------+----------+-----------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
14841484 (0 rows)
14851485
1486-\! rm export_effective_stats-9.1.sql.sample_test
1486+\! rm doc/export_effective_stats-9.1.sql.sample_test
14871487 TRUNCATE dbms_stats.work;
14881488 -- No.16-2-7
1489-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
1490-\i export_effective_stats-9.1.sql.sample_test
1489+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
1490+\i doc/export_effective_stats-9.1.sql.sample_test
14911491 /*
14921492 * If you want the statistics of per-relation or per-column, please modify
14931493 * nspname, relname, and attname in 'WHERE' clause.
@@ -1556,11 +1556,11 @@ SELECT * FROM work_v;
15561556 ---------+---------+----------+-----------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
15571557 (0 rows)
15581558
1559-\! rm export_effective_stats-9.1.sql.sample_test
1559+\! rm doc/export_effective_stats-9.1.sql.sample_test
15601560 TRUNCATE dbms_stats.work;
15611561 -- No.16-2-8
1562-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
1563-\i export_effective_stats-9.1.sql.sample_test
1562+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
1563+\i doc/export_effective_stats-9.1.sql.sample_test
15641564 /*
15651565 * If you want the statistics of per-relation or per-column, please modify
15661566 * nspname, relname, and attname in 'WHERE' clause.
@@ -1629,11 +1629,11 @@ SELECT * FROM work_v;
16291629 ---------+---------+----------+-----------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
16301630 (0 rows)
16311631
1632-\! rm export_effective_stats-9.1.sql.sample_test
1632+\! rm doc/export_effective_stats-9.1.sql.sample_test
16331633 TRUNCATE dbms_stats.work;
16341634 -- No.16-2-9
1635-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
1636-\i export_effective_stats-9.1.sql.sample_test
1635+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
1636+\i doc/export_effective_stats-9.1.sql.sample_test
16371637 /*
16381638 * If you want the statistics of per-relation or per-column, please modify
16391639 * nspname, relname, and attname in 'WHERE' clause.
@@ -1706,11 +1706,11 @@ SELECT * FROM work_v;
17061706 s0 | st2 | 1 | 3 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 22 | 23 | 24 | 21 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | (null) | (null) | {1,2,3} | (null)
17071707 (4 rows)
17081708
1709-\! rm export_effective_stats-9.1.sql.sample_test
1709+\! rm doc/export_effective_stats-9.1.sql.sample_test
17101710 TRUNCATE dbms_stats.work;
17111711 -- No.16-2-10
1712-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
1713-\i export_effective_stats-9.1.sql.sample_test
1712+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
1713+\i doc/export_effective_stats-9.1.sql.sample_test
17141714 /*
17151715 * If you want the statistics of per-relation or per-column, please modify
17161716 * nspname, relname, and attname in 'WHERE' clause.
@@ -1783,11 +1783,11 @@ SELECT * FROM work_v;
17831783 s0 | st3 | 0 | 0 | 0 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
17841784 (4 rows)
17851785
1786-\! rm export_effective_stats-9.1.sql.sample_test
1786+\! rm doc/export_effective_stats-9.1.sql.sample_test
17871787 TRUNCATE dbms_stats.work;
17881788 -- No.16-2-11
1789-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' export_effective_stats-9.1.sql.sample > export_effective_stats-9.1.sql.sample_test
1790-\i export_effective_stats-9.1.sql.sample_test
1789+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' doc/export_effective_stats-9.1.sql.sample > doc/export_effective_stats-9.1.sql.sample_test
1790+\i doc/export_effective_stats-9.1.sql.sample_test
17911791 /*
17921792 * If you want the statistics of per-relation or per-column, please modify
17931793 * nspname, relname, and attname in 'WHERE' clause.
@@ -1856,7 +1856,7 @@ SELECT * FROM work_v;
18561856 ---------+---------+----------+-----------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+------------+------------+------------+------------
18571857 (0 rows)
18581858
1859-\! rm export_effective_stats-9.1.sql.sample_test
1859+\! rm doc/export_effective_stats-9.1.sql.sample_test
18601860 TRUNCATE dbms_stats.work;
18611861 /*
18621862 * Stab function dbms_stats.import
--- a/output/ut_imp_exp-9.2.source
+++ b/output/ut_imp_exp-9.2.source
@@ -54,7 +54,7 @@ UPDATE dbms_stats._column_stats_locked SET
5454 stavalues3 = stavalues1,
5555 stavalues4 = stavalues4,
5656 stavalues5 = stavalues5;
57-\i export_plain_stats-9.2.sql.sample
57+\i doc/export_plain_stats-9.2.sql.sample
5858 /*
5959 * If you want the statistics of per-relation or per-column, please modify
6060 * nspname, relname, and attname in 'WHERE' clause.
@@ -159,8 +159,8 @@ SELECT * FROM work_v;
159159
160160 TRUNCATE dbms_stats.work;
161161 -- No.16-1-2
162-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
163-\i export_plain_stats-9.2.sql.sample_test
162+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
163+\i doc/export_plain_stats-9.2.sql.sample_test
164164 /*
165165 * If you want the statistics of per-relation or per-column, please modify
166166 * nspname, relname, and attname in 'WHERE' clause.
@@ -254,10 +254,10 @@ SELECT * FROM work_v;
254254 (13 rows)
255255
256256 TRUNCATE dbms_stats.work;
257-\! rm export_plain_stats-9.2.sql.sample_test
257+\! rm doc/export_plain_stats-9.2.sql.sample_test
258258 -- No.16-1-3
259-\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
260-\i export_plain_stats-9.2.sql.sample_test
259+\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
260+\i doc/export_plain_stats-9.2.sql.sample_test
261261 /*
262262 * If you want the statistics of per-relation or per-column, please modify
263263 * nspname, relname, and attname in 'WHERE' clause.
@@ -346,10 +346,10 @@ SELECT * FROM work_v;
346346 (8 rows)
347347
348348 TRUNCATE dbms_stats.work;
349-\! rm export_plain_stats-9.2.sql.sample_test
349+\! rm doc/export_plain_stats-9.2.sql.sample_test
350350 -- No.16-1-4
351-\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
352-\i export_plain_stats-9.2.sql.sample_test
351+\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
352+\i doc/export_plain_stats-9.2.sql.sample_test
353353 /*
354354 * If you want the statistics of per-relation or per-column, please modify
355355 * nspname, relname, and attname in 'WHERE' clause.
@@ -430,10 +430,10 @@ SELECT * FROM work_v;
430430 (0 rows)
431431
432432 TRUNCATE dbms_stats.work;
433-\! rm export_plain_stats-9.2.sql.sample_test
433+\! rm doc/export_plain_stats-9.2.sql.sample_test
434434 -- No.16-1-5
435-\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
436-\i export_plain_stats-9.2.sql.sample_test
435+\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
436+\i doc/export_plain_stats-9.2.sql.sample_test
437437 /*
438438 * If you want the statistics of per-relation or per-column, please modify
439439 * nspname, relname, and attname in 'WHERE' clause.
@@ -516,10 +516,10 @@ SELECT * FROM work_v;
516516 (2 rows)
517517
518518 TRUNCATE dbms_stats.work;
519-\! rm export_plain_stats-9.2.sql.sample_test
519+\! rm doc/export_plain_stats-9.2.sql.sample_test
520520 -- No.16-1-6
521-\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
522-\i export_plain_stats-9.2.sql.sample_test
521+\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
522+\i doc/export_plain_stats-9.2.sql.sample_test
523523 /*
524524 * If you want the statistics of per-relation or per-column, please modify
525525 * nspname, relname, and attname in 'WHERE' clause.
@@ -600,10 +600,10 @@ SELECT * FROM work_v;
600600 (0 rows)
601601
602602 TRUNCATE dbms_stats.work;
603-\! rm export_plain_stats-9.2.sql.sample_test
603+\! rm doc/export_plain_stats-9.2.sql.sample_test
604604 -- No.16-1-7
605-\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
606-\i export_plain_stats-9.2.sql.sample_test
605+\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
606+\i doc/export_plain_stats-9.2.sql.sample_test
607607 /*
608608 * If you want the statistics of per-relation or per-column, please modify
609609 * nspname, relname, and attname in 'WHERE' clause.
@@ -684,10 +684,10 @@ SELECT * FROM work_v;
684684 (0 rows)
685685
686686 TRUNCATE dbms_stats.work;
687-\! rm export_plain_stats-9.2.sql.sample_test
687+\! rm doc/export_plain_stats-9.2.sql.sample_test
688688 -- No.16-1-8
689-\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
690-\i export_plain_stats-9.2.sql.sample_test
689+\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
690+\i doc/export_plain_stats-9.2.sql.sample_test
691691 /*
692692 * If you want the statistics of per-relation or per-column, please modify
693693 * nspname, relname, and attname in 'WHERE' clause.
@@ -769,10 +769,10 @@ SELECT * FROM work_v;
769769 (1 row)
770770
771771 TRUNCATE dbms_stats.work;
772-\! rm export_plain_stats-9.2.sql.sample_test
772+\! rm doc/export_plain_stats-9.2.sql.sample_test
773773 -- No.16-1-10
774-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
775-\i export_plain_stats-9.2.sql.sample_test
774+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
775+\i doc/export_plain_stats-9.2.sql.sample_test
776776 /*
777777 * If you want the statistics of per-relation or per-column, please modify
778778 * nspname, relname, and attname in 'WHERE' clause.
@@ -858,10 +858,10 @@ SELECT * FROM work_v;
858858 (5 rows)
859859
860860 TRUNCATE dbms_stats.work;
861-\! rm export_plain_stats-9.2.sql.sample_test
861+\! rm doc/export_plain_stats-9.2.sql.sample_test
862862 -- No.16-1-11
863-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
864-\i export_plain_stats-9.2.sql.sample_test
863+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
864+\i doc/export_plain_stats-9.2.sql.sample_test
865865 /*
866866 * If you want the statistics of per-relation or per-column, please modify
867867 * nspname, relname, and attname in 'WHERE' clause.
@@ -946,10 +946,10 @@ SELECT * FROM work_v;
946946 (4 rows)
947947
948948 TRUNCATE dbms_stats.work;
949-\! rm export_plain_stats-9.2.sql.sample_test
949+\! rm doc/export_plain_stats-9.2.sql.sample_test
950950 -- No.16-1-12
951-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' export_plain_stats-9.2.sql.sample > export_plain_stats-9.2.sql.sample_test
952-\i export_plain_stats-9.2.sql.sample_test
951+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' doc/export_plain_stats-9.2.sql.sample > doc/export_plain_stats-9.2.sql.sample_test
952+\i doc/export_plain_stats-9.2.sql.sample_test
953953 /*
954954 * If you want the statistics of per-relation or per-column, please modify
955955 * nspname, relname, and attname in 'WHERE' clause.
@@ -1030,7 +1030,7 @@ SELECT * FROM work_v;
10301030 (0 rows)
10311031
10321032 TRUNCATE dbms_stats.work;
1033-\! rm export_plain_stats-9.2.sql.sample_test
1033+\! rm doc/export_plain_stats-9.2.sql.sample_test
10341034 /*
10351035 * No.16-2 export_effective_stats-9.2.sql.sample
10361036 */
@@ -1071,7 +1071,7 @@ UPDATE dbms_stats._column_stats_locked
10711071 NULL, NULL, NULL, NULL, NULL,
10721072 NULL, NULL, NULL, NULL, NULL)
10731073 WHERE starelid = 's0.st0'::regclass;
1074-\i export_effective_stats-9.2.sql.sample
1074+\i doc/export_effective_stats-9.2.sql.sample
10751075 /*
10761076 * If you want the statistics of per-relation or per-column, please modify
10771077 * nspname, relname, and attname in 'WHERE' clause.
@@ -1170,8 +1170,8 @@ SELECT * FROM work_v;
11701170
11711171 TRUNCATE dbms_stats.work;
11721172 -- No.16-2-2
1173-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
1174-\i export_effective_stats-9.2.sql.sample_test
1173+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
1174+\i doc/export_effective_stats-9.2.sql.sample_test
11751175 /*
11761176 * If you want the statistics of per-relation or per-column, please modify
11771177 * nspname, relname, and attname in 'WHERE' clause.
@@ -1258,11 +1258,11 @@ SELECT * FROM work_v;
12581258 s0 | st3 | 0 | 0 | 0 | 0 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
12591259 (13 rows)
12601260
1261-\! rm export_effective_stats-9.2.sql.sample_test
1261+\! rm doc/export_effective_stats-9.2.sql.sample_test
12621262 TRUNCATE dbms_stats.work;
12631263 -- No.16-2-3
1264-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
1265-\i export_effective_stats-9.2.sql.sample_test
1264+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
1265+\i doc/export_effective_stats-9.2.sql.sample_test
12661266 /*
12671267 * If you want the statistics of per-relation or per-column, please modify
12681268 * nspname, relname, and attname in 'WHERE' clause.
@@ -1344,11 +1344,11 @@ SELECT * FROM work_v;
13441344 s1 | st0 | 1 | 4 | 1 | 1 | num | pg_catalog | int4 | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {15,25,35,45} | (null) | (null)
13451345 (8 rows)
13461346
1347-\! rm export_effective_stats-9.2.sql.sample_test
1347+\! rm doc/export_effective_stats-9.2.sql.sample_test
13481348 TRUNCATE dbms_stats.work;
13491349 -- No.16-2-4
1350-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
1351-\i export_effective_stats-9.2.sql.sample_test
1350+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
1351+\i doc/export_effective_stats-9.2.sql.sample_test
13521352 /*
13531353 * If you want the statistics of per-relation or per-column, please modify
13541354 * nspname, relname, and attname in 'WHERE' clause.
@@ -1422,11 +1422,11 @@ SELECT * FROM work_v;
14221422 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
14231423 (0 rows)
14241424
1425-\! rm export_effective_stats-9.2.sql.sample_test
1425+\! rm doc/export_effective_stats-9.2.sql.sample_test
14261426 TRUNCATE dbms_stats.work;
14271427 -- No.16-2-5
1428-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
1429-\i export_effective_stats-9.2.sql.sample_test
1428+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
1429+\i doc/export_effective_stats-9.2.sql.sample_test
14301430 /*
14311431 * If you want the statistics of per-relation or per-column, please modify
14321432 * nspname, relname, and attname in 'WHERE' clause.
@@ -1502,11 +1502,11 @@ SELECT * FROM work_v;
15021502 s0 | st0_idx | 2 | 2 | 0 | 2 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
15031503 (2 rows)
15041504
1505-\! rm export_effective_stats-9.2.sql.sample_test
1505+\! rm doc/export_effective_stats-9.2.sql.sample_test
15061506 TRUNCATE dbms_stats.work;
15071507 -- No.16-2-6
1508-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
1509-\i export_effective_stats-9.2.sql.sample_test
1508+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
1509+\i doc/export_effective_stats-9.2.sql.sample_test
15101510 /*
15111511 * If you want the statistics of per-relation or per-column, please modify
15121512 * nspname, relname, and attname in 'WHERE' clause.
@@ -1580,11 +1580,11 @@ SELECT * FROM work_v;
15801580 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
15811581 (0 rows)
15821582
1583-\! rm export_effective_stats-9.2.sql.sample_test
1583+\! rm doc/export_effective_stats-9.2.sql.sample_test
15841584 TRUNCATE dbms_stats.work;
15851585 -- No.16-2-7
1586-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
1587-\i export_effective_stats-9.2.sql.sample_test
1586+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
1587+\i doc/export_effective_stats-9.2.sql.sample_test
15881588 /*
15891589 * If you want the statistics of per-relation or per-column, please modify
15901590 * nspname, relname, and attname in 'WHERE' clause.
@@ -1658,11 +1658,11 @@ SELECT * FROM work_v;
16581658 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
16591659 (0 rows)
16601660
1661-\! rm export_effective_stats-9.2.sql.sample_test
1661+\! rm doc/export_effective_stats-9.2.sql.sample_test
16621662 TRUNCATE dbms_stats.work;
16631663 -- No.16-2-8
1664-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
1665-\i export_effective_stats-9.2.sql.sample_test
1664+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
1665+\i doc/export_effective_stats-9.2.sql.sample_test
16661666 /*
16671667 * If you want the statistics of per-relation or per-column, please modify
16681668 * nspname, relname, and attname in 'WHERE' clause.
@@ -1737,11 +1737,11 @@ SELECT * FROM work_v;
17371737 s0 | sft0 | 1 | 10 | 0 | 0 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2,3,4,5,6,7,8,9,10} | (null) | (null)
17381738 (1 row)
17391739
1740-\! rm export_effective_stats-9.2.sql.sample_test
1740+\! rm doc/export_effective_stats-9.2.sql.sample_test
17411741 TRUNCATE dbms_stats.work;
17421742 -- No.16-2-9
1743-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
1744-\i export_effective_stats-9.2.sql.sample_test
1743+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
1744+\i doc/export_effective_stats-9.2.sql.sample_test
17451745 /*
17461746 * If you want the statistics of per-relation or per-column, please modify
17471747 * nspname, relname, and attname in 'WHERE' clause.
@@ -1820,11 +1820,11 @@ SELECT * FROM work_v;
18201820 s0 | st2 | 1 | 3 | 1 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2,3} | (null) | (null)
18211821 (5 rows)
18221822
1823-\! rm export_effective_stats-9.2.sql.sample_test
1823+\! rm doc/export_effective_stats-9.2.sql.sample_test
18241824 TRUNCATE dbms_stats.work;
18251825 -- No.16-2-10
1826-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
1827-\i export_effective_stats-9.2.sql.sample_test
1826+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
1827+\i doc/export_effective_stats-9.2.sql.sample_test
18281828 /*
18291829 * If you want the statistics of per-relation or per-column, please modify
18301830 * nspname, relname, and attname in 'WHERE' clause.
@@ -1902,11 +1902,11 @@ SELECT * FROM work_v;
19021902 s0 | st3 | 0 | 0 | 0 | 0 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
19031903 (4 rows)
19041904
1905-\! rm export_effective_stats-9.2.sql.sample_test
1905+\! rm doc/export_effective_stats-9.2.sql.sample_test
19061906 TRUNCATE dbms_stats.work;
19071907 -- No.16-2-11
1908-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' export_effective_stats-9.2.sql.sample > export_effective_stats-9.2.sql.sample_test
1909-\i export_effective_stats-9.2.sql.sample_test
1908+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' doc/export_effective_stats-9.2.sql.sample > doc/export_effective_stats-9.2.sql.sample_test
1909+\i doc/export_effective_stats-9.2.sql.sample_test
19101910 /*
19111911 * If you want the statistics of per-relation or per-column, please modify
19121912 * nspname, relname, and attname in 'WHERE' clause.
@@ -1980,7 +1980,7 @@ SELECT * FROM work_v;
19801980 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
19811981 (0 rows)
19821982
1983-\! rm export_effective_stats-9.2.sql.sample_test
1983+\! rm doc/export_effective_stats-9.2.sql.sample_test
19841984 TRUNCATE dbms_stats.work;
19851985 /*
19861986 * Stab function dbms_stats.import
--- a/output/ut_imp_exp-9.3.source
+++ b/output/ut_imp_exp-9.3.source
@@ -55,7 +55,7 @@ UPDATE dbms_stats._column_stats_locked SET
5555 stavalues3 = stavalues1,
5656 stavalues4 = stavalues4,
5757 stavalues5 = stavalues5;
58-\i export_plain_stats-9.3.sql.sample
58+\i doc/export_plain_stats-9.3.sql.sample
5959 /*
6060 * If you want the statistics of per-relation or per-column, please modify
6161 * nspname, relname, and attname in 'WHERE' clause.
@@ -163,8 +163,8 @@ SELECT * FROM work_v;
163163
164164 TRUNCATE dbms_stats.work;
165165 -- No.16-1-2
166-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
167-\i export_plain_stats-9.3.sql.sample_test
166+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
167+\i doc/export_plain_stats-9.3.sql.sample_test
168168 /*
169169 * If you want the statistics of per-relation or per-column, please modify
170170 * nspname, relname, and attname in 'WHERE' clause.
@@ -261,10 +261,10 @@ SELECT * FROM work_v;
261261 (16 rows)
262262
263263 TRUNCATE dbms_stats.work;
264-\! rm export_plain_stats-9.3.sql.sample_test
264+\! rm doc/export_plain_stats-9.3.sql.sample_test
265265 -- No.16-1-3
266-\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
267-\i export_plain_stats-9.3.sql.sample_test
266+\! sed '/ORDER/i\\ AND c.relname = '"\'st0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
267+\i doc/export_plain_stats-9.3.sql.sample_test
268268 /*
269269 * If you want the statistics of per-relation or per-column, please modify
270270 * nspname, relname, and attname in 'WHERE' clause.
@@ -353,10 +353,10 @@ SELECT * FROM work_v;
353353 (8 rows)
354354
355355 TRUNCATE dbms_stats.work;
356-\! rm export_plain_stats-9.3.sql.sample_test
356+\! rm doc/export_plain_stats-9.3.sql.sample_test
357357 -- No.16-1-4
358-\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
359-\i export_plain_stats-9.3.sql.sample_test
358+\! sed '/ORDER/i\\ AND c.relname = '"\'pg_toast_1262\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
359+\i doc/export_plain_stats-9.3.sql.sample_test
360360 /*
361361 * If you want the statistics of per-relation or per-column, please modify
362362 * nspname, relname, and attname in 'WHERE' clause.
@@ -437,10 +437,10 @@ SELECT * FROM work_v;
437437 (0 rows)
438438
439439 TRUNCATE dbms_stats.work;
440-\! rm export_plain_stats-9.3.sql.sample_test
440+\! rm doc/export_plain_stats-9.3.sql.sample_test
441441 -- No.16-1-5
442-\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
443-\i export_plain_stats-9.3.sql.sample_test
442+\! sed '/ORDER/i\\ AND c.relname = '"\'st0_idx\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
443+\i doc/export_plain_stats-9.3.sql.sample_test
444444 /*
445445 * If you want the statistics of per-relation or per-column, please modify
446446 * nspname, relname, and attname in 'WHERE' clause.
@@ -523,10 +523,10 @@ SELECT * FROM work_v;
523523 (2 rows)
524524
525525 TRUNCATE dbms_stats.work;
526-\! rm export_plain_stats-9.3.sql.sample_test
526+\! rm doc/export_plain_stats-9.3.sql.sample_test
527527 -- No.16-1-6
528-\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
529-\i export_plain_stats-9.3.sql.sample_test
528+\! sed '/ORDER/i\\ AND c.relname = '"\'ss0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
529+\i doc/export_plain_stats-9.3.sql.sample_test
530530 /*
531531 * If you want the statistics of per-relation or per-column, please modify
532532 * nspname, relname, and attname in 'WHERE' clause.
@@ -607,10 +607,10 @@ SELECT * FROM work_v;
607607 (0 rows)
608608
609609 TRUNCATE dbms_stats.work;
610-\! rm export_plain_stats-9.3.sql.sample_test
610+\! rm doc/export_plain_stats-9.3.sql.sample_test
611611 -- No.16-1-7
612-\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
613-\i export_plain_stats-9.3.sql.sample_test
612+\! sed '/ORDER/i\\ AND c.relname = '"\'sc0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
613+\i doc/export_plain_stats-9.3.sql.sample_test
614614 /*
615615 * If you want the statistics of per-relation or per-column, please modify
616616 * nspname, relname, and attname in 'WHERE' clause.
@@ -691,10 +691,10 @@ SELECT * FROM work_v;
691691 (0 rows)
692692
693693 TRUNCATE dbms_stats.work;
694-\! rm export_plain_stats-9.3.sql.sample_test
694+\! rm doc/export_plain_stats-9.3.sql.sample_test
695695 -- No.16-1-8
696-\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
697-\i export_plain_stats-9.3.sql.sample_test
696+\! sed '/ORDER/i\\ AND c.relname = '"\'sft0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
697+\i doc/export_plain_stats-9.3.sql.sample_test
698698 /*
699699 * If you want the statistics of per-relation or per-column, please modify
700700 * nspname, relname, and attname in 'WHERE' clause.
@@ -776,10 +776,10 @@ SELECT * FROM work_v;
776776 (1 row)
777777
778778 TRUNCATE dbms_stats.work;
779-\! rm export_plain_stats-9.3.sql.sample_test
779+\! rm doc/export_plain_stats-9.3.sql.sample_test
780780 -- No.16-1-9
781-\! sed '/ORDER/i\\ AND c.relname = '"\'smv0\'" export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
782-\i export_plain_stats-9.3.sql.sample_test
781+\! sed '/ORDER/i\\ AND c.relname = '"\'smv0\'" doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
782+\i doc/export_plain_stats-9.3.sql.sample_test
783783 /*
784784 * If you want the statistics of per-relation or per-column, please modify
785785 * nspname, relname, and attname in 'WHERE' clause.
@@ -863,10 +863,10 @@ SELECT * FROM work_v;
863863 (3 rows)
864864
865865 TRUNCATE dbms_stats.work;
866-\! rm export_plain_stats-9.3.sql.sample_test
866+\! rm doc/export_plain_stats-9.3.sql.sample_test
867867 -- No.16-1-10
868-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
869-\i export_plain_stats-9.3.sql.sample_test
868+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname = '\'id\' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
869+\i doc/export_plain_stats-9.3.sql.sample_test
870870 /*
871871 * If you want the statistics of per-relation or per-column, please modify
872872 * nspname, relname, and attname in 'WHERE' clause.
@@ -953,10 +953,10 @@ SELECT * FROM work_v;
953953 (6 rows)
954954
955955 TRUNCATE dbms_stats.work;
956-\! rm export_plain_stats-9.3.sql.sample_test
956+\! rm doc/export_plain_stats-9.3.sql.sample_test
957957 -- No.16-1-11
958-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
959-\i export_plain_stats-9.3.sql.sample_test
958+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
959+\i doc/export_plain_stats-9.3.sql.sample_test
960960 /*
961961 * If you want the statistics of per-relation or per-column, please modify
962962 * nspname, relname, and attname in 'WHERE' clause.
@@ -1041,10 +1041,10 @@ SELECT * FROM work_v;
10411041 (4 rows)
10421042
10431043 TRUNCATE dbms_stats.work;
1044-\! rm export_plain_stats-9.3.sql.sample_test
1044+\! rm doc/export_plain_stats-9.3.sql.sample_test
10451045 -- No.16-1-12
1046-\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' export_plain_stats-9.3.sql.sample > export_plain_stats-9.3.sql.sample_test
1047-\i export_plain_stats-9.3.sql.sample_test
1046+\! sed '/ORDER/i\\ AND n2.nspname = '"\'s1\'"' AND c.relname IS NULL' doc/export_plain_stats-9.3.sql.sample > doc/export_plain_stats-9.3.sql.sample_test
1047+\i doc/export_plain_stats-9.3.sql.sample_test
10481048 /*
10491049 * If you want the statistics of per-relation or per-column, please modify
10501050 * nspname, relname, and attname in 'WHERE' clause.
@@ -1125,7 +1125,7 @@ SELECT * FROM work_v;
11251125 (0 rows)
11261126
11271127 TRUNCATE dbms_stats.work;
1128-\! rm export_plain_stats-9.3.sql.sample_test
1128+\! rm doc/export_plain_stats-9.3.sql.sample_test
11291129 /*
11301130 * No.16-2 export_effective_stats-9.3.sql.sample
11311131 */
@@ -1167,7 +1167,7 @@ UPDATE dbms_stats._column_stats_locked
11671167 NULL, NULL, NULL, NULL, NULL,
11681168 NULL, NULL, NULL, NULL, NULL)
11691169 WHERE starelid = 's0.st0'::regclass;
1170-\i export_effective_stats-9.3.sql.sample
1170+\i doc/export_effective_stats-9.3.sql.sample
11711171 /*
11721172 * If you want the statistics of per-relation or per-column, please modify
11731173 * nspname, relname, and attname in 'WHERE' clause.
@@ -1269,8 +1269,8 @@ SELECT * FROM work_v;
12691269
12701270 TRUNCATE dbms_stats.work;
12711271 -- No.16-2-2
1272-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
1273-\i export_effective_stats-9.3.sql.sample_test
1272+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
1273+\i doc/export_effective_stats-9.3.sql.sample_test
12741274 /*
12751275 * If you want the statistics of per-relation or per-column, please modify
12761276 * nspname, relname, and attname in 'WHERE' clause.
@@ -1360,11 +1360,11 @@ SELECT * FROM work_v;
13601360 s0 | st3 | 0 | 0 | 0 | 0 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
13611361 (16 rows)
13621362
1363-\! rm export_effective_stats-9.3.sql.sample_test
1363+\! rm doc/export_effective_stats-9.3.sql.sample_test
13641364 TRUNCATE dbms_stats.work;
13651365 -- No.16-2-3
1366-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
1367-\i export_effective_stats-9.3.sql.sample_test
1366+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
1367+\i doc/export_effective_stats-9.3.sql.sample_test
13681368 /*
13691369 * If you want the statistics of per-relation or per-column, please modify
13701370 * nspname, relname, and attname in 'WHERE' clause.
@@ -1446,11 +1446,11 @@ SELECT * FROM work_v;
14461446 s1 | st0 | 1 | 4 | 1 | 1 | num | pg_catalog | int4 | -1 | f | -2 | -2 | -2 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-2,22} | {-2,23} | {-2,24} | {-2,21} | {-2,25} | (null) | (null) | {15,25,35,45} | (null) | (null)
14471447 (8 rows)
14481448
1449-\! rm export_effective_stats-9.3.sql.sample_test
1449+\! rm doc/export_effective_stats-9.3.sql.sample_test
14501450 TRUNCATE dbms_stats.work;
14511451 -- No.16-2-4
1452-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
1453-\i export_effective_stats-9.3.sql.sample_test
1452+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'pg_toast_1262\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
1453+\i doc/export_effective_stats-9.3.sql.sample_test
14541454 /*
14551455 * If you want the statistics of per-relation or per-column, please modify
14561456 * nspname, relname, and attname in 'WHERE' clause.
@@ -1524,11 +1524,11 @@ SELECT * FROM work_v;
15241524 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
15251525 (0 rows)
15261526
1527-\! rm export_effective_stats-9.3.sql.sample_test
1527+\! rm doc/export_effective_stats-9.3.sql.sample_test
15281528 TRUNCATE dbms_stats.work;
15291529 -- No.16-2-5
1530-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
1531-\i export_effective_stats-9.3.sql.sample_test
1530+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'st0_idx\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
1531+\i doc/export_effective_stats-9.3.sql.sample_test
15321532 /*
15331533 * If you want the statistics of per-relation or per-column, please modify
15341534 * nspname, relname, and attname in 'WHERE' clause.
@@ -1604,11 +1604,11 @@ SELECT * FROM work_v;
16041604 s0 | st0_idx | 2 | 2 | 0 | 2 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
16051605 (2 rows)
16061606
1607-\! rm export_effective_stats-9.3.sql.sample_test
1607+\! rm doc/export_effective_stats-9.3.sql.sample_test
16081608 TRUNCATE dbms_stats.work;
16091609 -- No.16-2-6
1610-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
1611-\i export_effective_stats-9.3.sql.sample_test
1610+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'ss0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
1611+\i doc/export_effective_stats-9.3.sql.sample_test
16121612 /*
16131613 * If you want the statistics of per-relation or per-column, please modify
16141614 * nspname, relname, and attname in 'WHERE' clause.
@@ -1682,11 +1682,11 @@ SELECT * FROM work_v;
16821682 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
16831683 (0 rows)
16841684
1685-\! rm export_effective_stats-9.3.sql.sample_test
1685+\! rm doc/export_effective_stats-9.3.sql.sample_test
16861686 TRUNCATE dbms_stats.work;
16871687 -- No.16-2-7
1688-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
1689-\i export_effective_stats-9.3.sql.sample_test
1688+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sc0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
1689+\i doc/export_effective_stats-9.3.sql.sample_test
16901690 /*
16911691 * If you want the statistics of per-relation or per-column, please modify
16921692 * nspname, relname, and attname in 'WHERE' clause.
@@ -1760,11 +1760,11 @@ SELECT * FROM work_v;
17601760 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
17611761 (0 rows)
17621762
1763-\! rm export_effective_stats-9.3.sql.sample_test
1763+\! rm doc/export_effective_stats-9.3.sql.sample_test
17641764 TRUNCATE dbms_stats.work;
17651765 -- No.16-2-8
1766-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
1767-\i export_effective_stats-9.3.sql.sample_test
1766+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'sft0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
1767+\i doc/export_effective_stats-9.3.sql.sample_test
17681768 /*
17691769 * If you want the statistics of per-relation or per-column, please modify
17701770 * nspname, relname, and attname in 'WHERE' clause.
@@ -1839,11 +1839,11 @@ SELECT * FROM work_v;
18391839 s0 | sft0 | 1 | 10 | 0 | 0 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2,3,4,5,6,7,8,9,10} | (null) | (null)
18401840 (1 row)
18411841
1842-\! rm export_effective_stats-9.3.sql.sample_test
1842+\! rm doc/export_effective_stats-9.3.sql.sample_test
18431843 TRUNCATE dbms_stats.work;
18441844 -- No.16-2-9
1845-\! sed '/ORDER/i\\ WHERE cl.relname = '"\'smv0\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
1846-\i export_effective_stats-9.3.sql.sample_test
1845+\! sed '/ORDER/i\\ WHERE cl.relname = '"\'smv0\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
1846+\i doc/export_effective_stats-9.3.sql.sample_test
18471847 /*
18481848 * If you want the statistics of per-relation or per-column, please modify
18491849 * nspname, relname, and attname in 'WHERE' clause.
@@ -1920,11 +1920,11 @@ SELECT * FROM work_v;
19201920 s0 | smv0 | 1 | 2 | 1 | 1 | txt | pg_catalog | text | -1 | f | -3 | -3 | -3 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-3,22} | {-3,23} | {-3,24} | {-3,21} | {-3,25} | (null) | (null) | {1,test} | (null) | (null)
19211921 (3 rows)
19221922
1923-\! rm export_effective_stats-9.3.sql.sample_test
1923+\! rm doc/export_effective_stats-9.3.sql.sample_test
19241924 TRUNCATE dbms_stats.work;
19251925 -- No.16-2-10
1926-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
1927-\i export_effective_stats-9.3.sql.sample_test
1926+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname = '"\'id\'" doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
1927+\i doc/export_effective_stats-9.3.sql.sample_test
19281928 /*
19291929 * If you want the statistics of per-relation or per-column, please modify
19301930 * nspname, relname, and attname in 'WHERE' clause.
@@ -2004,11 +2004,11 @@ SELECT * FROM work_v;
20042004 s0 | st2 | 1 | 3 | 1 | 1 | id | pg_catalog | int4 | -1 | f | -1 | -1 | -1 | 2 | 3 | 4 | 1 | 5 | 22 | 23 | 24 | 21 | 25 | {-1,22} | {-1,23} | {-1,24} | {-1,21} | {-1,25} | (null) | (null) | {1,2,3} | (null) | (null)
20052005 (6 rows)
20062006
2007-\! rm export_effective_stats-9.3.sql.sample_test
2007+\! rm doc/export_effective_stats-9.3.sql.sample_test
20082008 TRUNCATE dbms_stats.work;
20092009 -- No.16-2-11
2010-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
2011-\i export_effective_stats-9.3.sql.sample_test
2010+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND a.attname IS NULL' doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
2011+\i doc/export_effective_stats-9.3.sql.sample_test
20122012 /*
20132013 * If you want the statistics of per-relation or per-column, please modify
20142014 * nspname, relname, and attname in 'WHERE' clause.
@@ -2086,11 +2086,11 @@ SELECT * FROM work_v;
20862086 s0 | st3 | 0 | 0 | 0 | 0 | | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null) | (null)
20872087 (4 rows)
20882088
2089-\! rm export_effective_stats-9.3.sql.sample_test
2089+\! rm doc/export_effective_stats-9.3.sql.sample_test
20902090 TRUNCATE dbms_stats.work;
20912091 -- No.16-2-12
2092-\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' export_effective_stats-9.3.sql.sample > export_effective_stats-9.3.sql.sample_test
2093-\i export_effective_stats-9.3.sql.sample_test
2092+\! sed '/ORDER/i\\ WHERE n2.nspname = '"\'s0\'"' AND cl.relname IS NULL' doc/export_effective_stats-9.3.sql.sample > doc/export_effective_stats-9.3.sql.sample_test
2093+\i doc/export_effective_stats-9.3.sql.sample_test
20942094 /*
20952095 * If you want the statistics of per-relation or per-column, please modify
20962096 * nspname, relname, and attname in 'WHERE' clause.
@@ -2164,7 +2164,7 @@ SELECT * FROM work_v;
21642164 ---------+---------+----------+-----------+---------------+----------+---------+---------------------+---------+-----------+------------+-------------+----------+-------------+----------+----------+----------+----------+----------+--------+--------+--------+--------+--------+-------------+-------------+-------------+-------------+-------------+------------+------------+------------+------------+------------
21652165 (0 rows)
21662166
2167-\! rm export_effective_stats-9.3.sql.sample_test
2167+\! rm doc/export_effective_stats-9.3.sql.sample_test
21682168 TRUNCATE dbms_stats.work;
21692169 /*
21702170 * Stab function dbms_stats.import