pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

Started by Bruce Momjianover 13 years ago17 messages
#1Bruce Momjian
bruce@momjian.us

Run pgindent on 9.2 source tree in preparation for first 9.3
commit-fest.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/927d61eeff78363ea3938c818d07e511ebaf75cf

Modified Files
--------------
contrib/auto_explain/auto_explain.c | 2 +-
contrib/dblink/dblink.c | 2 +-
contrib/file_fdw/file_fdw.c | 67 +-
contrib/pg_archivecleanup/pg_archivecleanup.c | 16 +-
contrib/pg_stat_statements/pg_stat_statements.c | 77 +-
contrib/pg_test_fsync/pg_test_fsync.c | 7 +-
contrib/pg_test_timing/pg_test_timing.c | 34 +-
contrib/pg_trgm/trgm_gist.c | 9 +-
contrib/pg_upgrade/check.c | 90 +-
contrib/pg_upgrade/controldata.c | 7 +-
contrib/pg_upgrade/exec.c | 15 +-
contrib/pg_upgrade/file.c | 11 +-
contrib/pg_upgrade/function.c | 102 +-
contrib/pg_upgrade/info.c | 30 +-
contrib/pg_upgrade/option.c | 47 +-
contrib/pg_upgrade/pg_upgrade.c | 29 +-
contrib/pg_upgrade/pg_upgrade.h | 49 +-
contrib/pg_upgrade/relfilenode.c | 26 +-
contrib/pg_upgrade/server.c | 16 +-
contrib/pg_upgrade/tablespace.c | 4 +-
contrib/pg_upgrade/version_old_8_3.c | 36 +-
contrib/pgbench/pgbench.c | 53 +-
contrib/pgcrypto/crypt-md5.c | 4 +-
contrib/pgcrypto/px.h | 5 +-
contrib/pgstattuple/pgstatindex.c | 4 +-
contrib/pgstattuple/pgstattuple.c | 2 +-
contrib/sepgsql/database.c | 33 +-
contrib/sepgsql/dml.c | 2 +-
contrib/sepgsql/hooks.c | 38 +-
contrib/sepgsql/label.c | 60 +-
contrib/sepgsql/proc.c | 38 +-
contrib/sepgsql/relation.c | 38 +-
contrib/sepgsql/schema.c | 26 +-
contrib/sepgsql/sepgsql.h | 21 +-
contrib/sepgsql/uavc.c | 162 ++--
contrib/spi/refint.c | 3 +-
contrib/vacuumlo/vacuumlo.c | 10 +-
contrib/xml2/xpath.c | 214 ++--
contrib/xml2/xslt_proc.c | 58 +-
src/backend/access/gist/gist.c | 12 +-
src/backend/access/gist/gistbuild.c | 69 +-
src/backend/access/gist/gistbuildbuffers.c | 2 +-
src/backend/access/gist/gistproc.c | 6 +-
src/backend/access/gist/gistscan.c | 2 +-
src/backend/access/gist/gistsplit.c | 3 +-
src/backend/access/hash/hashovfl.c | 2 +-
src/backend/access/heap/heapam.c | 132 ++--
src/backend/access/heap/hio.c | 39 +-
src/backend/access/heap/tuptoaster.c | 6 +-
src/backend/access/heap/visibilitymap.c | 40 +-
src/backend/access/index/genam.c | 2 +-
src/backend/access/index/indexam.c | 10 +-
src/backend/access/nbtree/nbtcompare.c | 10 +-
src/backend/access/nbtree/nbtpage.c | 2 +-
src/backend/access/nbtree/nbtree.c | 4 +-
src/backend/access/nbtree/nbtsearch.c | 8 +-
src/backend/access/nbtree/nbtutils.c | 72 +-
src/backend/access/spgist/spgdoinsert.c | 155 ++--
src/backend/access/spgist/spginsert.c | 2 +-
src/backend/access/spgist/spgkdtreeproc.c | 12 +-
src/backend/access/spgist/spgquadtreeproc.c | 4 +-
src/backend/access/spgist/spgscan.c | 15 +-
src/backend/access/spgist/spgtextproc.c | 26 +-
src/backend/access/spgist/spgutils.c | 12 +-
src/backend/access/spgist/spgvacuum.c | 56 +-
src/backend/access/spgist/spgxlog.c | 46 +-
src/backend/access/transam/clog.c | 2 +-
src/backend/access/transam/slru.c | 44 +-
src/backend/access/transam/twophase.c | 29 +-
src/backend/access/transam/varsup.c | 4 +-
src/backend/access/transam/xact.c | 55 +-
src/backend/access/transam/xlog.c | 318 +++---
src/backend/access/transam/xlogutils.c | 8 +-
src/backend/catalog/aclchk.c | 10 +-
src/backend/catalog/dependency.c | 38 +-
src/backend/catalog/heap.c | 8 +-
src/backend/catalog/index.c | 52 +-
src/backend/catalog/namespace.c | 61 +-
src/backend/catalog/objectaddress.c | 57 +-
src/backend/catalog/pg_constraint.c | 4 +-
src/backend/catalog/pg_depend.c | 2 +-
src/backend/catalog/pg_proc.c | 2 +-
src/backend/catalog/pg_shdepend.c | 2 +-
src/backend/catalog/storage.c | 4 +-
src/backend/commands/analyze.c | 22 +-
src/backend/commands/cluster.c | 8 +-
src/backend/commands/copy.c | 22 +-
src/backend/commands/createas.c | 46 +-
src/backend/commands/dbcommands.c | 26 +-
src/backend/commands/dropcmds.c | 16 +-
src/backend/commands/explain.c | 20 +-
src/backend/commands/extension.c | 10 +-
src/backend/commands/foreigncmds.c | 8 +-
src/backend/commands/functioncmds.c | 8 +-
src/backend/commands/indexcmds.c | 32 +-
src/backend/commands/lockcmds.c | 27 +-
src/backend/commands/opclasscmds.c | 6 +-
src/backend/commands/prepare.c | 12 +-
src/backend/commands/proclang.c | 4 +-
src/backend/commands/seclabel.c | 10 +-
src/backend/commands/sequence.c | 20 +-
src/backend/commands/tablecmds.c | 271 +++---
src/backend/commands/tablespace.c | 29 +-
src/backend/commands/trigger.c | 34 +-
src/backend/commands/typecmds.c | 28 +-
src/backend/commands/user.c | 3 +-
src/backend/commands/vacuum.c | 14 +-
src/backend/commands/vacuumlazy.c | 60 +-
src/backend/commands/view.c | 6 +-
src/backend/executor/execCurrent.c | 2 +-
src/backend/executor/execMain.c | 4 +-
src/backend/executor/execQual.c | 24 +-
src/backend/executor/execUtils.c | 4 +-
src/backend/executor/functions.c | 12 +-
src/backend/executor/nodeBitmapHeapscan.c | 3 +-
src/backend/executor/nodeIndexonlyscan.c | 20 +-
src/backend/executor/nodeMaterial.c | 2 +-
src/backend/executor/nodeMergeAppend.c | 4 +-
src/backend/executor/nodeMergejoin.c | 8 +-
src/backend/executor/nodeModifyTable.c | 4 +-
src/backend/executor/nodeSetOp.c | 2 +-
src/backend/executor/spi.c | 18 +-
src/backend/libpq/auth.c | 20 +-
src/backend/libpq/be-secure.c | 14 +-
src/backend/libpq/hba.c | 105 +-
src/backend/libpq/pqcomm.c | 8 +-
src/backend/nodes/bitmapset.c | 4 +-
src/backend/nodes/copyfuncs.c | 4 +-
src/backend/nodes/equalfuncs.c | 4 +-
src/backend/nodes/list.c | 26 +-
src/backend/nodes/nodeFuncs.c | 36 +-
src/backend/nodes/outfuncs.c | 2 +-
src/backend/nodes/print.c | 14 +-
src/backend/nodes/readfuncs.c | 4 +-
src/backend/nodes/tidbitmap.c | 16 +-
src/backend/optimizer/geqo/geqo_selection.c | 4 +-
src/backend/optimizer/path/allpaths.c | 40 +-
src/backend/optimizer/path/costsize.c | 33 +-
src/backend/optimizer/path/equivclass.c | 22 +-
src/backend/optimizer/path/indxpath.c | 177 ++--
src/backend/optimizer/path/joinpath.c | 58 +-
src/backend/optimizer/path/joinrels.c | 4 +-
src/backend/optimizer/path/orindxpath.c | 6 +-
src/backend/optimizer/path/pathkeys.c | 2 +-
src/backend/optimizer/plan/createplan.c | 61 +-
src/backend/optimizer/plan/initsplan.c | 6 +-
src/backend/optimizer/plan/planagg.c | 4 +-
src/backend/optimizer/plan/planmain.c | 4 +-
src/backend/optimizer/plan/planner.c | 44 +-
src/backend/optimizer/plan/setrefs.c | 12 +-
src/backend/optimizer/plan/subselect.c | 4 +-
src/backend/optimizer/prep/prepjointree.c | 22 +-
src/backend/optimizer/prep/prepunion.c | 6 +-
src/backend/optimizer/util/clauses.c | 56 +-
src/backend/optimizer/util/pathnode.c | 139 ++--
src/backend/optimizer/util/placeholder.c | 4 +-
src/backend/optimizer/util/plancat.c | 8 +-
src/backend/optimizer/util/predtest.c | 2 +-
src/backend/optimizer/util/relnode.c | 10 +-
src/backend/optimizer/util/var.c | 2 +-
src/backend/parser/analyze.c | 12 +-
src/backend/parser/parse_coerce.c | 74 +-
src/backend/parser/parse_expr.c | 10 +-
src/backend/parser/parse_func.c | 8 +-
src/backend/parser/parse_relation.c | 7 +-
src/backend/parser/parse_target.c | 4 +-
src/backend/parser/parse_type.c | 4 +-
src/backend/parser/parse_utilcmd.c | 14 +-
src/backend/port/darwin/system.c | 2 +-
src/backend/port/dynloader/aix.h | 2 +-
src/backend/port/dynloader/cygwin.h | 2 +-
src/backend/port/dynloader/freebsd.h | 2 +-
src/backend/port/dynloader/irix.h | 2 +-
src/backend/port/dynloader/linux.h | 2 +-
src/backend/port/dynloader/netbsd.h | 2 +-
src/backend/port/dynloader/openbsd.h | 2 +-
src/backend/port/dynloader/osf.h | 2 +-
src/backend/port/dynloader/sco.h | 2 +-
src/backend/port/dynloader/solaris.h | 2 +-
src/backend/port/dynloader/unixware.h | 2 +-
src/backend/port/dynloader/win32.h | 2 +-
src/backend/port/unix_latch.c | 36 +-
src/backend/port/win32/mingwcompat.c | 4 +-
src/backend/port/win32/socket.c | 7 +-
src/backend/port/win32/timer.c | 8 +-
src/backend/port/win32_latch.c | 5 +-
src/backend/port/win32_sema.c | 4 +-
src/backend/postmaster/autovacuum.c | 12 +-
src/backend/postmaster/bgwriter.c | 10 +-
src/backend/postmaster/checkpointer.c | 73 +-
src/backend/postmaster/pgarch.c | 16 +-
src/backend/postmaster/pgstat.c | 21 +-
src/backend/postmaster/postmaster.c | 101 +-
src/backend/postmaster/syslogger.c | 5 +-
src/backend/postmaster/walwriter.c | 8 +-
src/backend/regex/regc_locale.c | 13 +-
src/backend/regex/regc_pg_locale.c | 10 +-
src/backend/regex/regcomp.c | 10 +-
src/backend/regex/rege_dfa.c | 2 +-
src/backend/regex/regerror.c | 2 +-
src/backend/regex/regexec.c | 34 +-
src/backend/replication/basebackup.c | 12 +-
src/backend/replication/syncrep.c | 24 +-
src/backend/replication/walreceiver.c | 8 +-
src/backend/replication/walreceiverfuncs.c | 10 +-
src/backend/replication/walsender.c | 61 +-
src/backend/rewrite/rewriteDefine.c | 2 +-
src/backend/rewrite/rewriteSupport.c | 4 +-
src/backend/storage/buffer/bufmgr.c | 24 +-
src/backend/storage/buffer/freelist.c | 2 +-
src/backend/storage/file/fd.c | 24 +-
src/backend/storage/ipc/pmsignal.c | 5 +-
src/backend/storage/ipc/procarray.c | 161 ++--
src/backend/storage/ipc/sinval.c | 2 +-
src/backend/storage/ipc/sinvaladt.c | 23 +-
src/backend/storage/ipc/standby.c | 12 +-
src/backend/storage/lmgr/lock.c | 201 ++--
src/backend/storage/lmgr/lwlock.c | 5 +-
src/backend/storage/lmgr/predicate.c | 58 +-
src/backend/storage/lmgr/proc.c | 44 +-
src/backend/storage/lmgr/s_lock.c | 2 +-
src/backend/storage/smgr/md.c | 26 +-
src/backend/storage/smgr/smgr.c | 4 +-
src/backend/tcop/postgres.c | 59 +-
src/backend/tcop/utility.c | 12 +-
src/backend/tsearch/dict_thesaurus.c | 4 +-
src/backend/tsearch/spell.c | 4 +-
src/backend/tsearch/to_tsany.c | 4 +-
src/backend/tsearch/ts_utils.c | 2 +-
src/backend/utils/adt/acl.c | 6 +-
src/backend/utils/adt/array_selfuncs.c | 42 +-
src/backend/utils/adt/array_typanalyze.c | 42 +-
src/backend/utils/adt/cash.c | 4 +-
src/backend/utils/adt/date.c | 2 +-
src/backend/utils/adt/datetime.c | 2 +-
src/backend/utils/adt/dbsize.c | 2 +
src/backend/utils/adt/float.c | 26 +-
src/backend/utils/adt/formatting.c | 6 +-
src/backend/utils/adt/inet_net_pton.c | 3 +-
src/backend/utils/adt/json.c | 229 ++--
src/backend/utils/adt/lockfuncs.c | 6 +-
src/backend/utils/adt/mac.c | 16 +-
src/backend/utils/adt/misc.c | 19 +-
src/backend/utils/adt/numeric.c | 8 +-
src/backend/utils/adt/pg_locale.c | 6 +-
src/backend/utils/adt/pgstatfuncs.c | 8 +-
src/backend/utils/adt/rangetypes.c | 54 +-
src/backend/utils/adt/rangetypes_gist.c | 231 +++--
src/backend/utils/adt/ruleutils.c | 92 +-
src/backend/utils/adt/selfuncs.c | 91 +-
src/backend/utils/adt/timestamp.c | 18 +-
src/backend/utils/adt/tsgistidx.c | 4 +-
src/backend/utils/adt/tsquery_util.c | 2 +-
src/backend/utils/adt/tsrank.c | 4 +-
src/backend/utils/adt/tsvector_op.c | 6 +-
src/backend/utils/adt/varbit.c | 2 +-
src/backend/utils/adt/varchar.c | 2 +-
src/backend/utils/adt/varlena.c | 11 +-
src/backend/utils/adt/xml.c | 36 +-
src/backend/utils/cache/catcache.c | 4 +-
src/backend/utils/cache/inval.c | 2 +-
src/backend/utils/cache/lsyscache.c | 8 +-
src/backend/utils/cache/plancache.c | 82 +-
src/backend/utils/cache/relcache.c | 12 +-
src/backend/utils/cache/ts_cache.c | 8 +-
src/backend/utils/error/elog.c | 12 +-
src/backend/utils/fmgr/fmgr.c | 4 +-
src/backend/utils/fmgr/funcapi.c | 16 +-
src/backend/utils/init/miscinit.c | 2 +-
src/backend/utils/mb/wchar.c | 23 +-
src/backend/utils/misc/guc.c | 24 +-
src/backend/utils/mmgr/portalmem.c | 2 +-
src/backend/utils/sort/sortsupport.c | 5 +-
src/backend/utils/sort/tuplesort.c | 31 +-
src/backend/utils/sort/tuplestore.c | 2 +-
src/backend/utils/time/snapmgr.c | 82 +-
src/backend/utils/time/tqual.c | 10 +-
src/bin/initdb/findtimezone.c | 3 +-
src/bin/initdb/initdb.c | 41 +-
src/bin/pg_basebackup/pg_basebackup.c | 9 +-
src/bin/pg_basebackup/pg_receivexlog.c | 13 +-
src/bin/pg_basebackup/receivelog.c | 25 +-
src/bin/pg_basebackup/receivelog.h | 16 +-
src/bin/pg_basebackup/streamutil.c | 4 +-
src/bin/pg_ctl/pg_ctl.c | 17 +-
src/bin/pg_dump/common.c | 4 +-
src/bin/pg_dump/dumputils.c | 28 +-
src/bin/pg_dump/dumputils.h | 15 +-
src/bin/pg_dump/pg_backup.h | 2 +-
src/bin/pg_dump/pg_backup_archiver.c | 47 +-
src/bin/pg_dump/pg_backup_archiver.h | 2 +-
src/bin/pg_dump/pg_backup_custom.c | 8 +-
src/bin/pg_dump/pg_backup_db.c | 14 +-
src/bin/pg_dump/pg_backup_directory.c | 14 +-
src/bin/pg_dump/pg_backup_tar.c | 12 +-
src/bin/pg_dump/pg_dump.c | 96 +-
src/bin/pg_dump/pg_dump_sort.c | 28 +-
src/bin/pg_dump/pg_dumpall.c | 6 +-
src/bin/pgevent/pgevent.c | 2 +-
src/bin/psql/command.c | 27 +-
src/bin/psql/common.c | 9 +-
src/bin/psql/copy.c | 5 +-
src/bin/psql/describe.c | 48 +-
src/bin/psql/help.c | 6 +-
src/bin/psql/input.c | 3 +-
src/bin/psql/print.c | 7 +-
src/bin/psql/print.h | 6 +-
src/bin/psql/startup.c | 7 +-
src/bin/psql/stringutils.c | 4 +-
src/bin/psql/tab-complete.c | 50 +-
src/bin/psql/variables.c | 2 +-
src/bin/scripts/clusterdb.c | 6 +-
src/bin/scripts/common.c | 2 +-
src/bin/scripts/common.h | 8 +-
src/bin/scripts/createlang.c | 7 +-
src/bin/scripts/dropdb.c | 4 +-
src/bin/scripts/droplang.c | 7 +-
src/bin/scripts/reindexdb.c | 6 +-
src/bin/scripts/vacuumdb.c | 10 +-
src/include/access/gist_private.h | 2 +-
src/include/access/heapam.h | 2 +-
src/include/access/htup.h | 6 +-
src/include/access/nbtree.h | 10 +-
src/include/access/slru.h | 2 +-
src/include/access/spgist.h | 22 +-
src/include/access/spgist_private.h | 60 +-
src/include/access/xact.h | 3 +-
src/include/access/xlog_internal.h | 4 +-
src/include/catalog/catalog.h | 2 +-
src/include/catalog/genbki.h | 2 +-
src/include/catalog/index.h | 2 +-
src/include/catalog/namespace.h | 8 +-
src/include/catalog/objectaccess.h | 6 +-
src/include/catalog/objectaddress.h | 4 +-
src/include/catalog/pg_aggregate.h | 1 +
src/include/catalog/pg_attrdef.h | 1 +
src/include/catalog/pg_attribute.h | 2 +-
src/include/catalog/pg_constraint.h | 1 +
src/include/catalog/pg_control.h | 12 +-
src/include/catalog/pg_database.h | 1 +
src/include/catalog/pg_db_role_setting.h | 1 +
src/include/catalog/pg_default_acl.h | 1 +
src/include/catalog/pg_description.h | 1 +
src/include/catalog/pg_extension.h | 3 +-
src/include/catalog/pg_foreign_data_wrapper.h | 1 +
src/include/catalog/pg_foreign_server.h | 1 +
src/include/catalog/pg_foreign_table.h | 1 +
src/include/catalog/pg_index.h | 1 +
src/include/catalog/pg_language.h | 1 +
src/include/catalog/pg_largeobject.h | 1 +
src/include/catalog/pg_largeobject_metadata.h | 1 +
src/include/catalog/pg_namespace.h | 1 +
src/include/catalog/pg_opclass.h | 4 +-
src/include/catalog/pg_operator.h | 2 +-
src/include/catalog/pg_pltemplate.h | 1 +
src/include/catalog/pg_proc.h | 57 +-
src/include/catalog/pg_range.h | 6 +-
src/include/catalog/pg_rewrite.h | 1 +
src/include/catalog/pg_seclabel.h | 1 +
src/include/catalog/pg_shdescription.h | 1 +
src/include/catalog/pg_shseclabel.h | 15 +-
src/include/catalog/pg_statistic.h | 6 +-
src/include/catalog/pg_tablespace.h | 1 +
src/include/catalog/pg_trigger.h | 7 +-
src/include/catalog/pg_ts_dict.h | 1 +
src/include/catalog/pg_type.h | 6 +-
src/include/commands/createas.h | 2 +-
src/include/commands/defrem.h | 2 +-
src/include/commands/explain.h | 2 +-
src/include/commands/tablecmds.h | 2 +-
src/include/commands/typecmds.h | 2 +-
src/include/commands/vacuum.h | 6 +-
src/include/datatype/timestamp.h | 8 +-
src/include/executor/executor.h | 2 +-
src/include/executor/instrument.h | 14 +-
src/include/executor/spi_priv.h | 2 +-
src/include/foreign/fdwapi.h | 32 +-
src/include/lib/stringinfo.h | 3 +-
src/include/libpq/hba.h | 2 +-
src/include/libpq/ip.h | 4 +-
src/include/nodes/execnodes.h | 2 +-
src/include/nodes/parsenodes.h | 18 +-
src/include/nodes/primnodes.h | 10 +-
src/include/nodes/relation.h | 14 +-
src/include/optimizer/cost.h | 20 +-
src/include/optimizer/pathnode.h | 26 +-
src/include/optimizer/paths.h | 4 +-
src/include/optimizer/prep.h | 2 +-
src/include/optimizer/subselect.h | 2 +-
src/include/parser/analyze.h | 2 +-
src/include/pg_config_manual.h | 4 +-
src/include/pg_trace.h | 2 +-
src/include/pgstat.h | 19 +-
src/include/port.h | 3 +-
src/include/port/win32.h | 2 +-
src/include/postgres.h | 2 +-
src/include/postmaster/postmaster.h | 8 +-
src/include/regex/regguts.h | 4 +-
src/include/replication/walprotocol.h | 2 +-
src/include/replication/walreceiver.h | 4 +-
src/include/replication/walsender_private.h | 3 +-
src/include/rewrite/rewriteSupport.h | 4 +-
src/include/snowball/header.h | 2 +-
src/include/storage/barrier.h | 19 +-
src/include/storage/latch.h | 10 +-
src/include/storage/lock.h | 4 +-
src/include/storage/lwlock.h | 6 +-
src/include/storage/predicate.h | 2 +-
src/include/storage/proc.h | 9 +-
src/include/storage/procarray.h | 2 +-
src/include/storage/sinval.h | 4 +-
src/include/storage/smgr.h | 2 +-
src/include/tsearch/ts_public.h | 10 +-
src/include/utils/acl.h | 2 +-
src/include/utils/builtins.h | 2 +-
src/include/utils/guc.h | 2 +-
src/include/utils/guc_tables.h | 4 +-
src/include/utils/json.h | 2 +-
src/include/utils/lsyscache.h | 10 +-
src/include/utils/memutils.h | 2 +-
src/include/utils/pg_crc_tables.h | 1 -
src/include/utils/plancache.h | 34 +-
src/include/utils/rangetypes.h | 18 +-
src/include/utils/rel.h | 2 +-
src/include/utils/selfuncs.h | 2 +-
src/include/utils/sortsupport.h | 26 +-
src/include/utils/timestamp.h | 2 -
src/include/utils/tqual.h | 2 +-
src/include/utils/typcache.h | 8 +-
src/include/utils/xml.h | 12 +-
src/interfaces/ecpg/ecpglib/connect.c | 27 +-
src/interfaces/ecpg/ecpglib/execute.c | 4 +-
src/interfaces/ecpg/ecpglib/extern.h | 6 +-
src/interfaces/ecpg/pgtypeslib/dt.h | 6 +-
src/interfaces/ecpg/preproc/type.c | 5 +-
src/interfaces/libpq/fe-connect.c | 86 +-
src/interfaces/libpq/fe-exec.c | 6 +-
src/interfaces/libpq/fe-protocol2.c | 15 +-
src/interfaces/libpq/fe-protocol3.c | 4 +-
src/interfaces/libpq/fe-secure.c | 53 +-
src/interfaces/libpq/libpq-fe.h | 2 +-
src/interfaces/libpq/libpq-int.h | 4 +-
src/interfaces/libpq/test/uri-regress.c | 6 +-
src/pl/plperl/plperl.c | 10 +-
src/pl/plperl/plperl_helpers.h | 28 +-
src/pl/plpgsql/src/pl_comp.c | 2 +-
src/pl/plpgsql/src/pl_exec.c | 46 +-
src/pl/plpython/plpy_cursorobject.c | 31 +-
src/pl/plpython/plpy_cursorobject.h | 4 +-
src/pl/plpython/plpy_elog.c | 16 +-
src/pl/plpython/plpy_elog.h | 13 +-
src/pl/plpython/plpy_exec.c | 6 +-
src/pl/plpython/plpy_exec.h | 2 +-
src/pl/plpython/plpy_main.c | 13 +-
src/pl/plpython/plpy_main.h | 6 +-
src/pl/plpython/plpy_planobject.h | 2 +-
src/pl/plpython/plpy_plpymodule.c | 5 +-
src/pl/plpython/plpy_plpymodule.h | 2 +-
src/pl/plpython/plpy_procedure.h | 2 +-
src/pl/plpython/plpy_resultobject.c | 6 +-
src/pl/plpython/plpy_resultobject.h | 5 +-
src/pl/plpython/plpy_spi.c | 40 +-
src/pl/plpython/plpy_spi.h | 2 +-
src/pl/plpython/plpy_subxactobject.c | 2 +-
src/pl/plpython/plpy_subxactobject.h | 2 +-
src/pl/plpython/plpy_typeio.c | 6 +-
src/pl/plpython/plpy_typeio.h | 2 +-
src/pl/plpython/plpy_util.c | 1 +
src/pl/plpython/plpy_util.h | 2 +-
src/pl/plpython/plpython.h | 8 +-
src/port/erand48.c | 2 +-
src/port/fls.c | 18 +-
src/port/getaddrinfo.c | 2 +-
src/port/path.c | 2 +-
src/port/win32setlocale.c | 38 +-
src/test/isolation/isolationtester.c | 87 +-
src/test/regress/pg_regress.c | 2 +-
src/test/thread/thread_test.c | 17 +-
src/timezone/pgtz.c | 8 +-
src/tools/msvc/Install.pm | 1056 ++++++++++---------
src/tools/msvc/MSBuildProject.pm | 325 +++---
src/tools/msvc/Mkvcbuild.pm | 1278 ++++++++++++-----------
src/tools/msvc/Project.pm | 607 ++++++------
src/tools/msvc/Solution.pm | 980 +++++++++---------
src/tools/msvc/VCBuildProject.pm | 292 +++---
src/tools/msvc/VSObjectFactory.pm | 152 ++--
src/tools/msvc/build.pl | 20 +-
src/tools/msvc/builddoc.pl | 32 +-
src/tools/msvc/config_default.pl | 38 +-
src/tools/msvc/gendef.pl | 66 +-
src/tools/msvc/install.pl | 4 +-
src/tools/msvc/pgbison.pl | 14 +-
src/tools/msvc/pgflex.pl | 60 +-
src/tools/msvc/vcregress.pl | 400 ++++----
494 files changed, 7506 insertions(+), 7209 deletions(-)

