Rearrange extension-related views as per recent discussion.
Tom Lane <tgl@sss.pgh.pa.us>
Rearrange extension-related views as per recent discussion. The original design of pg_available_extensions did not consider the possibility of version-specific control files. Split it into two views: pg_available_extensions shows information that is generic about an extension, while pg_available_extension_versions shows all available versions together with information that could be version-dependent. Also, add an SRF pg_extension_update_paths() to assist in checking that a collection of update scripts provide sane update path sequences.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +82 −8 |
| doc/src/sgml/extend.sgml | modified | +14 −0 |
| src/backend/catalog/system_views.sql | modified | +10 −4 |
| src/backend/commands/extension.c | modified | +391 −18 |
| src/bin/psql/tab-complete.c | modified | +1 −1 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.h | modified | +6 −2 |
| src/include/utils/builtins.h | modified | +2 −0 |
| src/test/regress/expected/rules.out | modified | +63 −62 |