Thread: pgsql: Clean up CREATE FUNCTION syntax usage in contrib and elsewhere,
pgsql: Clean up CREATE FUNCTION syntax usage in contrib and elsewhere,
From
petere@postgresql.org (Peter Eisentraut)
Date:
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)