Test module
An extension or test intended for testing PostgreSQL and/or to serve as example code
A test module is an extension and/or set of SQL tests which is primarily or entirely intended for testing PostgreSQL and/or to serve as example code.
Test modules are located (from PostgreSQL 9.5 onwards) in the source code directory src/test/modules/. They do not form part of normal PostgreSQL distributions or packages and are intended for use by people working with the source code. Prior to PostgreSQL 9.5, a few test modules were included as contrib modules.
Available test modules
As of PostgreSQL 13, following modules exist:
- brin
- commit_ts
- dummy_index_am
- dummy_seclabel
- snapshot_too_old
- test_bloomfilter
- test_ddl_deparse
- test_extensions
- test_ginpostinglist
- test_integerset
- test_misc
- test_parser
- test_pg_dump
- test_predtest
- test_rbtree
- test_rls_hooks
- test_shm_mq
- unsafe_tests
- worker_spi
Change history
- PostgreSQL 13
dummy_index_ammodule added (commit 640c1986)test_ginpostinglistmodule added (commit bde7493d)
- PostgreSQL 12
test_integersetmodule added (commit df816f6a)test_miscmodule added (commit 121e3cee)unsafe_testsmodule added (commit c91504b9)
- PostgreSQL 11
test_bloomfiltermodule added (commit 51bc2717)test_predtestmodule added (commit 44468f49)test_rbtreemodule added (commit 610bbdd8)
- PostgreSQL 9.6
snapshot_too_oldmodule added (commit 848ef42b)test_extensionsmodule added (commit b67aaf21)test_pg_dumpmodule added (commit 6bd356c3)
- PostgreSQL 9.5
brinmodule added (commit 672e3ec0)commit_tsmodule added (commit 73c986ad)test_ddl_deparsemodule added (commit b488c580)test_rls_hooksmodule added (commit 0bf22e0c)- Following former contrib modules converted to test modules (commit 22dfd116):
References
- Source code README: README