pgpool2.git / summary / log / commit / refs
commit 8ae8df84d2f4fccd986d382cfc8d520c2baa5b0c
Author: Yoshiharu Mori <y-mori at sraoss.co.jp>
Date: Fri Nov 09 06:09:36 2007 +0000
ADD Sample SQL file
sample/replicate_def_pgbench.sql | 18 ++++++++++++++++++
1 file changed, 18 insertions(+)
diff --git a/sample/replicate_def_pgbench.sql b/sample/replicate_def_pgbench.sql
new file mode 100644
index 000000000..a38fec203
--- /dev/null
+++ b/sample/replicate_def_pgbench.sql
@@ -0,0 +1,18 @@
+-- $Header$
+
+INSERT INTO pgpool_catalog.replicate_def VALUES (
+ 'bench_parallel',
+ 'public',
+ 'branches',
+ ARRAY['bid', 'bbalance', 'filler'],
+ ARRAY['integer', 'integer', 'character(88)']
+);
+
+INSERT INTO pgpool_catalog.dist_def VALUES (
+ 'bench_parallel',
+ 'public',
+ 'tellers',
+ ARRAY['tid', 'bid', 'tbalance', 'filler'],
+ ARRAY['integer', 'integer', 'integer', 'character(84)']
+);
+
[parent: 98396e7f4307]