Skip site navigation (1) Skip section navigation (2)

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

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make /contrib install/uninstall script consistent: remove
Date: 2007-11-11 03:25:35
Message-ID: 20071111032535.1CEEB7540F0@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
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)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2007-11-11 03:57:06
Subject: pgsql: Adjust pg_trgm expected output for new *.sql file.
Previous:From: Bruce MomjianDate: 2007-11-10 23:59:52
Subject: pgsql: Remove references to READMEs from /contrib Makefiles.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group