pgpool2.git / summary / log / commit / refs

commit    98396e7f4307a1e5938cb09f050bc5d9230077fd
Author:   Yoshiharu Mori <y-mori at sraoss.co.jp>
Date:     Fri Nov 09 04:56:00 2007 +0000

    ADD "replicate_def" table in "pgpool_catalog" schema


 sql/system_db.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/sql/system_db.sql b/sql/system_db.sql
index 404674b32..f1c7f5c26 100644
--- a/sql/system_db.sql
+++ b/sql/system_db.sql
@@ -18,6 +18,15 @@ CREATE TABLE pgpool_catalog.dist_def(
 	PRIMARY KEY (dbname,schema_name,table_name)
 );
 
+CREATE TABLE pgpool_catalog.replicate_def(
+	dbname TEXT,
+	schema_name TEXT,
+	table_name TEXT,
+	col_list TEXT[] NOT NULL,
+	type_list TEXT[] NOT NULL,
+	PRIMARY KEY (dbname,schema_name,table_name)
+);
+
 CREATE TABLE pgpool_catalog.query_cache (
 	hash TEXT,
 	query TEXT,


[parent: e6ba6d69b58f]