Contents

-- $Header$

DROP TABLE pgpool_catalog.dist_def;
DROP TABLE pgpool_catalog.replicate_def;
DROP TABLE pgpool_catalog.query_cache;
DROP SCHEMA pgpool_catalog;


CREATE SCHEMA pgpool_catalog;

CREATE TABLE pgpool_catalog.dist_def(
	dbname TEXT,
	schema_name TEXT,
	table_name TEXT,
	col_name TEXT NOT NULL CHECK (col_name = ANY (col_list)),
	col_list TEXT[] NOT NULL,
	type_list TEXT[] NOT NULL,
	dist_def_func TEXT NOT NULL,
	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,
	value bytea,
	dbname TEXT,
	create_time TIMESTAMP WITH TIME ZONE,
	PRIMARY KEY(hash, dbname)
);

Version data entries

12 entries across 12 versions & 1 rubygems

Version	Path
prestogres-0.4.8	pgpool2/sql/system_db.sql
prestogres-0.4.7	pgpool2/sql/system_db.sql
prestogres-0.4.6	pgpool2/sql/system_db.sql
prestogres-0.4.5	pgpool2/sql/system_db.sql
prestogres-0.4.4	pgpool2/sql/system_db.sql
prestogres-0.4.3	pgpool2/sql/system_db.sql
prestogres-0.4.2	pgpool2/sql/system_db.sql
prestogres-0.4.1	pgpool2/sql/system_db.sql
prestogres-0.4.0	pgpool2/sql/system_db.sql
prestogres-0.3.0	pgpool2/sql/system_db.sql
prestogres-0.2.0	pgpool2/sql/system_db.sql
prestogres-0.1.0	pgpool2/sql/system_db.sql