Use pg_available_extensions() instead of pg_pltemplate for postgres 13 compatibility

perseas / Pyrseas

Provides utilities for Postgres database schema versioning.

https://perseas.github.io/

BSD 3-Clause "New" or "Revised" License

395 stars 67 forks source link

Closed joshcurtis closed 3 years ago

joshcurtis commented 3 years ago

See #226

pg_pltemplate was removed in postgres 13. We can query from pg_available_extensions() and join with pg_language to find out which language extensions are installed. https://www.postgresql.org/docs/13/release-13.html#id-1.11.6.7.5.14