#2Alvaro Herrera
alvherre@commandprompt.com
In reply to: Bruce Momjian (#1)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

Excerpts from Bruce Momjian's message of dom jun 10 15:20:34 -0400 2012:

Run pgindent on 9.2 source tree in preparation for first 9.3
commit-fest.

Hm, does this touch stuff that would also be modified by perltidy? I
wonder if we should refrain from doing entab/detab on perl files and
instead have perltidy touch such code.

Perhaps the thing to do is ensure that perltidy also uses tabs instead
of spaces.

src/tools/msvc/Install.pm | 1056 ++++++++++---------
src/tools/msvc/MSBuildProject.pm | 325 +++---
src/tools/msvc/Mkvcbuild.pm | 1278 ++++++++++++-----------
src/tools/msvc/Project.pm | 607 ++++++------
src/tools/msvc/Solution.pm | 980 +++++++++---------
src/tools/msvc/VCBuildProject.pm | 292 +++---
src/tools/msvc/VSObjectFactory.pm | 152 ++--
src/tools/msvc/build.pl | 20 +-
src/tools/msvc/builddoc.pl | 32 +-
src/tools/msvc/config_default.pl | 38 +-
src/tools/msvc/gendef.pl | 66 +-
src/tools/msvc/install.pl | 4 +-
src/tools/msvc/pgbison.pl | 14 +-
src/tools/msvc/pgflex.pl | 60 +-
src/tools/msvc/vcregress.pl | 400 ++++----

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

#3Bruce Momjian
bruce@momjian.us
In reply to: Alvaro Herrera (#2)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Sun, Jun 10, 2012 at 08:55:13PM -0400, Alvaro Herrera wrote:

Excerpts from Bruce Momjian's message of dom jun 10 15:20:34 -0400 2012:

Run pgindent on 9.2 source tree in preparation for first 9.3
commit-fest.

Hm, does this touch stuff that would also be modified by perltidy? I
wonder if we should refrain from doing entab/detab on perl files and
instead have perltidy touch such code.

src/tools/msvc/Install.pm | 1056 ++++++++++---------
src/tools/msvc/MSBuildProject.pm | 325 +++---
src/tools/msvc/Mkvcbuild.pm | 1278 ++++++++++++-----------
src/tools/msvc/Project.pm | 607 ++++++------
src/tools/msvc/Solution.pm | 980 +++++++++---------
src/tools/msvc/VCBuildProject.pm | 292 +++---
src/tools/msvc/VSObjectFactory.pm | 152 ++--
src/tools/msvc/build.pl | 20 +-
src/tools/msvc/builddoc.pl | 32 +-
src/tools/msvc/config_default.pl | 38 +-
src/tools/msvc/gendef.pl | 66 +-
src/tools/msvc/install.pl | 4 +-
src/tools/msvc/pgbison.pl | 14 +-
src/tools/msvc/pgflex.pl | 60 +-
src/tools/msvc/vcregress.pl | 400 ++++----

The Perl files were modified by perltidy and not by pgindent, as
documented in the pgindent README:

9) Indent the Perl MSVC code:

cd src/tools/msvc
perltidy -b -bl -nsfs -naws -l=100 -ole=unix *.pl *.pm

Perhaps the thing to do is ensure that perltidy also uses tabs instead
of spaces.

If you would like 'entab' run on the Perl files, let me know.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

#4Alvaro Herrera
alvherre@commandprompt.com
In reply to: Bruce Momjian (#3)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

Excerpts from Bruce Momjian's message of dom jun 10 22:37:14 -0400 2012:

On Sun, Jun 10, 2012 at 08:55:13PM -0400, Alvaro Herrera wrote:

Excerpts from Bruce Momjian's message of dom jun 10 15:20:34 -0400 2012:

Run pgindent on 9.2 source tree in preparation for first 9.3
commit-fest.

Hm, does this touch stuff that would also be modified by perltidy? I
wonder if we should refrain from doing entab/detab on perl files and
instead have perltidy touch such code.

The Perl files were modified by perltidy and not by pgindent, as
documented in the pgindent README:

9) Indent the Perl MSVC code:

cd src/tools/msvc
perltidy -b -bl -nsfs -naws -l=100 -ole=unix *.pl *.pm

Oh, I see. That's great then. Should those change be committed
separately, just to avoid confusion? BTW those aren't the only Perl
files in the source tree -- we also have the genbki stuff, for example.
(There is already some inconsistency in tabs/spaces in genbki.pl
already)

Perhaps the thing to do is ensure that perltidy also uses tabs instead
of spaces.

If you would like 'entab' run on the Perl files, let me know.

Whatever perltidy emits is fine with me, but should we consider passing
-et=4 to perltidy?

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

#5Bruce Momjian
bruce@momjian.us
In reply to: Alvaro Herrera (#4)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Mon, Jun 11, 2012 at 12:20:13PM -0400, Alvaro Herrera wrote:

Hm, does this touch stuff that would also be modified by perltidy? I
wonder if we should refrain from doing entab/detab on perl files and
instead have perltidy touch such code.

The Perl files were modified by perltidy and not by pgindent, as
documented in the pgindent README:

9) Indent the Perl MSVC code:

cd src/tools/msvc
perltidy -b -bl -nsfs -naws -l=100 -ole=unix *.pl *.pm

Oh, I see. That's great then. Should those change be committed
separately, just to avoid confusion? BTW those aren't the only Perl

Not sure. I just followed the README instructions. I should just
probably mention the Perl files were not processed by pgindent on the
commit.

files in the source tree -- we also have the genbki stuff, for example.
(There is already some inconsistency in tabs/spaces in genbki.pl
already)

I was not aware of them. If you want them run, would you update the
pgindent README to mention them please?

Perhaps the thing to do is ensure that perltidy also uses tabs instead
of spaces.

If you would like 'entab' run on the Perl files, let me know.

Whatever perltidy emits is fine with me, but should we consider passing
-et=4 to perltidy?

No idea. I do not work in those files enough to have an opinion.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

#6Alvaro Herrera
alvherre@commandprompt.com
In reply to: Bruce Momjian (#5)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

Excerpts from Bruce Momjian's message of lun jun 11 15:44:16 -0400 2012:

On Mon, Jun 11, 2012 at 12:20:13PM -0400, Alvaro Herrera wrote:

Hm, does this touch stuff that would also be modified by perltidy? I
wonder if we should refrain from doing entab/detab on perl files and
instead have perltidy touch such code.

The Perl files were modified by perltidy and not by pgindent, as
documented in the pgindent README:

9) Indent the Perl MSVC code:

cd src/tools/msvc
perltidy -b -bl -nsfs -naws -l=100 -ole=unix *.pl *.pm

Oh, I see. That's great then. Should those change be committed
separately, just to avoid confusion? BTW those aren't the only Perl

Not sure. I just followed the README instructions. I should just
probably mention the Perl files were not processed by pgindent on the
commit.

Well, you wrote the instructions yourself :-)

