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
timetravelexample extension removed(commit 2d10defa)
- PostgreSQL 9.1
- example functions converted to
extensions(commit 629b3af2)
- example functions converted to
- PostgreSQL 8.3
preprocessorsubdirectory removed (commit 50eed107)
- PostgreSQL 6.5
- PostgreSQL 6.3
insert_usernamefunctions added (commit 629e8951)
- PostgreSQL 6.2
References
- PostgreSQL documentation: spi