Update /contrib for "autocommit TO 'on'".

Bruce Momjian <bruce@momjian.us>

Commit: aa4c702eac936964649f905741b4a99f4b489200
Author: Bruce Momjian <bruce@momjian.us>
Date: 2002-10-18T18:41:22Z
Releases: 7.3.1
Update /contrib for "autocommit TO 'on'".

Create objects in public schema.

Make spacing/capitalization consistent.

Remove transaction block use for object creation.

Remove unneeded function GRANTs.

Files

PathChange+/−
contrib/adddepend/adddepend modified +15 −1
contrib/array/array_iterator.sql.in modified +323 −257
contrib/btree_gist/btree_gist.sql.in modified +68 −30
contrib/btree_gist/expected/btree_gist.out modified +9 −9
contrib/btree_gist/sql/btree_gist.sql modified +10 −9
contrib/chkpass/chkpass.sql.in modified +29 −24
contrib/cube/cube.sql.in modified +161 −147
contrib/cube/expected/cube.out modified +2 −2
contrib/cube/sql/cube.sql modified +1 −0
contrib/dbase/dbf2pg.c modified +4 −0
contrib/dblink/dblink.sql.in modified +83 −79
contrib/dblink/expected/dblink.out modified +61 −39
contrib/dblink/sql/dblink.sql modified +64 −38
contrib/dbmirror/AddTrigger.sql modified +7 −3
contrib/dbmirror/clean_pending.pl modified +5 −1
contrib/dbmirror/DBMirror.pl modified +20 −2
contrib/dbmirror/MirrorSetup.sql modified +2 −0
contrib/earthdistance/earthdistance.sql.in modified +11 −16
contrib/earthdistance/expected/earthdistance.out modified +24 −24
contrib/earthdistance/sql/earthdistance.sql modified +25 −24
contrib/findoidjoins/findoidjoins.c modified +3 −1
contrib/fulltextindex/fti.pl modified +2 −0
contrib/fulltextindex/fti.sql.in modified +5 −2
contrib/fulltextindex/uninstall.sql modified +5 −0
contrib/fuzzystrmatch/fuzzystrmatch.sql.in modified +17 −11
contrib/intagg/int_aggregate.sql.in modified +16 −20
contrib/intarray/expected/_int.out modified +63 −63
contrib/intarray/_int.sql.in modified +246 −115
contrib/intarray/sql/_int.sql modified +62 −62
contrib/isbn_issn/isbn_issn.sql.in modified +157 −155
contrib/lo/lo_drop.sql modified +8 −3
contrib/lo/lo.sql.in modified +38 −32
contrib/lo/lo_test.sql modified +32 −20
contrib/ltree/expected/ltree.out modified +217 −217
contrib/ltree/ltree.sql.in modified +311 −166
contrib/ltree/ltreetest.sql modified +16 −16
contrib/ltree/sql/ltree.sql modified +224 −222
contrib/miscutil/misc_utils.sql.in modified +30 −20
contrib/noupdate/noup.sql.in modified +8 −5
contrib/oid2name/oid2name.c modified +4 −0
contrib/pgbench/pgbench.c modified +23 −2
contrib/pgcrypto/expected/blowfish.out modified +12 −11
contrib/pgcrypto/expected/crypt-blowfish.out modified +10 −8
contrib/pgcrypto/expected/crypt-des.out modified +10 −8
contrib/pgcrypto/expected/crypt-md5.out modified +10 −8
contrib/pgcrypto/expected/crypt-xdes.out modified +10 −8
contrib/pgcrypto/expected/hmac-md5.out modified +8 −7
contrib/pgcrypto/expected/hmac-sha1.out modified +8 −7
contrib/pgcrypto/expected/init.out modified +2 −2
contrib/pgcrypto/expected/md5.out modified +8 −7
contrib/pgcrypto/expected/rijndael.out modified +8 −7
contrib/pgcrypto/expected/sha1.out modified +8 −7
contrib/pgcrypto/pgcrypto.sql.in modified +74 −73
contrib/pgcrypto/sql/blowfish.sql modified +13 −11
contrib/pgcrypto/sql/crypt-blowfish.sql modified +11 −8
contrib/pgcrypto/sql/crypt-des.sql modified +11 −8
contrib/pgcrypto/sql/crypt-md5.sql modified +11 −8
contrib/pgcrypto/sql/crypt-xdes.sql modified +11 −8
contrib/pgcrypto/sql/hmac-md5.sql modified +9 −7
contrib/pgcrypto/sql/hmac-sha1.sql modified +9 −7
contrib/pgcrypto/sql/init.sql modified +3 −2
contrib/pgcrypto/sql/md5.sql modified +9 −7
contrib/pgcrypto/sql/rijndael.sql modified +9 −7
contrib/pgcrypto/sql/sha1.sql modified +9 −7
contrib/pg_dumplo/main.c modified +5 −1
contrib/pgstattuple/pgstattuple.sql.in modified +18 −13
contrib/reindexdb/reindexdb modified +5 −5
contrib/rtree_gist/bench/bench.pl modified +14 −0
contrib/rtree_gist/bench/create_test.pl modified +8 −8
contrib/rtree_gist/expected/rtree_gist.out modified +23 −13
contrib/rtree_gist/rtree_gist.sql.in modified +50 −24
contrib/rtree_gist/sql/rtree_gist.sql modified +24 −14
contrib/seg/expected/seg.out modified +2 −2
contrib/seg/seg.sql.in modified +195 −100
contrib/seg/sql/seg.sql modified +1 −0
contrib/spi/autoinc.sql.in modified +8 −5
contrib/spi/insert_username.sql.in modified +8 −5
contrib/spi/moddatetime.sql.in modified +8 −5
contrib/spi/refint.sql.in modified +12 −10
contrib/spi/timetravel.sql.in modified +12 −10
contrib/string/string_io.sql.in modified +52 −47
contrib/tablefunc/expected/tablefunc.out modified +16 −16
contrib/tablefunc/sql/tablefunc.sql modified +17 −16
contrib/tablefunc/tablefunc.sql.in modified +38 −34
contrib/tsearch/expected/tsearch.out modified +104 −103
contrib/tsearch/sql/tsearch.sql modified +103 −101
contrib/tsearch/tsearch.sql.in modified +101 −64
contrib/userlock/user_locks.sql.in modified +59 −45
contrib/vacuumlo/vacuumlo.c modified +23 −1
contrib/xml/pgxml_dom.source modified +13 −4
src/bin/scripts/Makefile modified +4 −4