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)