Copyright (c) 2015-2016, Postgres Professional

Portions Copyright (c) 1996-2016, PostgreSQL Global Development Group

Portions Copyright (c) 1994, The Regents of the University of California

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

OBJS = src/init.o src/relation_info.o src/utils.o src/partition_filter.o\

src/runtimeappend.o src/runtime_merge_append.o src/pg_pathman.o src/rangeset.o\

src/pl_funcs.o src/pl_range_funcs.o src/pl_hash_funcs.o src/pathman_workers.o\

src/hooks.o src/nodes_common.o src/xact_handling.o src/copy_stmt_hooking.o\

src/pg_compat.o$(WIN32RES)

src/hooks.o src/nodes_common.o src/xact_handling.o src/utility_stmt_hooking.o\

src/planner_tree_modification.o src/debug_print.o src/pg_compat.o\

src/partition_creation.o$(WIN32RES)

EXTENSION = pg_pathman

EXTVERSION = 1.1

EXTVERSION = 1.2

DATA_built = pg_pathman--$(EXTVERSION).sql

DATA = pg_pathman--1.0.sql pg_pathman--1.0--1.1.sql

DATA = pg_pathman--1.0.sql\

pg_pathman--1.0--1.1.sql\

pg_pathman--1.1.sql\

pg_pathman--1.1--1.2.sql

PGFILEDESC = "pg_pathman - partitioning tool"

REGRESS = pathman_basic\

pathman_foreign_keys\

pathman_permissions\

pathman_rowmarks\

pathman_calamity

EXTRA_REGRESS_OPTS=--temp-config=$(top_srcdir)/$(subdir)/conf.add

EXTRA_CLEAN = pg_pathman--$(EXTVERSION).sql ./isolation_output

create_hash_partitions(relation REGCLASS,

attributeTEXT,

partitions_countINTEGER,

partition_nameTEXT DEFAULTNULL,

partition_dataBOOLEAN DEFAULT TRUE)

Performs HASH partitioning for`relation` by integer key`attribute`. The`partitions_count` parameter specifies the number of partitions to create; it cannot be changed afterwards. If`partition_data` is`true` then all the data will be automatically copied from the parent table to partitions. Note that data migration may took a while to finish and the table will be locked until transaction commits. See`partition_table_concurrently()` for a lock-free way to migrate data. Partition creation callback is invoked for each partition if set beforehand (see`set_part_init_callback()`).

Performs HASH partitioning for`relation` by integer key`attribute`. The`partitions_count` parameter specifies the number of partitions to create; it cannot be changed afterwards. If`partition_data` is`true` then all the data will be automatically copied from the parent table to partitions. Note that data migration may took a while to finish and the table will be locked until transaction commits. See`partition_table_concurrently()` for a lock-free way to migrate data. Partition creation callback is invoked for each partition if set beforehand (see`set_init_callback()`).

create_range_partitions(relation REGCLASS,

Same as above, but for a RANGE-partitioned table.

replace_hash_partition(old_partition REGCLASS,

new_partition REGCLASS,

lock_parent BOOL DEFAULT TRUE)

Replaces specified partition of HASH-partitioned table with another table. The`lock_parent` parameter will prevent any INSERT/UPDATE/ALTER TABLE queries to parent table.

split_range_partition(partition REGCLASS,

split_value ANYELEMENT,

}

set_spawn_using_bgw(relation REGCLASS, valueBOOLEAN)

When INSERTing new data beyond the partitioning range, use SpawnPartitionsWorker to create new partitions in a separate transaction.

partrel REGCLASSNOT NULLPRIMARY KEY,

attnameTEXTNOT NULL,

parttypeINTEGERNOT NULL,

range_intervalTEXT,

CHECK (parttypeIN (1,2))/* check for allowed part types*/ );

range_intervalTEXT);

This table stores a list of partitioned tables.

CREATETABLEIF NOT EXISTS pathman_config_params (

partrel REGCLASSNOT NULLPRIMARY KEY,

enable_parentBOOLEANNOT NULL DEFAULT TRUE,

autoBOOLEANNOT NULL DEFAULT TRUE,

init_callback REGPROCEDURENOT NULL DEFAULT0);

partrel REGCLASSNOT NULLPRIMARY KEY,

enable_parentBOOLEANNOT NULL DEFAULT TRUE,

autoBOOLEANNOT NULL DEFAULT TRUE,

init_callback REGPROCEDURENOT NULL DEFAULT0,

spawn_using_bgwBOOLEANNOT NULL DEFAULT FALSE);

This table stores optional parameters which override standard behavior.