files in the source tree -- we also have the genbki stuff, for example.
(There is already some inconsistency in tabs/spaces in genbki.pl
already)

I was not aware of them. If you want them run, would you update the
pgindent README to mention them please?

What about something like this in the root of the tree:
find . -name \*.pl -o -name \*.pm | xargs perltidy -b -bl -nsfs -naws -l=100 -ole=unix

There are files all over the place. The file that would most be
affected with one run of this is the ECPG grammar generator.

I checked the "-et=4" business (which is basically entab). We're pretty
inconsistent about tabs in perl code it seems; some files use tabs
others use spaces. Honestly I would just settle on what we use on C
files, even if the Perl devs don't recommend it "because of
maintainability and portability". I mean if it works well for us for C
code, why would it be a problem in Perl code? However, I don't write
much of that Perl code myself.

Perhaps the thing to do is ensure that perltidy also uses tabs instead
of spaces.

If you would like 'entab' run on the Perl files, let me know.

Whatever perltidy emits is fine with me, but should we consider passing
-et=4 to perltidy?

No idea. I do not work in those files enough to have an opinion.

What do others think? Maybe I'm just being obnoxious here for no useful
gain.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

#7Robert Haas
robertmhaas@gmail.com
In reply to: Alvaro Herrera (#6)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Mon, Jun 11, 2012 at 5:57 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:

What do others think?  Maybe I'm just being obnoxious here for no useful
gain.

I don't think you're being obnoxious; and I also agree with you on the
substance of the issue.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

#8Bruce Momjian
bruce@momjian.us
In reply to: Alvaro Herrera (#6)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Mon, Jun 11, 2012 at 05:57:41PM -0400, Alvaro Herrera wrote:

Excerpts from Bruce Momjian's message of lun jun 11 15:44:16 -0400 2012:

On Mon, Jun 11, 2012 at 12:20:13PM -0400, Alvaro Herrera wrote:

Hm, does this touch stuff that would also be modified by perltidy? I
wonder if we should refrain from doing entab/detab on perl files and
instead have perltidy touch such code.

The Perl files were modified by perltidy and not by pgindent, as
documented in the pgindent README:

9) Indent the Perl MSVC code:

cd src/tools/msvc
perltidy -b -bl -nsfs -naws -l=100 -ole=unix *.pl *.pm

Oh, I see. That's great then. Should those change be committed
separately, just to avoid confusion? BTW those aren't the only Perl

Not sure. I just followed the README instructions. I should just
probably mention the Perl files were not processed by pgindent on the
commit.

Well, you wrote the instructions yourself :-)

