Horton

Make /contrib install/uninstall script consistent:

Bruce Momjian <bruce@momjian.us>

View on postgr.es
Commit: 926bbab44832ae2763392077ecefa029d14c8544
Author: Bruce Momjian <bruce@momjian.us>
Date: 2007-11-11T03:25:35Z
Releases: 8.3.0 
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.

Files

PathChange+/−
contrib/adminpack/adminpack.sql.in modified +36 −25
contrib/adminpack/uninstall_adminpack.sql modified +3 −0
contrib/btree_gist/btree_gist.sql.in modified +137 −137
contrib/btree_gist/uninstall_btree_gist.sql modified +1 −0
contrib/chkpass/chkpass.sql.in modified +7 −18
contrib/chkpass/uninstall_chkpass.sql modified +1 −0
contrib/cube/cube.sql.in modified +3 −3
contrib/cube/uninstall_cube.sql modified +1 −0
contrib/dblink/dblink.sql.in modified +3 −0
contrib/dblink/uninstall_dblink.sql modified +3 −0
contrib/dict_int/dict_int.sql.in modified +2 −8
contrib/dict_int/uninstall_dict_int.sql modified +1 −0
contrib/dict_xsyn/dict_xsyn.sql.in modified +2 −8
contrib/dict_xsyn/uninstall_dict_xsyn.sql modified +1 −0
contrib/earthdistance/uninstall_earthdistance.sql modified +1 −0
contrib/fuzzystrmatch/fuzzystrmatch.sql.in modified +7 −7
contrib/fuzzystrmatch/uninstall_fuzzystrmatch.sql modified +1 −1
contrib/hstore/hstore.sql.in modified +30 −34
contrib/hstore/uninstall_hstore.sql modified +2 −3
contrib/intagg/uninstall_int_aggregate.sql modified +1 −0
contrib/intarray/_int.sql.in modified +48 −53
contrib/intarray/uninstall__int.sql modified +1 −0
contrib/isn/isn.sql.in modified +248 −258
contrib/isn/uninstall_isn.sql modified +3 −3
contrib/lo/lo.sql.in modified +2 −8
contrib/lo/lo_test.sql modified +3 −0
contrib/lo/uninstall_lo.sql modified +3 −3
contrib/ltree/ltree.sql.in modified +70 −70
contrib/ltree/ltreetest.sql modified +3 −0
contrib/ltree/uninstall_ltree.sql modified +1 −0
contrib/pageinspect/uninstall_pageinspect.sql modified +1 −1
contrib/pg_buffercache/pg_buffercache.sql.in modified +0 −3
contrib/pg_buffercache/uninstall_pg_buffercache.sql modified +1 −1
contrib/pgcrypto/uninstall_pgcrypto.sql modified +1 −1
contrib/pg_freespacemap/pg_freespacemap.sql.in modified +0 −3
contrib/pg_freespacemap/uninstall_pg_freespacemap.sql modified +1 −0
contrib/pgrowlocks/uninstall_pgrowlocks.sql modified +1 −0
contrib/pgstattuple/uninstall_pgstattuple.sql modified +1 −1
contrib/pg_trgm/pg_trgm.sql.in modified +23 −26
contrib/pg_trgm/uninstall_pg_trgm.sql modified +1 −4
contrib/seg/seg.sql.in modified +30 −30
contrib/seg/uninstall_seg.sql modified +1 −0
contrib/sslinfo/sslinfo.sql.in modified +16 −14
contrib/sslinfo/uninstall_sslinfo.sql modified +1 −0
contrib/tablefunc/uninstall_tablefunc.sql modified +1 −0
contrib/test_parser/test_parser.sql.in modified +16 −22
contrib/test_parser/uninstall_test_parser.sql modified +1 −0
contrib/tsearch2/tsearch.sql.in modified +243 −246
contrib/tsearch2/untsearch.sql.in modified +2 −8
contrib/uuid-ossp/uninstall_uuid-ossp.sql modified +1 −2
contrib/uuid-ossp/uuid-ossp.sql.in modified +51 −13
contrib/xml2/pgxml.sql.in modified +42 −22
contrib/xml2/uninstall_pgxml.sql modified +1 −0
doc/src/sgml/contrib.sgml modified +7 −1