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(-)