spi
A contrib module providing examples of Server Programming Interface (SPI) usage
spi
is a contrib module
providing examples of Server Programming Interface
(SPI
) usage.
spi
was added in PostgreSQL 6.2 (initial commit b6f348cd).
As of PostgreSQL 12, it contains following example extensions:
refinc
- functions for implementing referential integrityautoinc
-functions for autoincrementing fieldsinsert_username
- functions for associating table changes with usersmoddatetime
- functions for tracking last modification time
These extensions are primarily intended to provide examples of SPI usage (particularly refinc
, whose functionality has long since been included in core PostgreSQL).
Change history
- PostgreSQL 12
timetravel
example extension removed(commit 2d10defa)
- PostgreSQL 9.1
- example functions converted to
extensions
(commit 629b3af2)
- example functions converted to
- PostgreSQL 8.3
preprocessor
subdirectory removed (commit 50eed107)
- PostgreSQL 6.5
- PostgreSQL 6.3
insert_username
functions added (commit 629e8951)
- PostgreSQL 6.2
References
- PostgreSQL documentation: spi