pgsql: Make /contrib install/uninstall script consistent: remove

Log Message:
-----------
Make /contrib install/uninstall script consistent:

    remove transactions
    use create or replace function
    make formatting consistent
    set search patch on first line

Add documentation on modifying *.sql to set the search patch, and
mention that major upgrades should still run the installation scripts.

Some of these issues were spotted by Tom today.

Modified Files:
--------------
    pgsql/contrib/adminpack:
        adminpack.sql.in (r1.3 -> r1.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/adminpack/adminpack.sql.in?r1=1.3&r2=1.4)
        uninstall_adminpack.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/adminpack/uninstall_adminpack.sql?r1=1.1&r2=1.2)
    pgsql/contrib/btree_gist:
        btree_gist.sql.in (r1.17 -> r1.18)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_gist.sql.in?r1=1.17&r2=1.18)
        uninstall_btree_gist.sql (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/uninstall_btree_gist.sql?r1=1.2&r2=1.3)
    pgsql/contrib/chkpass:
        chkpass.sql.in (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/chkpass/chkpass.sql.in?r1=1.7&r2=1.8)
        uninstall_chkpass.sql (r1.3 -> r1.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/chkpass/uninstall_chkpass.sql?r1=1.3&r2=1.4)
    pgsql/contrib/cube:
        cube.sql.in (r1.21 -> r1.22)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/cube.sql.in?r1=1.21&r2=1.22)
        uninstall_cube.sql (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/uninstall_cube.sql?r1=1.5&r2=1.6)
    pgsql/contrib/dblink:
        dblink.sql.in (r1.12 -> r1.13)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/dblink.sql.in?r1=1.12&r2=1.13)
        uninstall_dblink.sql (r1.3 -> r1.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/uninstall_dblink.sql?r1=1.3&r2=1.4)
    pgsql/contrib/dict_int:
        dict_int.sql.in (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dict_int/dict_int.sql.in?r1=1.1&r2=1.2)
        uninstall_dict_int.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dict_int/uninstall_dict_int.sql?r1=1.1&r2=1.2)
    pgsql/contrib/dict_xsyn:
        dict_xsyn.sql.in (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dict_xsyn/dict_xsyn.sql.in?r1=1.1&r2=1.2)
        uninstall_dict_xsyn.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dict_xsyn/uninstall_dict_xsyn.sql?r1=1.1&r2=1.2)
    pgsql/contrib/earthdistance:
        uninstall_earthdistance.sql (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/earthdistance/uninstall_earthdistance.sql?r1=1.1&r2=1.2)
    pgsql/contrib/fuzzystrmatch:
        fuzzystrmatch.sql.in (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/fuzzystrmatch/fuzzystrmatch.sql.in?r1=1.7&r2=1.8)
        uninstall_fuzzystrmatch.sql (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/fuzzystrmatch/uninstall_fuzzystrmatch.sql?r1=1.1&r2=1.2)
    pgsql/contrib/hstore:
        hstore.sql.in (r1.6 -> r1.7)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/hstore/hstore.sql.in?r1=1.6&r2=1.7)
        uninstall_hstore.sql (r1.4 -> r1.5)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/hstore/uninstall_hstore.sql?r1=1.4&r2=1.5)
    pgsql/contrib/intagg:
        uninstall_int_aggregate.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intagg/uninstall_int_aggregate.sql?r1=1.1&r2=1.2)
    pgsql/contrib/intarray:
        _int.sql.in (r1.25 -> r1.26)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/_int.sql.in?r1=1.25&r2=1.26)
        uninstall__int.sql (r1.6 -> r1.7)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/uninstall__int.sql?r1=1.6&r2=1.7)
    pgsql/contrib/isn:
        isn.sql.in (r1.6 -> r1.7)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/isn/isn.sql.in?r1=1.6&r2=1.7)
        uninstall_isn.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/isn/uninstall_isn.sql?r1=1.1&r2=1.2)
    pgsql/contrib/lo:
        lo.sql.in (r1.13 -> r1.14)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/lo/lo.sql.in?r1=1.13&r2=1.14)
        lo_test.sql (r1.3 -> r1.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/lo/lo_test.sql?r1=1.3&r2=1.4)
        uninstall_lo.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/lo/uninstall_lo.sql?r1=1.1&r2=1.2)
    pgsql/contrib/ltree:
        ltree.sql.in (r1.14 -> r1.15)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ltree/ltree.sql.in?r1=1.14&r2=1.15)
        ltreetest.sql (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ltree/ltreetest.sql?r1=1.2&r2=1.3)
        uninstall_ltree.sql (r1.3 -> r1.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ltree/uninstall_ltree.sql?r1=1.3&r2=1.4)
    pgsql/contrib/pageinspect:
        uninstall_pageinspect.sql (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pageinspect/uninstall_pageinspect.sql?r1=1.2&r2=1.3)
    pgsql/contrib/pg_buffercache:
        pg_buffercache.sql.in (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_buffercache/pg_buffercache.sql.in?r1=1.5&r2=1.6)
        uninstall_pg_buffercache.sql (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_buffercache/uninstall_pg_buffercache.sql?r1=1.1&r2=1.2)
    pgsql/contrib/pg_freespacemap:
        pg_freespacemap.sql.in (r1.6 -> r1.7)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_freespacemap/pg_freespacemap.sql.in?r1=1.6&r2=1.7)
        uninstall_pg_freespacemap.sql (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_freespacemap/uninstall_pg_freespacemap.sql?r1=1.1&r2=1.2)
    pgsql/contrib/pg_trgm:
        pg_trgm.sql.in (r1.4 -> r1.5)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_trgm/pg_trgm.sql.in?r1=1.4&r2=1.5)
        uninstall_pg_trgm.sql (r1.3 -> r1.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_trgm/uninstall_pg_trgm.sql?r1=1.3&r2=1.4)
    pgsql/contrib/pgcrypto:
        uninstall_pgcrypto.sql (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgcrypto/uninstall_pgcrypto.sql?r1=1.2&r2=1.3)
    pgsql/contrib/pgrowlocks:
        uninstall_pgrowlocks.sql (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgrowlocks/uninstall_pgrowlocks.sql?r1=1.2&r2=1.3)
    pgsql/contrib/pgstattuple:
        uninstall_pgstattuple.sql (r1.4 -> r1.5)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgstattuple/uninstall_pgstattuple.sql?r1=1.4&r2=1.5)
    pgsql/contrib/seg:
        seg.sql.in (r1.14 -> r1.15)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/seg/seg.sql.in?r1=1.14&r2=1.15)
        uninstall_seg.sql (r1.3 -> r1.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/seg/uninstall_seg.sql?r1=1.3&r2=1.4)
    pgsql/contrib/sslinfo:
        sslinfo.sql.in (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/sslinfo/sslinfo.sql.in?r1=1.1&r2=1.2)
        uninstall_sslinfo.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/sslinfo/uninstall_sslinfo.sql?r1=1.1&r2=1.2)
    pgsql/contrib/tablefunc:
        uninstall_tablefunc.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tablefunc/uninstall_tablefunc.sql?r1=1.1&r2=1.2)
    pgsql/contrib/test_parser:
        test_parser.sql.in (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/test_parser/test_parser.sql.in?r1=1.1&r2=1.2)
        uninstall_test_parser.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/test_parser/uninstall_test_parser.sql?r1=1.1&r2=1.2)
    pgsql/contrib/tsearch2:
        tsearch.sql.in (r1.20 -> r1.21)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/tsearch.sql.in?r1=1.20&r2=1.21)
        untsearch.sql.in (r1.8 -> r1.9)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/untsearch.sql.in?r1=1.8&r2=1.9)
    pgsql/contrib/uuid-ossp:
        uninstall_uuid-ossp.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/uuid-ossp/uninstall_uuid-ossp.sql?r1=1.1&r2=1.2)
        uuid-ossp.sql.in (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/uuid-ossp/uuid-ossp.sql.in?r1=1.2&r2=1.3)
    pgsql/contrib/xml2:
        pgxml.sql.in (r1.9 -> r1.10)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml2/pgxml.sql.in?r1=1.9&r2=1.10)
        uninstall_pgxml.sql (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml2/uninstall_pgxml.sql?r1=1.2&r2=1.3)
    pgsql/doc/src/sgml:
        contrib.sgml (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/contrib.sgml?r1=1.1&r2=1.2)