1 -- $Header: /cvsroot/pgpool/pgpool-II/sql/system_db.sql,v 1.3 2008/04/09 07:01:27 y-asaba Exp $
3 DROP TABLE pgpool_catalog.dist_def;
4 DROP TABLE pgpool_catalog.replicate_def;
5 DROP TABLE pgpool_catalog.query_cache;
6 DROP SCHEMA pgpool_catalog;
9 CREATE SCHEMA pgpool_catalog;
11 CREATE TABLE pgpool_catalog.dist_def(
15 col_name TEXT NOT NULL CHECK (col_name = ANY (col_list)),
16 col_list TEXT[] NOT NULL,
17 type_list TEXT[] NOT NULL,
18 dist_def_func TEXT NOT NULL,
19 PRIMARY KEY (dbname,schema_name,table_name)
22 CREATE TABLE pgpool_catalog.replicate_def(
26 col_list TEXT[] NOT NULL,
27 type_list TEXT[] NOT NULL,
28 PRIMARY KEY (dbname,schema_name,table_name)
31 CREATE TABLE pgpool_catalog.query_cache (
36 create_time TIMESTAMP WITH TIME ZONE,
37 PRIMARY KEY(hash, dbname)