pgsql: Convert contrib modules to use the extension facility.

Convert contrib modules to use the extension facility.

This isn't fully tested as yet, in particular I'm not sure that the
"foo--unpackaged--1.0.sql" scripts are OK. But it's time to get some
buildfarm cycles on it.

sepgsql is not converted to an extension, mainly because it seems to
require a very nonstandard installation process.

Dimitri Fontaine and Tom Lane

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/629b3af27d5c2bc9d6e16b22b943ad651d4ecb56

Modified Files
--------------
contrib/adminpack/.gitignore | 1 -
contrib/adminpack/Makefile | 7 +-
contrib/adminpack/adminpack--1.0.sql | 50 +
contrib/adminpack/adminpack--unpackaged--1.0.sql | 10 +
contrib/adminpack/adminpack.control | 6 +
contrib/adminpack/adminpack.sql.in | 50 -
contrib/adminpack/uninstall_adminpack.sql | 10 -
contrib/btree_gin/.gitignore | 1 -
contrib/btree_gin/Makefile | 5 +-
contrib/btree_gin/btree_gin--1.0.sql | 686 +++++
contrib/btree_gin/btree_gin--unpackaged--1.0.sql | 116 +
contrib/btree_gin/btree_gin.control | 5 +
contrib/btree_gin/btree_gin.sql.in | 689 -----
contrib/btree_gin/expected/install_btree_gin.out | 4 +-
contrib/btree_gin/sql/install_btree_gin.sql | 6 +-
contrib/btree_gin/uninstall_btree_gin.sql | 98 -
contrib/btree_gist/.gitignore | 1 -
contrib/btree_gist/Makefile | 4 +-
contrib/btree_gist/btree_gist--1.0.sql | 1209 ++++++++
contrib/btree_gist/btree_gist--unpackaged--1.0.sql | 172 ++
contrib/btree_gist/btree_gist.control | 5 +
contrib/btree_gist/btree_gist.sql.in | 1212 --------
contrib/btree_gist/expected/init.out | 8 +-
contrib/btree_gist/sql/init.sql | 10 +-
contrib/btree_gist/uninstall_btree_gist.sql | 280 --
contrib/chkpass/.gitignore | 1 -
contrib/chkpass/Makefile | 6 +-
contrib/chkpass/chkpass--1.0.sql | 64 +
contrib/chkpass/chkpass--unpackaged--1.0.sql | 10 +
contrib/chkpass/chkpass.control | 5 +
contrib/chkpass/chkpass.sql.in | 67 -
contrib/chkpass/uninstall_chkpass.sql | 16 -
contrib/citext/.gitignore | 1 -
contrib/citext/Makefile | 6 +-
contrib/citext/citext--1.0.sql | 486 +++
contrib/citext/citext--unpackaged--1.0.sql | 76 +
contrib/citext/citext.control | 5 +
contrib/citext/citext.sql.in | 489 ---
contrib/citext/expected/citext.out | 7 +-
contrib/citext/expected/citext_1.out | 7 +-
contrib/citext/sql/citext.sql | 10 +-
contrib/citext/uninstall_citext.sql | 80 -
contrib/cube/.gitignore | 1 -
contrib/cube/Makefile | 5 +-
contrib/cube/cube--1.0.sql | 322 ++
contrib/cube/cube--unpackaged--1.0.sql | 53 +
contrib/cube/cube.control | 5 +
contrib/cube/cube.sql.in | 326 --
contrib/cube/expected/cube.out | 8 +-
contrib/cube/expected/cube_1.out | 8 +-
contrib/cube/expected/cube_2.out | 8 +-
contrib/cube/sql/cube.sql | 10 +-
contrib/cube/uninstall_cube.sql | 98 -
contrib/dblink/.gitignore | 1 -
contrib/dblink/Makefile | 8 +-
contrib/dblink/dblink--1.0.sql | 220 ++
contrib/dblink/dblink--unpackaged--1.0.sql | 43 +
contrib/dblink/dblink.control | 5 +
contrib/dblink/dblink.sql.in | 223 --
contrib/dblink/expected/dblink.out | 12 +-
contrib/dblink/sql/dblink.sql | 15 +-
contrib/dblink/uninstall_dblink.sql | 86 -
contrib/dict_int/.gitignore | 1 -
contrib/dict_int/Makefile | 6 +-
contrib/dict_int/dict_int--1.0.sql | 22 +
contrib/dict_int/dict_int--unpackaged--1.0.sql | 6 +
contrib/dict_int/dict_int.control | 5 +
contrib/dict_int/dict_int.sql.in | 25 -
contrib/dict_int/expected/dict_int.out | 8 +-
contrib/dict_int/sql/dict_int.sql | 10 +-
contrib/dict_int/uninstall_dict_int.sql | 12 -
contrib/dict_xsyn/.gitignore | 1 -
contrib/dict_xsyn/Makefile | 6 +-
contrib/dict_xsyn/dict_xsyn--1.0.sql | 22 +
contrib/dict_xsyn/dict_xsyn--unpackaged--1.0.sql | 6 +
contrib/dict_xsyn/dict_xsyn.control | 5 +
contrib/dict_xsyn/dict_xsyn.sql.in | 25 -
contrib/dict_xsyn/expected/dict_xsyn.out | 8 +-
contrib/dict_xsyn/sql/dict_xsyn.sql | 10 +-
contrib/dict_xsyn/uninstall_dict_xsyn.sql | 12 -
contrib/earthdistance/.gitignore | 1 -
contrib/earthdistance/Makefile | 6 +-
contrib/earthdistance/earthdistance--1.0.sql | 88 +
.../earthdistance--unpackaged--1.0.sql | 13 +
contrib/earthdistance/earthdistance.control | 6 +
contrib/earthdistance/earthdistance.sql.in | 93 -
contrib/earthdistance/expected/earthdistance.out | 9 +-
contrib/earthdistance/sql/earthdistance.sql | 12 +-
contrib/earthdistance/uninstall_earthdistance.sql | 26 -
contrib/fuzzystrmatch/.gitignore | 1 -
contrib/fuzzystrmatch/Makefile | 5 +-
contrib/fuzzystrmatch/fuzzystrmatch--1.0.sql | 41 +
.../fuzzystrmatch--unpackaged--1.0.sql | 12 +
contrib/fuzzystrmatch/fuzzystrmatch.control | 5 +
contrib/fuzzystrmatch/fuzzystrmatch.sql.in | 44 -
contrib/fuzzystrmatch/uninstall_fuzzystrmatch.sql | 24 -
contrib/hstore/.gitignore | 1 -
contrib/hstore/Makefile | 5 +-
contrib/hstore/expected/hstore.out | 10 +-
contrib/hstore/hstore--1.0.sql | 527 ++++
contrib/hstore/hstore--unpackaged--1.0.sql | 89 +
contrib/hstore/hstore.control | 5 +
contrib/hstore/hstore.sql.in | 530 ----
contrib/hstore/sql/hstore.sql | 10 +-
contrib/hstore/uninstall_hstore.sql | 86 -
contrib/intagg/Makefile | 3 +-
contrib/intagg/int_aggregate--1.0.sql | 32 +
contrib/intagg/int_aggregate--unpackaged--1.0.sql | 6 +
contrib/intagg/int_aggregate.control | 4 +
contrib/intagg/int_aggregate.sql | 35 -
contrib/intagg/uninstall_int_aggregate.sql | 12 -
contrib/intarray/.gitignore | 1 -
contrib/intarray/Makefile | 6 +-
contrib/intarray/_int.sql.in | 485 ---
contrib/intarray/expected/_int.out | 8 +-
contrib/intarray/intarray--1.0.sql | 482 +++
contrib/intarray/intarray--unpackaged--1.0.sql | 71 +
contrib/intarray/intarray.control | 5 +
contrib/intarray/sql/_int.sql | 10 +-
contrib/intarray/uninstall__int.sql | 128 -
contrib/isn/.gitignore | 1 -
contrib/isn/Makefile | 5 +-
contrib/isn/isn--1.0.sql | 3193 +++++++++++++++++++
contrib/isn/isn--unpackaged--1.0.sql | 461 +++
contrib/isn/isn.control | 5 +
contrib/isn/isn.sql.in | 3196 --------------------
contrib/isn/uninstall_isn.sql | 24 -
contrib/lo/.gitignore | 1 -
contrib/lo/Makefile | 5 +-
contrib/lo/lo--1.0.sql | 22 +
contrib/lo/lo--unpackaged--1.0.sql | 5 +
contrib/lo/lo.control | 5 +
contrib/lo/lo.sql.in | 25 -
contrib/lo/uninstall_lo.sql | 17 -
contrib/ltree/.gitignore | 1 -
contrib/ltree/Makefile | 8 +-
contrib/ltree/expected/ltree.out | 8 +-
contrib/ltree/ltree--1.0.sql | 869 ++++++
contrib/ltree/ltree--unpackaged--1.0.sql | 131 +
contrib/ltree/ltree.control | 5 +
contrib/ltree/ltree.sql.in | 872 ------
contrib/ltree/sql/ltree.sql | 10 +-
contrib/ltree/uninstall_ltree.sql | 240 --
contrib/pageinspect/.gitignore | 1 -
contrib/pageinspect/Makefile | 11 +-
contrib/pageinspect/pageinspect--1.0.sql | 104 +
.../pageinspect/pageinspect--unpackaged--1.0.sql | 10 +
contrib/pageinspect/pageinspect.control | 5 +
contrib/pageinspect/pageinspect.sql.in | 107 -
contrib/pageinspect/uninstall_pageinspect.sql | 13 -
contrib/pg_buffercache/.gitignore | 1 -
contrib/pg_buffercache/Makefile | 4 +-
contrib/pg_buffercache/pg_buffercache--1.0.sql | 17 +
.../pg_buffercache--unpackaged--1.0.sql | 4 +
contrib/pg_buffercache/pg_buffercache.control | 5 +
contrib/pg_buffercache/pg_buffercache.sql.in | 20 -
.../pg_buffercache/uninstall_pg_buffercache.sql | 8 -
contrib/pg_freespacemap/.gitignore | 1 -
contrib/pg_freespacemap/Makefile | 4 +-
contrib/pg_freespacemap/pg_freespacemap--1.0.sql | 22 +
.../pg_freespacemap--unpackaged--1.0.sql | 4 +
contrib/pg_freespacemap/pg_freespacemap.control | 5 +
contrib/pg_freespacemap/pg_freespacemap.sql.in | 26 -
.../pg_freespacemap/uninstall_pg_freespacemap.sql | 7 -
contrib/pg_stat_statements/.gitignore | 1 -
contrib/pg_stat_statements/Makefile | 5 +-
.../pg_stat_statements/pg_stat_statements--1.0.sql | 36 +
.../pg_stat_statements--unpackaged--1.0.sql | 5 +
.../pg_stat_statements/pg_stat_statements.control | 5 +
.../pg_stat_statements/pg_stat_statements.sql.in | 39 -
.../uninstall_pg_stat_statements.sql | 8 -
contrib/pg_test_fsync/Makefile | 3 -
contrib/pg_trgm/.gitignore | 1 -
contrib/pg_trgm/Makefile | 5 +-
contrib/pg_trgm/expected/pg_trgm.out | 8 +-
contrib/pg_trgm/pg_trgm--1.0.sql | 152 +
contrib/pg_trgm/pg_trgm--unpackaged--1.0.sql | 28 +
contrib/pg_trgm/pg_trgm.control | 5 +
contrib/pg_trgm/pg_trgm.sql.in | 155 -
contrib/pg_trgm/sql/pg_trgm.sql | 10 +-
contrib/pg_trgm/uninstall_pg_trgm.sql | 48 -
contrib/pg_upgrade/Makefile | 3 -
contrib/pg_upgrade_support/Makefile | 3 -
contrib/pgcrypto/.gitignore | 1 -
contrib/pgcrypto/Makefile | 9 +-
contrib/pgcrypto/expected/init.out | 8 +-
contrib/pgcrypto/pgcrypto--1.0.sql | 199 ++
contrib/pgcrypto/pgcrypto--unpackaged--1.0.sql | 35 +
contrib/pgcrypto/pgcrypto.control | 5 +
contrib/pgcrypto/pgcrypto.sql.in | 202 --
contrib/pgcrypto/sql/init.sql | 10 +-
contrib/pgcrypto/uninstall_pgcrypto.sql | 45 -
contrib/pgrowlocks/.gitignore | 1 -
contrib/pgrowlocks/Makefile | 11 +-
contrib/pgrowlocks/pgrowlocks--1.0.sql | 12 +
contrib/pgrowlocks/pgrowlocks--unpackaged--1.0.sql | 3 +
contrib/pgrowlocks/pgrowlocks.control | 5 +
contrib/pgrowlocks/pgrowlocks.sql.in | 15 -
contrib/pgrowlocks/uninstall_pgrowlocks.sql | 6 -
contrib/pgstattuple/.gitignore | 1 -
contrib/pgstattuple/Makefile | 11 +-
contrib/pgstattuple/pgstattuple--1.0.sql | 46 +
.../pgstattuple/pgstattuple--unpackaged--1.0.sql | 6 +
contrib/pgstattuple/pgstattuple.control | 5 +
contrib/pgstattuple/pgstattuple.sql.in | 49 -
contrib/pgstattuple/uninstall_pgstattuple.sql | 9 -
contrib/seg/.gitignore | 1 -
contrib/seg/Makefile | 6 +-
contrib/seg/expected/seg.out | 8 +-
contrib/seg/expected/seg_1.out | 8 +-
contrib/seg/seg--1.0.sql | 392 +++
contrib/seg/seg--unpackaged--1.0.sql | 51 +
contrib/seg/seg.control | 5 +
contrib/seg/seg.sql.in | 396 ---
contrib/seg/sql/seg.sql | 10 +-
contrib/seg/uninstall_seg.sql | 94 -
contrib/spi/.gitignore | 5 -
contrib/spi/Makefile | 10 +-
contrib/spi/autoinc--1.0.sql | 6 +
contrib/spi/autoinc--unpackaged--1.0.sql | 3 +
contrib/spi/autoinc.control | 5 +
contrib/spi/autoinc.sql.in | 9 -
contrib/spi/insert_username--1.0.sql | 6 +
contrib/spi/insert_username--unpackaged--1.0.sql | 3 +
contrib/spi/insert_username.control | 5 +
contrib/spi/insert_username.sql.in | 9 -
contrib/spi/moddatetime--1.0.sql | 6 +
contrib/spi/moddatetime--unpackaged--1.0.sql | 3 +
contrib/spi/moddatetime.control | 5 +
contrib/spi/moddatetime.sql.in | 9 -
contrib/spi/refint--1.0.sql | 11 +
contrib/spi/refint--unpackaged--1.0.sql | 4 +
contrib/spi/refint.control | 5 +
contrib/spi/refint.sql.in | 14 -
contrib/spi/timetravel--1.0.sql | 16 +
contrib/spi/timetravel--unpackaged--1.0.sql | 5 +
contrib/spi/timetravel.control | 5 +
contrib/spi/timetravel.sql.in | 19 -
contrib/sslinfo/.gitignore | 1 -
contrib/sslinfo/Makefile | 5 +-
contrib/sslinfo/sslinfo--1.0.sql | 37 +
contrib/sslinfo/sslinfo--unpackaged--1.0.sql | 11 +
contrib/sslinfo/sslinfo.control | 5 +
contrib/sslinfo/sslinfo.sql.in | 40 -
contrib/sslinfo/uninstall_sslinfo.sql | 14 -
contrib/tablefunc/.gitignore | 1 -
contrib/tablefunc/Makefile | 6 +-
contrib/tablefunc/expected/tablefunc.out | 8 +-
contrib/tablefunc/sql/tablefunc.sql | 10 +-
contrib/tablefunc/tablefunc--1.0.sql | 85 +
contrib/tablefunc/tablefunc--unpackaged--1.0.sql | 16 +
contrib/tablefunc/tablefunc.control | 5 +
contrib/tablefunc/tablefunc.sql.in | 88 -
contrib/tablefunc/uninstall_tablefunc.sql | 32 -
contrib/test_parser/.gitignore | 1 -
contrib/test_parser/Makefile | 6 +-
contrib/test_parser/expected/test_parser.out | 8 +-
contrib/test_parser/sql/test_parser.sql | 10 +-
contrib/test_parser/test_parser--1.0.sql | 29 +
.../test_parser/test_parser--unpackaged--1.0.sql | 7 +
contrib/test_parser/test_parser.control | 5 +
contrib/test_parser/test_parser.sql.in | 32 -
contrib/test_parser/uninstall_test_parser.sql | 14 -
contrib/tsearch2/.gitignore | 1 -
contrib/tsearch2/Makefile | 6 +-
contrib/tsearch2/expected/tsearch2.out | 8 +-
contrib/tsearch2/expected/tsearch2_1.out | 8 +-
contrib/tsearch2/sql/tsearch2.sql | 10 +-
contrib/tsearch2/tsearch2--1.0.sql | 573 ++++
contrib/tsearch2/tsearch2--unpackaged--1.0.sql | 100 +
contrib/tsearch2/tsearch2.control | 5 +
contrib/tsearch2/tsearch2.sql.in | 576 ----
contrib/tsearch2/uninstall_tsearch2.sql | 96 -
contrib/unaccent/.gitignore | 1 -
contrib/unaccent/Makefile | 5 +-
contrib/unaccent/expected/unaccent.out | 4 +-
contrib/unaccent/sql/unaccent.sql | 6 +-
contrib/unaccent/unaccent--1.0.sql | 31 +
contrib/unaccent/unaccent--unpackaged--1.0.sql | 8 +
contrib/unaccent/unaccent.control | 5 +
contrib/unaccent/unaccent.sql.in | 34 -
contrib/unaccent/uninstall_unaccent.sql | 11 -
contrib/uuid-ossp/.gitignore | 1 -
contrib/uuid-ossp/Makefile | 5 +-
contrib/uuid-ossp/uninstall_uuid-ossp.sql | 16 -
contrib/uuid-ossp/uuid-ossp--1.0.sql | 51 +
contrib/uuid-ossp/uuid-ossp--unpackaged--1.0.sql | 12 +
contrib/uuid-ossp/uuid-ossp.control | 5 +
contrib/uuid-ossp/uuid-ossp.sql.in | 54 -
contrib/xml2/.gitignore | 1 -
contrib/xml2/Makefile | 8 +-
contrib/xml2/expected/xml2.out | 8 +-
contrib/xml2/expected/xml2_1.out | 8 +-
contrib/xml2/pgxml.sql.in | 73 -
contrib/xml2/sql/xml2.sql | 10 +-
contrib/xml2/uninstall_pgxml.sql | 31 -
contrib/xml2/xml2--1.0.sql | 70 +
contrib/xml2/xml2--unpackaged--1.0.sql | 16 +
contrib/xml2/xml2.control | 5 +
299 files changed, 12208 insertions(+), 12531 deletions(-)