PostgreSQL > pgsql-committers > July 2013

Add GET DIAGNOSTICS ... PG_CONTEXT in PL/PgSQL This adds the ability to get the call stack as a string from within a PL/PgSQL function, which can be handy for logging to a table, or to include in a ...

pg_upgrade: document possible pg_hba.conf options Previously, pg_upgrade docs recommended using .pgpass if using MD5 authentication to avoid being prompted for a password. Turns out pg_ctl never ...

Fix regex match failures for backrefs combined with non-greedy quantifiers. An ancient logic error in cfindloop() could cause the regex engine to fail to find matches that begin later than the start ...

Fix regexp_matches() handling of zero-length matches. We'd find the same match twice if it was of zero length and not immediately adjacent to the previous match. replace_text_regexp() got similar ...

Fix contrib/cube and contrib/seg to build with bison 3.0. These modules used the YYPARSE_PARAM macro, which has been deprecated by the bison folk since 1.875, and which they finally removed in 3.0 ...

Fix booltestsel() for case where we have NULL stats but not MCV stats. In a boolean column that contains mostly nulls, ANALYZE might not find enough non-null values to populate the most-common-values ...

Check for NULL result from strdup Per Coverity Scan Branch ------ REL9_1_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/15fdf7302a99b0f63394bc49c2528b4731a6627e Modified Files ...

Change post-rewriter representation of dropped columns in joinaliasvars. It's possible to drop a column from an input table of a JOIN clause in a view, if that column is nowhere actually referenced ...

doc: Fix typos in conversion names. David Christensen Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/c8fb821afc2ce37b48b678251480b52e6b116868 Modified Files ...

Initialize day of year value. There are cases where the day of year value in struct tm is used, but it never got calculated. Problem found by Coverity scan. Branch ------ REL8_4_STABLE Details ...

Ensure 64bit arithmetic when calculating tapeSpace In tuplesort.c:inittapes(), we calculate tapeSpace by first figuring out how many 'tapes' we can use (maxTapes) and then multiplying the result by ...

Also escape double quotes for ECPG's #line statement. Branch ------ REL9_0_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/6b51f659c051167ae20b33c373451bb69e403ab7 Modified Files ...

Mention extra_float_digits in floating point docs Make it easier for readers of the FP docs to find out about possibly truncated values. Per complaint from Tom Duffey in message <span ...

Improve support for building PGXS modules with VPATH. A VPATH build will be performed when the module's make file path is not the current directory or when USE_VPATH is set. This will assist ...

Restore REINDEX constraint validation. Refactoring as part of commit 8ceb24568054232696dddc1166a8563bc78c900a had the unintended effect of making REINDEX TABLE and REINDEX DATABASE no longer validate ...

Fix include-guard Looks like a cut/paste error in the original addition of the file. Andres Freund Branch ------ REL9_0_STABLE Details ------- ...

Applied patch by MauMau to escape filenames in #line statements. Branch ------ REL8_4_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/434943d57608c0d51490c7400363ede8c6a278f2 Modified ...

Expose the estimation of number of changed tuples since last analyze This value, now pg_stat_all_tables.n_mod_since_analyze, was already tracked and used by autovacuum, but not exposed to the user ...

Fix configure probe for sys/ucred.h. The configure script's test for <sys/ucred.h did not work on OpenBSD, because on that platform <sys/param.h has to be included first. As a result, socket peer ...

Fix a few problems in barrier.h. On HPPA, implement pg_memory_barrier() as pg_compiler_barrier(), which should be correct since this arch doesn't do memory access reordering, and is anyway better ...

Remove stray | character Erikjan Rijkers Branch ------ REL9_1_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/456d37a0bfaf22ecd5c7e86778595278b32f43f8 Modified Files -------------- ...

Fix inaccurate description of tablespace. Currently we don't need to update the pg_tablespace catalog after redefining the symbolic links to the tablespaces because pg_tablespace.spclocation column ...

Fix error handling in PLy_spi_execute_fetch_result(). If an error is thrown out of the datatype I/O functions called by this function, we need to do subtransaction cleanup, which the previous coding ...

Use correct parameter name for view_option_value The documentation for ALTER VIEW had a minor copy-and-paste error in defining the parameters. Noticed when reviewing the WITH CHECK OPTION patch ...

Correct off-by-one when reading from pipe In pg_basebackup.c:reached_end_position(), we're reading from an internal pipe with our own background process but we're possibly reading more bytes than ...

