No description, website, or topics provided.
PLpgSQL Makefile
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
doc
sql
test
.gitignore
.template
CHANGELOG
LICENSE.md
META.json
Makefile
README.md
range_partitioning.control

README.md

Range Partitioning

PGXN version

Create and manage tables which will be partitioned by static ranges. The partitioning column can be any type for which there is a corresponding range type, even if that range type was user-created.

USAGE

For function documentation and examples, see the range_partitioning.md file.

INSTALLATION

Requirements: PostgreSQL 9.2 or greater.

In the directory where you downloaded range_partitioning, run

make install

Log into PostgreSQL.

CREATE EXTENSION range_partitioning;

or

CREATE EXTENSION range_partitioning SCHEMA my_schema;

A role named range_partitioning is created. Grant that role to any user who needs to create or remove partitions.

UPGRADE

Run "make install" same as above to put the script files and libraries in place. Then run the following in PostgreSQL itself:

ALTER EXTENSION range_partitioning UPDATE TO '<latest version>';