diff options
Diffstat (limited to 'contrib/pgstattuple')
| -rw-r--r-- | contrib/pgstattuple/.gitignore | 1 | ||||
| -rw-r--r-- | contrib/pgstattuple/Makefile | 11 | ||||
| -rw-r--r-- | contrib/pgstattuple/pgstattuple--1.0.sql (renamed from contrib/pgstattuple/pgstattuple.sql.in) | 5 | ||||
| -rw-r--r-- | contrib/pgstattuple/pgstattuple--unpackaged--1.0.sql | 6 | ||||
| -rw-r--r-- | contrib/pgstattuple/pgstattuple.control | 5 | ||||
| -rw-r--r-- | contrib/pgstattuple/uninstall_pgstattuple.sql | 9 |
6 files changed, 15 insertions, 22 deletions
diff --git a/contrib/pgstattuple/.gitignore b/contrib/pgstattuple/.gitignore deleted file mode 100644 index 69b22b64cd..0000000000 --- a/contrib/pgstattuple/.gitignore +++ /dev/null @@ -1 +0,0 @@ -/pgstattuple.sql diff --git a/contrib/pgstattuple/Makefile b/contrib/pgstattuple/Makefile index 33386cdf17..13b87090ee 100644 --- a/contrib/pgstattuple/Makefile +++ b/contrib/pgstattuple/Makefile @@ -1,15 +1,10 @@ -#------------------------------------------------------------------------- -# -# pgstattuple Makefile -# # contrib/pgstattuple/Makefile -# -#------------------------------------------------------------------------- MODULE_big = pgstattuple OBJS = pgstattuple.o pgstatindex.o -DATA_built = pgstattuple.sql -DATA = uninstall_pgstattuple.sql + +EXTENSION = pgstattuple +DATA = pgstattuple--1.0.sql pgstattuple--unpackaged--1.0.sql ifdef USE_PGXS PG_CONFIG = pg_config diff --git a/contrib/pgstattuple/pgstattuple.sql.in b/contrib/pgstattuple/pgstattuple--1.0.sql index 6a09136596..84b91dda0a 100644 --- a/contrib/pgstattuple/pgstattuple.sql.in +++ b/contrib/pgstattuple/pgstattuple--1.0.sql @@ -1,7 +1,4 @@ -/* contrib/pgstattuple/pgstattuple.sql.in */ - --- Adjust this setting to control where the objects get created. -SET search_path = public; +/* contrib/pgstattuple/pgstattuple--1.0.sql */ CREATE OR REPLACE FUNCTION pgstattuple(IN relname text, OUT table_len BIGINT, -- physical table length in bytes diff --git a/contrib/pgstattuple/pgstattuple--unpackaged--1.0.sql b/contrib/pgstattuple/pgstattuple--unpackaged--1.0.sql new file mode 100644 index 0000000000..3cfb8db534 --- /dev/null +++ b/contrib/pgstattuple/pgstattuple--unpackaged--1.0.sql @@ -0,0 +1,6 @@ +/* contrib/pgstattuple/pgstattuple--unpackaged--1.0.sql */ + +ALTER EXTENSION pgstattuple ADD function pgstattuple(text); +ALTER EXTENSION pgstattuple ADD function pgstattuple(oid); +ALTER EXTENSION pgstattuple ADD function pgstatindex(text); +ALTER EXTENSION pgstattuple ADD function pg_relpages(text); diff --git a/contrib/pgstattuple/pgstattuple.control b/contrib/pgstattuple/pgstattuple.control new file mode 100644 index 0000000000..7b5129b2f2 --- /dev/null +++ b/contrib/pgstattuple/pgstattuple.control @@ -0,0 +1,5 @@ +# pgstattuple extension +comment = 'show tuple-level statistics' +default_version = '1.0' +module_pathname = '$libdir/pgstattuple' +relocatable = true diff --git a/contrib/pgstattuple/uninstall_pgstattuple.sql b/contrib/pgstattuple/uninstall_pgstattuple.sql deleted file mode 100644 index 29eac40f29..0000000000 --- a/contrib/pgstattuple/uninstall_pgstattuple.sql +++ /dev/null @@ -1,9 +0,0 @@ -/* contrib/pgstattuple/uninstall_pgstattuple.sql */ - --- Adjust this setting to control where the objects get dropped. -SET search_path = public; - -DROP FUNCTION pgstattuple(text); -DROP FUNCTION pgstattuple(oid); -DROP FUNCTION pgstatindex(text); -DROP FUNCTION pg_relpages(text); |