Fixed incorrect description of EXEC SQL VAR command. Thanks to MauMau <<span class="m_body_email_addr" title="f001e2544f0ccde156c17199fd374e25" maumau307@gmail.com</span for finding and fixing this ...

Fix planning of parameterized appendrel paths with expensive join quals. The code in set_append_rel_pathlist() for building parameterized paths for append relations (inheritance and UNION ALL ...

pg_buffercache: document column meanings Improve documentation for usagecount and relforknumber. Backpatch to 9.3. Suggestion from Satoshi Nagayasu Branch ------ REL9_2_STABLE Details ------- ...

Silence compiler warning in assertion-enabled builds. With -Wtype-limits, gcc correctly points out that size_t can never be < 0. Backpatch to 9.3 and 9.2. It's been like this forever, but in <= 9.1 ...

Fix mis-indented lines Per Coverity Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/a59516b6311a6c2acc89448c94913ebae598f02a Modified Files -------------- ...

Fix typo in comment. Michael Paquier Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/7842d41df56ab8ad9aff76bc5bd8e96c3d215cde Modified Files -------------- ...

pg_upgrade: clarify C comment about Windows thread struct pointers Backpatch to 9.3 to keep source trees consistent. Branch ------ REL9_3_STABLE Details ------- ...

WITH CHECK OPTION support for auto-updatable VIEWs For simple views which are automatically updatable, this patch allows the user to specify what level of checking should be done on records being ...

Message style improvements Branch ------ REL9_3_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/faee8f1a714f24e85ba5fa1018b22f9681b5d657 Modified Files -------------- ...

pg_upgrade: fix -j race condition on Windows Pg_Upgrade cannot write the command string to the log file and then call system() to write to the same file without causing occasional file-share errors ...

pg_upgrade docs: don't use cluster for binary/lib In a few cases, pg_upgrade said old/new cluster location when it meant old/new Postgres install location, so fix those. Per private email report ...

Prevent leakage of SPI tuple tables during subtransaction abort. plpgsql often just remembers SPI-result tuple tables in local variables, and has no mechanism for freeing them if an ereport(ERROR) ...

pg_upgrade: adjust umask() calls Since pg_upgrade -j on Windows uses threads, calling umask() before/after opening a file via fopen_priv() is no longer possible, so set umask() as we enter the ...

pg_upgrade: fix initialization of thread argument Reorder initialization of thread argument marker to it happens before reap_child() is called. Backpatch to 9.3. Branch ------ REL9_3_STABLE Details ...

Improve ilist.h's support for deletion of slist elements during iteration. Previously one had to use slist_delete(), implying an additional scan of the list, making this infrastructure considerably ...

pg_upgrade: more Windows parallel/-j fixes More fixes to handle Windows thread parameter passing. Backpatch to 9.3 beta. Patch originally from Andrew Dunstan Branch ------ REL9_3_STABLE Details ...

pg_upgrade: fix parallel/-j crash on Windows This fixes the problem of passing the wrong function pointer when doing parallel copy/link operations on Windows. Backpatched to 9.3beta. Found and patch ...

Further hacking on ruleutils' new column-alias-assignment code. After further thought about implicit coercions appearing in a joinaliasvars list, I realized that they represent an additional reason ...

Tweak FOR UPDATE/SHARE error message wording (again) In commit 0ac5ad5134 I changed some error messages from "FOR UPDATE/SHARE" to a rather long gobbledygook which nobody liked. Then, in commit ...

doc: Remove tab from SGML file Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/e8b1d1befeab17453eb2977e83a45649e6ed8790 Modified Files -------------- ...

Remove bgw_sighup and bgw_sigterm. Per discussion on pgsql-hackers, these aren't really needed. Interim versions of the background worker patch had the worker starting with signals already unblocked, ...

Clean up new JSON API typedefs The new JSON API uses a bit of an unusual typedef scheme, where for example OkeysState is a pointer to okeysState. And that's not applied consistently either. Change ...

Fix HeapTupleSatisfiesVacuum on aborted updater xacts By using only the macro that checks infomask bits HEAP_XMAX_IS_LOCKED_ONLY to verify whether a multixact is not an updater, and not the full ...

Allow background workers to be started dynamically. There is a new API, RegisterDynamicBackgroundWorker, which allows an ordinary user backend to register a new background writer during normal ...

Fix PQconninfoParse error message handling The returned error message already includes a newline, but the callers were adding their own when printing it out. Branch ------ master Details ------- ...