pgsql: Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, - Mailing list pgsql-committers

From petere@postgresql.org (Peter Eisentraut)
Subject pgsql: Clean up CREATE FUNCTION syntax usage in contrib and elsewhere,
Date
Msg-id 20060227160951.18FBB9DC870@postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, in
particular get rid of single quotes around language names and old WITH ()
construct.

Modified Files:
--------------
    pgsql/contrib/btree_gist:
        btree_gist.sql.in (r1.14 -> r1.15)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/btree_gist/btree_gist.sql.in.diff?r1=1.14&r2=1.15)
    pgsql/contrib/cube:
        cube.sql.in (r1.16 -> r1.17)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/cube/cube.sql.in.diff?r1=1.16&r2=1.17)
    pgsql/contrib/dblink:
        dblink.sql.in (r1.9 -> r1.10)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/dblink.sql.in.diff?r1=1.9&r2=1.10)
    pgsql/contrib/dbmirror:
        MirrorSetup.sql (r1.8 -> r1.9)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dbmirror/MirrorSetup.sql.diff?r1=1.8&r2=1.9)
    pgsql/contrib/earthdistance:
        earthdistance.sql.in (r1.8 -> r1.9)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/earthdistance/earthdistance.sql.in.diff?r1=1.8&r2=1.9)
    pgsql/contrib/fulltextindex:
        README.fti (r1.6 -> r1.7)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/fulltextindex/README.fti.diff?r1=1.6&r2=1.7)
        fti.c (r1.24 -> r1.25)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/fulltextindex/fti.c.diff?r1=1.24&r2=1.25)
        fti.pl (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/fulltextindex/fti.pl.diff?r1=1.7&r2=1.8)
        fti.sql.in (r1.8 -> r1.9)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/fulltextindex/fti.sql.in.diff?r1=1.8&r2=1.9)
    pgsql/contrib/fuzzystrmatch:
        README.soundex (r1.3 -> r1.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/fuzzystrmatch/README.soundex.diff?r1=1.3&r2=1.4)
    pgsql/contrib/intarray:
        _int.sql.in (r1.19 -> r1.20)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/_int.sql.in.diff?r1=1.19&r2=1.20)
    pgsql/contrib/intarray/expected:
        _int.out (r1.15 -> r1.16)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intarray/expected/_int.out.diff?r1=1.15&r2=1.16)
    pgsql/contrib/isbn_issn:
        isbn_issn.sql.in (r1.11 -> r1.12)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/isbn_issn/isbn_issn.sql.in.diff?r1=1.11&r2=1.12)
    pgsql/contrib/ltree:
        README.ltree (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ltree/README.ltree.diff?r1=1.7&r2=1.8)
        ltree.sql.in (r1.9 -> r1.10)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/ltree/ltree.sql.in.diff?r1=1.9&r2=1.10)
    pgsql/contrib/mac:
        createoui (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/mac/createoui.diff?r1=1.1&r2=1.2)
    pgsql/contrib/pg_buffercache:
        pg_buffercache.sql.in (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_buffercache/pg_buffercache.sql.in.diff?r1=1.2&r2=1.3)
    pgsql/contrib/pg_freespacemap:
        pg_freespacemap.sql.in (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_freespacemap/pg_freespacemap.sql.in.diff?r1=1.1&r2=1.2)
    pgsql/contrib/pg_trgm:
        pg_trgm.sql.in (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_trgm/pg_trgm.sql.in.diff?r1=1.1&r2=1.2)
    pgsql/contrib/pgcrypto:
        pgcrypto.sql.in (r1.11 -> r1.12)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgcrypto/pgcrypto.sql.in.diff?r1=1.11&r2=1.12)
    pgsql/contrib/pgstattuple:
        README.pgstattuple (r1.6 -> r1.7)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgstattuple/README.pgstattuple.diff?r1=1.6&r2=1.7)
        README.pgstattuple.euc_jp (r1.5 -> r1.6)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgstattuple/README.pgstattuple.euc_jp.diff?r1=1.5&r2=1.6)
        pgstattuple.sql.in (r1.9 -> r1.10)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgstattuple/pgstattuple.sql.in.diff?r1=1.9&r2=1.10)
    pgsql/contrib/seg:
        seg.sql.in (r1.11 -> r1.12)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/seg/seg.sql.in.diff?r1=1.11&r2=1.12)
    pgsql/contrib/spi:
        autoinc.sql.in (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/spi/autoinc.sql.in.diff?r1=1.5&r2=1.6)
        insert_username.sql.in (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/spi/insert_username.sql.in.diff?r1=1.5&r2=1.6)
        moddatetime.sql.in (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/spi/moddatetime.sql.in.diff?r1=1.5&r2=1.6)
        refint.sql.in (r1.5 -> r1.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/spi/refint.sql.in.diff?r1=1.5&r2=1.6)
        timetravel.sql.in (r1.6 -> r1.7)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/spi/timetravel.sql.in.diff?r1=1.6&r2=1.7)
    pgsql/contrib/tablefunc:
        README.tablefunc (r1.12 -> r1.13)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tablefunc/README.tablefunc.diff?r1=1.12&r2=1.13)
        tablefunc.sql.in (r1.10 -> r1.11)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tablefunc/tablefunc.sql.in.diff?r1=1.10&r2=1.11)
    pgsql/contrib/tablefunc/expected:
        tablefunc.out (r1.12 -> r1.13)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tablefunc/expected/tablefunc.out.diff?r1=1.12&r2=1.13)
    pgsql/contrib/tablefunc/sql:
        tablefunc.sql (r1.11 -> r1.12)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tablefunc/sql/tablefunc.sql.diff?r1=1.11&r2=1.12)
    pgsql/contrib/tsearch2:
        tsearch.sql.in (r1.15 -> r1.16)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/tsearch.sql.in.diff?r1=1.15&r2=1.16)
    pgsql/contrib/tsearch2/gendict:
        sql.IN (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/tsearch2/gendict/sql.IN.diff?r1=1.2&r2=1.3)
    pgsql/contrib/xml2:
        pgxml.sql.in (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/xml2/pgxml.sql.in.diff?r1=1.7&r2=1.8)
    pgsql/src/backend/commands:
        functioncmds.c (r1.70 -> r1.71)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/functioncmds.c.diff?r1=1.70&r2=1.71)
    pgsql/src/backend/utils/fmgr:
        README (r1.8 -> r1.9)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/fmgr/README.diff?r1=1.8&r2=1.9)
    pgsql/src/backend/utils/mb/conversion_procs:
        Makefile (r1.16 -> r1.17)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/mb/conversion_procs/Makefile.diff?r1=1.16&r2=1.17)
    pgsql/src/interfaces/ecpg/test:
        test_func.pgc (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/test_func.pgc.diff?r1=1.1&r2=1.2)
    pgsql/src/pl/plpgsql/src:
        scan.l (r1.42 -> r1.43)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/scan.l.diff?r1=1.42&r2=1.43)
    pgsql/src/pl/tcl/expected:
        pltcl_setup.out (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/tcl/expected/pltcl_setup.out.diff?r1=1.1&r2=1.2)
    pgsql/src/pl/tcl/sql:
        pltcl_setup.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/pl/tcl/sql/pltcl_setup.sql.diff?r1=1.1&r2=1.2)
    pgsql/src/test/regress:
        GNUmakefile (r1.55 -> r1.56)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/GNUmakefile.diff?r1=1.55&r2=1.56)
    pgsql/src/test/regress/expected:
        copy2.out (r1.24 -> r1.25)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/copy2.out.diff?r1=1.24&r2=1.25)
        create_type.out (r1.11 -> r1.12)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/create_type.out.diff?r1=1.11&r2=1.12)
        plpgsql.out (r1.42 -> r1.43)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/plpgsql.out.diff?r1=1.42&r2=1.43)
        polymorphism.out (r1.7 -> r1.8)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/polymorphism.out.diff?r1=1.7&r2=1.8)
        portals.out (r1.10 -> r1.11)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/portals.out.diff?r1=1.10&r2=1.11)
        rangefuncs.out (r1.14 -> r1.15)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rangefuncs.out.diff?r1=1.14&r2=1.15)
        rules.out (r1.113 -> r1.114)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.113&r2=1.114)
        triggers.out (r1.19 -> r1.20)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/triggers.out.diff?r1=1.19&r2=1.20)
    pgsql/src/test/regress/input:
        create_function_1.source (r1.16 -> r1.17)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/input/create_function_1.source.diff?r1=1.16&r2=1.17)
        create_function_2.source (r1.14 -> r1.15)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/input/create_function_2.source.diff?r1=1.14&r2=1.15)
    pgsql/src/test/regress/output:
        create_function_1.source (r1.27 -> r1.28)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/output/create_function_1.source.diff?r1=1.27&r2=1.28)
        create_function_2.source (r1.20 -> r1.21)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/output/create_function_2.source.diff?r1=1.20&r2=1.21)
    pgsql/src/test/regress/sql:
        copy2.sql (r1.15 -> r1.16)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/copy2.sql.diff?r1=1.15&r2=1.16)
        create_type.sql (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/create_type.sql.diff?r1=1.7&r2=1.8)
        plpgsql.sql (r1.36 -> r1.37)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/plpgsql.sql.diff?r1=1.36&r2=1.37)
        polymorphism.sql (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/polymorphism.sql.diff?r1=1.1&r2=1.2)
        portals.sql (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/portals.sql.diff?r1=1.7&r2=1.8)
        rangefuncs.sql (r1.6 -> r1.7)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/rangefuncs.sql.diff?r1=1.6&r2=1.7)
        rules.sql (r1.32 -> r1.33)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/rules.sql.diff?r1=1.32&r2=1.33)
        triggers.sql (r1.9 -> r1.10)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/triggers.sql.diff?r1=1.9&r2=1.10)
    pgsql/src/tutorial:
        funcs.source (r1.7 -> r1.8)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tutorial/funcs.source.diff?r1=1.7&r2=1.8)

pgsql-committers by date:

Previous
From: petere@postgresql.org (Peter Eisentraut)
Date:
Subject: pgsql: contrib uninstall scripts by David Fetter
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Extend the ExecInitNode API so that plan nodes receive a set of