Well, initially, yes, but others have improved them over time.

files in the source tree -- we also have the genbki stuff, for example.
(There is already some inconsistency in tabs/spaces in genbki.pl
already)

I was not aware of them. If you want them run, would you update the
pgindent README to mention them please?

What about something like this in the root of the tree:
find . -name \*.pl -o -name \*.pm | xargs perltidy -b -bl -nsfs -naws -l=100 -ole=unix

There are files all over the place. The file that would most be
affected with one run of this is the ECPG grammar generator.

Sounds like a good idea to me.

I checked the "-et=4" business (which is basically entab). We're pretty
inconsistent about tabs in perl code it seems; some files use tabs
others use spaces. Honestly I would just settle on what we use on C
files, even if the Perl devs don't recommend it "because of
maintainability and portability". I mean if it works well for us for C
code, why would it be a problem in Perl code? However, I don't write
much of that Perl code myself.

Yes, I would love to hear a Perl person chime in here to tell us it is
OK, as you stated.

I suppose if we don't get any feedback in a few days, let's just go
ahead and make the changes you suggested.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

#9Noah Misch
noah@leadboat.com
In reply to: Alvaro Herrera (#6)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Mon, Jun 11, 2012 at 05:57:41PM -0400, Alvaro Herrera wrote:

What about something like this in the root of the tree:
find . -name \*.pl -o -name \*.pm | xargs perltidy -b -bl -nsfs -naws -l=100 -ole=unix

There are files all over the place. The file that would most be
affected with one run of this is the ECPG grammar generator.

I checked the "-et=4" business (which is basically entab). We're pretty
inconsistent about tabs in perl code it seems; some files use tabs
others use spaces. Honestly I would just settle on what we use on C
files, even if the Perl devs don't recommend it "because of
maintainability and portability". I mean if it works well for us for C
code, why would it be a problem in Perl code? However, I don't write
much of that Perl code myself.

+1 for formatting all our Perl scripts and for including -et=4. Since that
will rewrite currently-tidy files anyway, this is a good time to audit our
perltidy settings.

Why -l=100 instead of -l=78 like our C code?

perltidy changes this code:

for ($long_variable_name_to_initialize = 0;
$long_variable_name_to_initialize < $long_limit_variable_name;
$long_variable_name_to_initialize++)
{

to this:

for (
$long_variable_name_to_initialize = 0;
$long_variable_name_to_initialize < $long_limit_variable_name;
$long_variable_name_to_initialize++
)
{

Using -vtc=2 removes the new trailing line break. Additionally using "-vt=2
-nsak=for" removes the new leading line break, but it also removes the space
between "for" and "(". Anyone know how to make perltidy format this like we
do in C code?

Why -naws? I would lean toward "-aws -dws -pt=2" to change code like this:

-my $dbi=DBI->connect('DBI:Pg:dbname='.$opt{d});
+my $dbi = DBI->connect('DBI:Pg:dbname=' . $opt{d});

I'd also consider -kbl=2 to preserve runs of blank lines that the author used
to delineate related groups of functions.

Thanks,
nm

#10Bruce Momjian
bruce@momjian.us
In reply to: Noah Misch (#9)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Tue, Jun 12, 2012 at 01:50:48PM -0400, Noah Misch wrote:

On Mon, Jun 11, 2012 at 05:57:41PM -0400, Alvaro Herrera wrote:

What about something like this in the root of the tree:
find . -name \*.pl -o -name \*.pm | xargs perltidy -b -bl -nsfs -naws -l=100 -ole=unix

There are files all over the place. The file that would most be
affected with one run of this is the ECPG grammar generator.

I checked the "-et=4" business (which is basically entab). We're pretty
inconsistent about tabs in perl code it seems; some files use tabs
others use spaces. Honestly I would just settle on what we use on C
files, even if the Perl devs don't recommend it "because of
maintainability and portability". I mean if it works well for us for C
code, why would it be a problem in Perl code? However, I don't write
much of that Perl code myself.

+1 for formatting all our Perl scripts and for including -et=4. Since that
will rewrite currently-tidy files anyway, this is a good time to audit our
perltidy settings.

OK, another open question is whether we should do any of these changes
now for 9.2/9.3 or wait for 9.3/9.4?

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

#11Robert Haas
robertmhaas@gmail.com
In reply to: Bruce Momjian (#10)
Re: Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Tue, Jun 12, 2012 at 2:02 PM, Bruce Momjian <bruce@momjian.us> wrote:

On Tue, Jun 12, 2012 at 01:50:48PM -0400, Noah Misch wrote:

On Mon, Jun 11, 2012 at 05:57:41PM -0400, Alvaro Herrera wrote:

What about something like this in the root of the tree:
find . -name \*.pl -o -name \*.pm | xargs perltidy -b -bl -nsfs -naws -l=100 -ole=unix

There are files all over the place.  The file that would most be
affected with one run of this is the ECPG grammar generator.

I checked the "-et=4" business (which is basically entab).  We're pretty
inconsistent about tabs in perl code it seems; some files use tabs
others use spaces.  Honestly I would just settle on what we use on C
files, even if the Perl devs don't recommend it "because of
maintainability and portability".  I mean if it works well for us for C
code, why would it be a problem in Perl code?  However, I don't write
much of that Perl code myself.

+1 for formatting all our Perl scripts and for including -et=4.  Since that
will rewrite currently-tidy files anyway, this is a good time to audit our
perltidy settings.

OK, another open question is whether we should do any of these changes
now for 9.2/9.3 or wait for 9.3/9.4?

I don't think it matters very much - very few commits touch those perl
scripts. If we have a consensus, I think it's fine to do it now, or
even after we branch.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

#12Bruce Momjian
bruce@momjian.us
In reply to: Noah Misch (#9)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Tue, Jun 12, 2012 at 01:50:48PM -0400, Noah Misch wrote:

On Mon, Jun 11, 2012 at 05:57:41PM -0400, Alvaro Herrera wrote:

What about something like this in the root of the tree:
find . -name \*.pl -o -name \*.pm | xargs perltidy -b -bl -nsfs -naws -l=100 -ole=unix

There are files all over the place. The file that would most be
affected with one run of this is the ECPG grammar generator.

I checked the "-et=4" business (which is basically entab). We're pretty
inconsistent about tabs in perl code it seems; some files use tabs
others use spaces. Honestly I would just settle on what we use on C
files, even if the Perl devs don't recommend it "because of
maintainability and portability". I mean if it works well for us for C
code, why would it be a problem in Perl code? However, I don't write
much of that Perl code myself.

+1 for formatting all our Perl scripts and for including -et=4. Since that
will rewrite currently-tidy files anyway, this is a good time to audit our
perltidy settings.

Why -l=100 instead of -l=78 like our C code?

perltidy changes this code:

for ($long_variable_name_to_initialize = 0;
$long_variable_name_to_initialize < $long_limit_variable_name;
$long_variable_name_to_initialize++)
{

to this:

for (
$long_variable_name_to_initialize = 0;
$long_variable_name_to_initialize < $long_limit_variable_name;
$long_variable_name_to_initialize++
)
{

Using -vtc=2 removes the new trailing line break. Additionally using "-vt=2
-nsak=for" removes the new leading line break, but it also removes the space
between "for" and "(". Anyone know how to make perltidy format this like we
do in C code?

Why -naws? I would lean toward "-aws -dws -pt=2" to change code like this:

-my $dbi=DBI->connect('DBI:Pg:dbname='.$opt{d});
+my $dbi = DBI->connect('DBI:Pg:dbname=' . $opt{d});

I'd also consider -kbl=2 to preserve runs of blank lines that the author used
to delineate related groups of functions.

OK, based on this feedback, I have updated the pgindent README to use
these Perl indent instructions:

find . -name \*.pl -o -name \*.pm | xargs perltidy \
--backup-and-modify-in-place --opening-brace-on-new-line \
--vertical-tightness=2 --vertical-tightness-closing=2 \
--nospace-after-keyword=for --nospace-for-semicolon \
--add-whitespace --delete-old-whitespace --paren-tightness=2 \
--keep-old-blank-lines=2 --maximum-line-length=78 \
--entab-leading-whitespace=4 --output-line-ending=unix

Unless I hear otherwise, I will run this new command on the 9.2 and HEAD
Perl files.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

#13Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#12)
Re: Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

Bruce Momjian <bruce@momjian.us> writes:

OK, based on this feedback, I have updated the pgindent README to use
these Perl indent instructions:

find . -name \*.pl -o -name \*.pm | xargs perltidy \
--backup-and-modify-in-place --opening-brace-on-new-line \
--vertical-tightness=2 --vertical-tightness-closing=2 \
--nospace-after-keyword=for --nospace-for-semicolon \
--add-whitespace --delete-old-whitespace --paren-tightness=2 \
--keep-old-blank-lines=2 --maximum-line-length=78 \
--entab-leading-whitespace=4 --output-line-ending=unix

Unless I hear otherwise, I will run this new command on the 9.2 and HEAD
Perl files.

No idea what all that stuff does. Would it be reasonable to post a diff
showing what this would do to the files in question?

regards, tom lane

#14Bruce Momjian
bruce@momjian.us
In reply to: Tom Lane (#13)
Re: Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Fri, Jun 15, 2012 at 10:48:27PM -0400, Tom Lane wrote:

Bruce Momjian <bruce@momjian.us> writes:

OK, based on this feedback, I have updated the pgindent README to use
these Perl indent instructions:

find . -name \*.pl -o -name \*.pm | xargs perltidy \
--backup-and-modify-in-place --opening-brace-on-new-line \
--vertical-tightness=2 --vertical-tightness-closing=2 \
--nospace-after-keyword=for --nospace-for-semicolon \
--add-whitespace --delete-old-whitespace --paren-tightness=2 \
--keep-old-blank-lines=2 --maximum-line-length=78 \
--entab-leading-whitespace=4 --output-line-ending=unix

Unless I hear otherwise, I will run this new command on the 9.2 and HEAD
Perl files.

No idea what all that stuff does. Would it be reasonable to post a diff
showing what this would do to the files in question?

Sure:

http://momjian.us/expire/perl.diff

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

#15Noah Misch
noah@leadboat.com
In reply to: Bruce Momjian (#12)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Fri, Jun 15, 2012 at 10:45:16PM -0400, Bruce Momjian wrote:

I have updated the pgindent README to use
these Perl indent instructions:

find . -name \*.pl -o -name \*.pm | xargs perltidy \
--backup-and-modify-in-place --opening-brace-on-new-line \
--vertical-tightness=2 --vertical-tightness-closing=2 \
--nospace-after-keyword=for --nospace-for-semicolon \
--add-whitespace --delete-old-whitespace --paren-tightness=2 \
--keep-old-blank-lines=2 --maximum-line-length=78 \
--entab-leading-whitespace=4 --output-line-ending=unix

I would lean against using --nospace-after-keyword=for. Not using it means we
get wrong formatting when the for-loop conditions span multiple lines. Using
it means we get wrong formatting (albeit less severe) on every for-loop. In
any event, if we do use it for for-loops, we should probably use it for all
control structure keywords.

Otherwise, I like this.

As a last idle idea, how about putting the options in a configuration file and
passing --profile= as the only option? Besides keeping you from copying a
7-line shell command, this has the benefit of ignoring any ~/.perltidyrc.

Thanks,
nm

#16Bruce Momjian
bruce@momjian.us
In reply to: Noah Misch (#15)
Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Sat, Jun 16, 2012 at 01:10:31AM -0400, Noah Misch wrote:

On Fri, Jun 15, 2012 at 10:45:16PM -0400, Bruce Momjian wrote:

I have updated the pgindent README to use
these Perl indent instructions:

find . -name \*.pl -o -name \*.pm | xargs perltidy \
--backup-and-modify-in-place --opening-brace-on-new-line \
--vertical-tightness=2 --vertical-tightness-closing=2 \
--nospace-after-keyword=for --nospace-for-semicolon \
--add-whitespace --delete-old-whitespace --paren-tightness=2 \
--keep-old-blank-lines=2 --maximum-line-length=78 \
--entab-leading-whitespace=4 --output-line-ending=unix

I would lean against using --nospace-after-keyword=for. Not using it means we
get wrong formatting when the for-loop conditions span multiple lines. Using
it means we get wrong formatting (albeit less severe) on every for-loop. In
any event, if we do use it for for-loops, we should probably use it for all
control structure keywords.

Agreed, good point.

Otherwise, I like this.

As a last idle idea, how about putting the options in a configuration file and
passing --profile= as the only option? Besides keeping you from copying a
7-line shell command, this has the benefit of ignoring any ~/.perltidyrc.

Also agreed, and change made. Perltidyrc now has:

--add-whitespace
--backup-and-modify-in-place
--delete-old-whitespace
--entab-leading-whitespace=4
--keep-old-blank-lines=2
--maximum-line-length=78
--nospace-for-semicolon
--opening-brace-on-new-line
--output-line-ending=unix
--paren-tightness=2
--vertical-tightness=2
--vertical-tightness-closing=2

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

#17Bruce Momjian
bruce@momjian.us
In reply to: Robert Haas (#11)
Re: Re: [COMMITTERS] pgsql: Run pgindent on 9.2 source tree in preparation for first 9.3

On Tue, Jun 12, 2012 at 02:40:09PM -0400, Robert Haas wrote:

On Tue, Jun 12, 2012 at 2:02 PM, Bruce Momjian <bruce@momjian.us> wrote:

On Tue, Jun 12, 2012 at 01:50:48PM -0400, Noah Misch wrote:

On Mon, Jun 11, 2012 at 05:57:41PM -0400, Alvaro Herrera wrote:

What about something like this in the root of the tree:
find . -name \*.pl -o -name \*.pm | xargs perltidy -b -bl -nsfs -naws -l=100 -ole=unix

There are files all over the place. �The file that would most be
affected with one run of this is the ECPG grammar generator.

I checked the "-et=4" business (which is basically entab). �We're pretty
inconsistent about tabs in perl code it seems; some files use tabs
others use spaces. �Honestly I would just settle on what we use on C
files, even if the Perl devs don't recommend it "because of
maintainability and portability". �I mean if it works well for us for C
code, why would it be a problem in Perl code? �However, I don't write
much of that Perl code myself.

+1 for formatting all our Perl scripts and for including -et=4. �Since that
will rewrite currently-tidy files anyway, this is a good time to audit our
perltidy settings.

OK, another open question is whether we should do any of these changes
now for 9.2/9.3 or wait for 9.3/9.4?

I don't think it matters very much - very few commits touch those perl
scripts. If we have a consensus, I think it's fine to do it now, or
even after we branch.

Done. Run on HEAD and 9.2 --- sorry for the delay.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +