5f3c54a | Marc G. Fournier | 30 July 2010, 03:31:41 UTC | tag for beta4 | 30 July 2010, 03:31:41 UTC |
c902ad9 | Tom Lane | 29 July 2010, 23:16:41 UTC | Improved version of patch to protect pg_get_expr() against misuse: look through join alias Vars to avoid breaking join queries, and move the test to someplace where it will catch more possible ways of calling a function. We still ought to throw away the whole thing in favor of a data-type-based solution, but that's not feasible in the back branches. This needs to be back-patched further than 9.0, but I don't have time to do so today. Committing now so that the fix gets into 9.0beta4. | 29 July 2010, 23:16:41 UTC |
a019437 | Tom Lane | 29 July 2010, 21:18:16 UTC | Update release notes for 9.0 beta 4. Back-patch some changes that were made only in HEAD. | 29 July 2010, 21:18:16 UTC |
33e142e | Tom Lane | 29 July 2010, 20:09:34 UTC | Clean up some inconsistencies in the volatility marking of various I/O related functions. Per today's discussion, we will henceforth assume that datatype I/O functions are either stable or immutable, never volatile. (This implies in particular that domain CHECK constraint expressions shouldn't be volatile, since domain_in executes them.) In turn, functions that execute the I/O functions of arbitrary datatypes should always be labeled stable. This affects the labeling of array_to_string, which was unsafely marked immutable, and record_in, record_out, record_recv, record_send, domain_in, domain_recv, which were over-conservatively marked volatile. The array I/O functions were already marked stable, which is correct per this policy but would have been wrong if we maintained domain_in as volatile. Back-patch to 9.0, along with an earlier fix to correctly mark cash_in and cash_out as stable not immutable (since they depend on lc_monetary). No catversion bump --- the implications of this are not currently severe enough to justify a forced initdb. | 29 July 2010, 20:09:34 UTC |
a6c243e | Peter Eisentraut | 29 July 2010, 19:39:47 UTC | Translation updates for 9.0beta4 | 29 July 2010, 19:39:47 UTC |
8508402 | Peter Eisentraut | 29 July 2010, 19:34:37 UTC | Fix indentation of verbatim block elements Block elements with verbatim formatting (literallayout, programlisting, screen, synopsis) should be aligned at column 0 independent of the surrounding SGML, because whitespace is significant, and indenting them creates erratic whitespace in the output. The CSS stylesheets already take care of indenting the output. Assorted markup improvements to go along with it. | 29 July 2010, 19:34:37 UTC |
c04b3f4 | Tom Lane | 29 July 2010, 19:23:28 UTC | Fix another longstanding problem in copy_relation_data: it was blithely assuming that a local char[] array would be aligned on at least a word boundary. There are architectures on which that is pretty much guaranteed to NOT be the case ... and those arches also don't like non-aligned memory accesses, meaning that log_newpage() would crash if it ever got invoked. Even on Intel-ish machines there's a potential for a large performance penalty from doing I/O to an inadequately aligned buffer. So palloc it instead. Backpatch to 8.0 --- 7.4 doesn't have this code. | 29 July 2010, 19:23:28 UTC |
19600de | Tom Lane | 29 July 2010, 18:29:57 UTC | Work around a documentation toolchain problem by replacing the "AIX-fixlevels" table with a <variablelist> carrying the same information. Previously the 9.0 documentation was failing to build as a US-size PDF file. It's quite obscure what the real problem is or why this avoids it, but we need a hack now so we can build docs for beta4. In passing do a bit of editing in the AIX installation docs, in particular remove a long-obsolete claim that the regression tests are likely to fail. | 29 July 2010, 18:29:57 UTC |
7958520 | Robert Haas | 29 July 2010, 16:14:45 UTC | Fix possible page corruption by ALTER TABLE .. SET TABLESPACE. If a zeroed page is present in the heap, ALTER TABLE .. SET TABLESPACE will set the LSN and TLI while copying it, which is wrong, and heap_xlog_newpage() will do the same thing during replay, so the corruption propagates to any standby. Note, however, that the bug can't be demonstrated unless archiving is enabled, since in that case we skip WAL logging altogether, and the LSN/TLI are not set. Back-patch to 8.0; prior releases do not have tablespaces. Analysis and patch by Jeff Davis. Adjustments for back-branches and minor wordsmithing by me. | 29 July 2010, 16:14:45 UTC |
40cacbb | Peter Eisentraut | 28 July 2010, 20:34:12 UTC | Remove wildly obsolete type attribute externallength from chkpass | 28 July 2010, 20:34:12 UTC |
e4d495a | Tom Lane | 28 July 2010, 17:22:03 UTC | Fix oversight in new EvalPlanQual logic: the second loop over the ExecRowMark list in ExecLockRows() forgot to allow for the possibility that some of the rowmarks are for child tables that aren't relevant to the current row. Per report from Kenichiro Tanaka. | 28 July 2010, 17:22:03 UTC |
a2164c2 | Tom Lane | 28 July 2010, 04:50:59 UTC | Fix potential failure when hashing the output of a subplan that produces a pass-by-reference datatype with a nontrivial projection step. We were using the same memory context for the projection operation as for the temporary context used by the hashtable routines in execGrouping.c. However, the hashtable routines feel free to reset their temp context at any time, which'd lead to destroying input data that was still needed. Report and diagnosis by Tao Ma. Back-patch to 8.1, where the problem was introduced by the changes that allowed us to work with "virtual" tuples instead of materializing intermediate tuple values everywhere. The earlier code looks quite similar, but it doesn't suffer the problem because the data gets copied into another context as a result of having to materialize ExecProject's output tuple. | 28 July 2010, 04:50:59 UTC |
d8c546c | Peter Eisentraut | 28 July 2010, 04:39:15 UTC | Show psql timing output even in quiet mode These two settings ought to be independent of each other. | 28 July 2010, 04:39:15 UTC |
43d3d2a | Robert Haas | 27 July 2010, 20:02:17 UTC | Fix typo in PL/pgsql code example. Backpatch to 8.4. Marc Cousin. Review by Kevin Grittner. | 27 July 2010, 20:02:17 UTC |
b8174bc | Peter Eisentraut | 27 July 2010, 19:01:04 UTC | Spelling fixes | 27 July 2010, 19:01:04 UTC |
4aa14fe | Alvaro Herrera | 27 July 2010, 04:18:31 UTC | Ensure $_SHARED is declared in the main:: namespace, per bugs #5570 and #5571. Author: Alex Hunsaker | 27 July 2010, 04:18:31 UTC |
65ad4e3 | Peter Eisentraut | 26 July 2010, 20:28:35 UTC | Fix grammar backpatched to 8.1 | 26 July 2010, 20:28:35 UTC |
478a890 | Peter Eisentraut | 26 July 2010, 20:14:06 UTC | Add table creation and population to example from John Gage | 26 July 2010, 20:14:06 UTC |
c12c561 | Peter Eisentraut | 25 July 2010, 08:30:41 UTC | Add INSERT statement to example so that it can be reproduced from John Gage | 25 July 2010, 08:30:41 UTC |
8dad931 | Bruce Momjian | 25 July 2010, 03:47:33 UTC | Adjust check_for_isn_and_int8_passing_mismatch() so it is called for all migrations. Backpatch to 9.0. | 25 July 2010, 03:47:33 UTC |
ca2901c | Bruce Momjian | 25 July 2010, 03:28:39 UTC | Prevent pg_upgrade from migrating databases that use reg* data types where the oid is not preserved by pg_upgrade (everything but pg_type). Update documentation. Per bug report from depstein@alliedtesting.com. | 25 July 2010, 03:28:39 UTC |
417718d | Peter Eisentraut | 24 July 2010, 16:46:43 UTC | Fix typo | 24 July 2010, 16:46:43 UTC |
730fba4 | Peter Eisentraut | 24 July 2010, 12:17:34 UTC | Tidy up boolean data type page by Thom Brown | 24 July 2010, 12:17:34 UTC |
3d903da | Peter Eisentraut | 23 July 2010, 20:04:09 UTC | Add more checks against altering typed tables - Prohibit altering column type - Prohibit changing inheritance - Move checks from Exec to Prep phases in ALTER TABLE code backpatched to 9.0 | 23 July 2010, 20:04:09 UTC |
f53eeec | Robert Haas | 23 July 2010, 00:43:09 UTC | Avoid deep recursion when assigning XIDs to multiple levels of subxacts. Backpatch to 8.0. Andres Freund, with cleanup and adjustment for older branches by me. | 23 July 2010, 00:43:09 UTC |
db64a9d | Bruce Momjian | 20 July 2010, 18:14:25 UTC | Properly replay CREATE TABLESPACE during crash recovery by deleting directory/symlink before creation. Report from Tom Lane. Backpatch to 9.0. | 20 July 2010, 18:14:25 UTC |
ee9324b | Tom Lane | 18 July 2010, 23:43:37 UTC | Remove unnecessary "Not safe to send CSV data" complaint from elog.c's fallback path when CSV logging is configured but not yet operational. It's sufficient to send the message to stderr, as we were already doing, and the "Not safe" gripe has already confused at least two core members ... Backpatch to 9.0, but not further --- doesn't seem appropriate to change this behavior in stable branches. | 18 July 2010, 23:43:37 UTC |
e6dff0a | Tom Lane | 18 July 2010, 19:37:57 UTC | Allow ORDER BY/GROUP BY/etc items to match targetlist items regardless of any implicit casting previously applied to the targetlist item. This is reasonable because the implicit cast, by definition, wasn't written by the user; so we are preserving the expected behavior that ORDER BY items match textually equivalent tlist items. The case never arose before because there couldn't be any implicit casting of a top-level SELECT item before we process ORDER BY etc. But now it can arise in the context of aggregates containing ORDER BY clauses, since the "targetlist" is the already-casted list of arguments for the aggregate. The net effect is that the datatype used for ORDER BY/DISTINCT purposes is the aggregate's declared input type, not that of the original input column; which is a bit debatable but not horrendous, and to do otherwise would require major rework that doesn't seem justified. Per bug #5564 from Daniel Grace. Back-patch to 9.0 where aggregate ORDER BY was implemented. | 18 July 2010, 19:37:57 UTC |
1051958 | Heikki Linnakangas | 16 July 2010, 11:36:10 UTC | Fix typo spotted by Thom Brown. | 16 July 2010, 11:36:10 UTC |
1dc124e | Heikki Linnakangas | 16 July 2010, 11:21:46 UTC | Add a paragraph explaining what restartpoints are. Mention that wal_keep_segments does not take effect during recovery. Fujii Masao | 16 July 2010, 11:21:46 UTC |
d3cf0b6 | Tom Lane | 14 July 2010, 22:04:28 UTC | Use an <xref> for restore_command reference. Marko Tiikkaja | 14 July 2010, 22:04:28 UTC |
fa2dbb6 | Tom Lane | 14 July 2010, 21:21:16 UTC | Fix several problems in pg_dump's handling of SQL/MED objects, notably failure to dump a PUBLIC user mapping correctly, as per bug #5560 from Shigeru Hanada. Use the pg_user_mappings view rather than trying to access pg_user_mapping directly, so that the code doesn't fail when run by a non-superuser. And clean up some minor carelessness such as unsafe usage of fmtId(). Back-patch to 8.4 where this code was added. | 14 July 2010, 21:21:16 UTC |
89ddf54 | Tom Lane | 14 July 2010, 17:09:54 UTC | Allow full SSL certificate verification (wherein libpq checks its host name parameter against server cert's CN field) to succeed in the case where both host and hostaddr are specified. As with the existing precedents for Kerberos, GSSAPI, SSPI, it is the calling application's responsibility that host and hostaddr match up --- we just use the host name as given. Per bug #5559 from Christopher Head. In passing, make the error handling and messages for the no-host-name-given failure more consistent among these four cases, and correct a lie in the documentation: we don't attempt to reverse-lookup host from hostaddr if host is missing. Back-patch to 8.4 where SSL cert verification was introduced. | 14 July 2010, 17:09:54 UTC |
f53bc2e | Bruce Momjian | 13 July 2010, 20:15:51 UTC | Backpatch pg_upgrade fixes to 9.0: In pg_upgrade, prevent psql AUTOCOMMIT=off by not loading .psqlrc. In pg_upgrade, report /bin directory checks independent of /data checks. Remove incorrect email address for pg_upgrade bug reports. On Win32, pg_upgrade cannot sent any server log output to the log file because of file access limitations on that platform. | 13 July 2010, 20:15:51 UTC |
41252a1 | Heikki Linnakangas | 13 July 2010, 09:02:35 UTC | Oops, in the previous fix to prevent a cursor that's being used in a FOR loop from being dropped, I missed subtransaction cleanup. Pinned portals must be dropped at subtransaction cleanup just as they are at main transaction cleanup. Per bug #5556 by Robert Walker. Backpatch to 8.0, 7.4 didn't have subtransactions. | 13 July 2010, 09:02:35 UTC |
913f902 | Robert Haas | 10 July 2010, 00:50:37 UTC | Clarify that "psql -c" ignores psqlrc files. Tim Landscheidt | 10 July 2010, 00:50:37 UTC |
8e60c24 | Tom Lane | 09 July 2010, 22:57:47 UTC | Avoid an Assert failure in deconstruct_array() by making get_attstatsslot() use the actual element type of the array it's disassembling, rather than trusting the type OID passed in by its caller. This is needed because sometimes the planner passes in a type OID that's only binary-compatible with the target column's type, rather than being an exact match. Per an example from Bernd Helmle. Possibly we should refactor get_attstatsslot/free_attstatsslot to not expect the caller to supply type ID data at all, but for now I'll just do the minimum-change fix. Back-patch to 7.4. Bernd's test case only crashes back to 8.0, but since these subroutines are the same in 7.4, I suspect there may be variant cases that would crash 7.4 as well. | 09 July 2010, 22:57:47 UTC |
e5b8e86 | Tom Lane | 09 July 2010, 21:11:57 UTC | Fix ruleutils' get_variable() to print something useful for Vars referencing resjunk outputs of subquery tlists, instead of throwing an error. Per bug #5548 from Daniel Grace. We might at some point find we ought to back-patch this further than 9.0, but I think that such Vars can only occur as resjunk members of upper-level tlists, in which case the problem can't arise because prior versions didn't print resjunk tlist items in EXPLAIN VERBOSE. | 09 July 2010, 21:11:57 UTC |
beed55d | Bruce Momjian | 09 July 2010, 16:51:29 UTC | Properly report errno/out-of-disk-space error from pg_upgrade when in copy mode, per report from depstein@alliedtesting.com. Patch suggestion from Magnus. Backpatch to 9.0.X. | 09 July 2010, 16:51:29 UTC |
1084f31 | Marc G. Fournier | 09 July 2010, 02:43:12 UTC | tag beta3 | 09 July 2010, 02:43:12 UTC |
c4314e1 | Bruce Momjian | 08 July 2010, 22:26:14 UTC | Update release notes for 9.0 beta 3. | 08 July 2010, 22:26:14 UTC |
4b7f50e | Peter Eisentraut | 08 July 2010, 21:35:33 UTC | Some small changes for plperl.sgml: - wrapped long code-lines, for pdf - typo Erik Rijkers | 08 July 2010, 21:35:33 UTC |
0544c8c | Peter Eisentraut | 08 July 2010, 21:32:28 UTC | Translation updates for 9.0beta3 | 08 July 2010, 21:32:28 UTC |
6d297e0 | Tom Lane | 08 July 2010, 19:00:11 UTC | Minor kibitzing on previous patch: no need to run check more than once. (_PG_init should be called only once anyway, but as long as it's got an internal guard against repeat calls, that should be in front of the version check.) | 08 July 2010, 19:00:11 UTC |
8037160 | Peter Eisentraut | 08 July 2010, 18:42:12 UTC | Install safeguard against running PL/Python 2 and 3 in the same session | 08 July 2010, 18:42:12 UTC |
c9b142d | Bruce Momjian | 08 July 2010, 16:44:12 UTC | Doc change: effected -> affected, per correction from Matthew Wakeling | 08 July 2010, 16:44:12 UTC |
7f88276 | Tom Lane | 08 July 2010, 16:30:13 UTC | Add a cross-reference to precedence information to CREATE OPERATOR's documentation. Per suggestion from Marc Cousin. | 08 July 2010, 16:30:13 UTC |
a64bf0a | Magnus Hagander | 08 July 2010, 16:19:50 UTC | Make the Windows tcp keepalive support depend on the existance of the SIO_KEEPALIVE_VALS define instead of just WIN32, since MingW doesn't support this API (yet?). | 08 July 2010, 16:19:50 UTC |
672efc0 | Tom Lane | 08 July 2010, 16:08:30 UTC | Update obsolete comment. Noted by Josh Tolley. | 08 July 2010, 16:08:30 UTC |
7b81782 | Tom Lane | 08 July 2010, 15:15:05 UTC | Fix variant float8 expected files to have exactly the expected spacing. This wasn't important when we used diff's -w (--ignore-all-space) option to compare regression result files, but it is now. Per buildfarm member canary, which evidently has been offline since we did that in November, but came to life again today. | 08 July 2010, 15:15:05 UTC |
44b0d16 | Magnus Hagander | 08 July 2010, 10:20:14 UTC | Add support for TCP keepalives on Windows, both for backend and the new libpq support. | 08 July 2010, 10:20:14 UTC |
d4d32ee | Tom Lane | 08 July 2010, 00:14:04 UTC | Fix "cannot handle unplanned sub-select" error that can occur when a sub-select contains a join alias reference that expands into an expression containing another sub-select. Per yesterday's report from Merlin Moncure and subsequent off-list investigation. Back-patch to 7.4. Older versions didn't attempt to flatten sub-selects in ways that would trigger this problem. | 08 July 2010, 00:14:04 UTC |
5b1b3ef | Tom Lane | 07 July 2010, 15:13:21 UTC | Adjust mbutils.c so it won't get broken by future pgindent runs. To do that, replace L'\0' by (WCHAR) 0. Perhaps someday we should teach pgindent about wide-character literals, but so long as this is the only use-case in the entire Postgres sources, a workaround seems easier. | 07 July 2010, 15:13:21 UTC |
e324348 | Bruce Momjian | 07 July 2010, 14:42:09 UTC | Document the interaction of write-barrier-enabled file systems, and BBU caches, per June email thread. | 07 July 2010, 14:42:09 UTC |
20be0d4 | Robert Haas | 06 July 2010, 22:55:26 UTC | Make log_temp_files based on kB, and revert docs & comments to match. Per extensive discussion on pgsql-hackers. We are deliberately not back-patching this even though the behavior of 8.3 and 8.4 is unquestionably broken, for fear of breaking existing users of this parameter. This incompatibility should be release-noted. | 06 July 2010, 22:55:26 UTC |
458474d | Tom Lane | 06 July 2010, 22:03:05 UTC | Accept slightly grotty coding in Makefile.global in order to keep the -L flag for src/port/ in front of any -L flags placed in LDFLAGS by configure. This undoes an L-flag-ordering change that I had thought would be safe, but seems to be making at least one buildfarm member fail --- the only theory for orca's failure that I can think of is that it's got an old copy of libpgport.a in /usr/lib. Also allow for LDFLAGS_SL to be set by contrib makefiles before they invoke Makefile.global. | 06 July 2010, 22:03:05 UTC |
46ee42b | Peter Eisentraut | 06 July 2010, 21:37:31 UTC | Add note that using PL/Python 2 and 3 in the same session will probably crash | 06 July 2010, 21:37:31 UTC |
5acd417 | Robert Haas | 06 July 2010, 21:14:25 UTC | Support setting the keepalive idle time on MacOS X. MacOS X uses TCP_KEEPALIVE rather than TCP_KEEPIDLE for this purpose. Thanks to Fujii Masao for the review. | 06 July 2010, 21:14:25 UTC |
3f12653 | Tom Lane | 06 July 2010, 21:09:00 UTC | Undo pgindent breakage (again). Per buildfarm. | 06 July 2010, 21:09:00 UTC |
9e15b47 | Bruce Momjian | 06 July 2010, 19:26:28 UTC | Mention why one C file fails pgindent. | 06 July 2010, 19:26:28 UTC |
239d769 | Bruce Momjian | 06 July 2010, 19:19:02 UTC | pgindent run for 9.0, second run | 06 July 2010, 19:19:02 UTC |
52783b2 | Bruce Momjian | 06 July 2010, 19:18:19 UTC | Update pgindent testing instructions. | 06 July 2010, 19:18:19 UTC |
8307b09 | Tom Lane | 06 July 2010, 03:55:33 UTC | Still more third thoughts: when linking shared libraries, LDFLAGS probably needs to appear before anything placed in SHLIB_LINK. This is because SHLIB_LINK is typically a subset of LIBS, and LIBS has to appear after LDFLAGS on platforms that are sensitive to the relative order of -L and -l switches. | 06 July 2010, 03:55:33 UTC |
0a4ecfe | Tom Lane | 06 July 2010, 03:41:02 UTC | Allow for LDFLAGS_SL already having a value in Makefile.aix. Per buildfarm results. | 06 July 2010, 03:41:02 UTC |
f6af143 | Tom Lane | 05 July 2010, 23:40:13 UTC | Dept. of third thoughts: PG_LIBS may contain a -L switch, so it had better stay in front of LDFLAGS. | 05 July 2010, 23:40:13 UTC |
bdf0054 | Tom Lane | 05 July 2010, 23:30:50 UTC | Make sure LDFLAGS come before LIBS when linking contrib programs. Solaris, at least, seems to be sensitive to the relative order of -L and -l switches, so this is needed. Per buildfarm results. | 05 July 2010, 23:30:50 UTC |
f9e9da6 | Tom Lane | 05 July 2010, 23:15:56 UTC | Fix a few single-file (MODULES, not MODULE_big) contrib makefiles that were supposing that they should set SHLIB_LINK rather than LDFLAGS_SL. Since these don't go through Makefile.shlib that was a no-op on most platforms. Also regularize the few platform-specific Makefiles that did pay attention to SHLIB_LINK: it seems that the real value of that is to pull in BE_DLLLIBS, so do that instead. Per buildfarm failures on cygwin. | 05 July 2010, 23:15:56 UTC |
291a957 | Tom Lane | 05 July 2010, 18:54:38 UTC | Split the LDFLAGS make variable into two parts: LDFLAGS is now used for linking both executables and shared libraries, and we add on LDFLAGS_EX when linking executables or LDFLAGS_SL when linking shared libraries. This provides a significantly cleaner way of dealing with link-time switches than the former behavior. Also, make sure that the various platform-specific %.so: %.o rules incorporate LDFLAGS and LDFLAGS_SL; most of them missed that before. (I did not add these variables for the platforms that invoke $(LD) directly, however. It's not clear if we can do that safely, since for the most part we assume these variables use CC command-line syntax.) Per gripe from Aaron Swenson and subsequent investigation. | 05 July 2010, 18:54:38 UTC |
eb81b65 | Heikki Linnakangas | 05 July 2010, 09:27:18 UTC | The previous fix in CVS HEAD and 8.4 for handling the case where a cursor being used in a PL/pgSQL FOR loop is closed was inadequate, as Tom Lane pointed out. The bug affects FOR statement variants too, because you can close an implicitly created cursor too by guessing the "<unnamed portal X>" name created for it. To fix that, "pin" the portal to prevent it from being dropped while it's being used in a PL/pgSQL FOR loop. Backpatch all the way to 7.4 which is the oldest supported version. | 05 July 2010, 09:27:18 UTC |
2330d9c | Bruce Momjian | 04 July 2010, 13:42:51 UTC | Simplify test_fsync duration computation. | 04 July 2010, 13:42:51 UTC |
7341a8c | Bruce Momjian | 04 July 2010, 01:50:29 UTC | Report test_fynsc times in tests per second, instead of total seconds. | 04 July 2010, 01:50:29 UTC |
a520b78 | Bruce Momjian | 03 July 2010, 22:52:25 UTC | Remove SGML tab. | 03 July 2010, 22:52:25 UTC |
8771634 | Tom Lane | 03 July 2010, 22:15:45 UTC | Don't set recoveryLastXTime when replaying a checkpoint --- that was a bogus idea from the start since the variable is only meant to track commit/abort events. This patch reverts the logic around the variable to what it was in 8.4, except that the value is now kept in shared memory rather than a static variable, so that it can be reported correctly by CreateRestartPoint (which is executed in the bgwriter). | 03 July 2010, 22:15:45 UTC |
aceedd8 | Tom Lane | 03 July 2010, 21:23:58 UTC | Make vacuum_defer_cleanup_age be PGC_SIGHUP level, since it's not sensible to have different values in different processes of the primary server. Also put it into the "Streaming Replication" GUC category; it doesn't belong in "Standby Servers" because you use it on the master not the standby. In passing also correct guc.c's idea of wal_keep_segments' category. | 03 July 2010, 21:23:58 UTC |
e76c1a0 | Tom Lane | 03 July 2010, 20:43:58 UTC | Replace max_standby_delay with two parameters, max_standby_archive_delay and max_standby_streaming_delay, and revise the implementation to avoid assuming that timestamps found in WAL records can meaningfully be compared to clock time on the standby server. Instead, the delay limits are compared to the elapsed time since we last obtained a new WAL segment from archive or since we were last "caught up" to WAL data arriving via streaming replication. This avoids problems with clock skew between primary and standby, as well as other corner cases that the original coding would misbehave in, such as the primary server having significant idle time between transactions. Per my complaint some time ago and considerable ensuing discussion. Do some desultory editing on the hot standby documentation, too. | 03 July 2010, 20:43:58 UTC |
e6a7416 | Bruce Momjian | 03 July 2010, 17:21:48 UTC | Document more clearly on XML namespaces inside xpath function Nikolay Samokhvalov | 03 July 2010, 17:21:48 UTC |
da254e3 | Bruce Momjian | 03 July 2010, 16:33:15 UTC | Make pg_upgrade copyrights just 2010, not 2010-2010. | 03 July 2010, 16:33:15 UTC |
de255a6 | Bruce Momjian | 03 July 2010, 16:25:01 UTC | Add copyrights to pg_upgrade and pg_upgrade_tools files, per Tom. | 03 July 2010, 16:25:01 UTC |
ccbe0c1 | Bruce Momjian | 03 July 2010, 14:23:14 UTC | Add CVS tags to pg_upgrade and pg_upgrade_support files, per request from Tom. | 03 July 2010, 14:23:14 UTC |
b3b7d60 | Robert Haas | 03 July 2010, 13:53:13 UTC | Allow REASSIGNED OWNED to handle opclasses and opfamilies. Backpatch to 8.3, which is as far back as we have opfamilies. The opclass portion could probably be backpatched to 8.2, when REASSIGN OWNED was added, but for now I have not done that. Asko Tiidumaa, with minor adjustments by me. | 03 July 2010, 13:53:13 UTC |
4b200a2 | Tom Lane | 03 July 2010, 04:03:06 UTC | Fix assorted misstatements and poor wording in the descriptions of the I/O formats for geometric types. Per bug #5536 from Jon Strait, and my own testing. Back-patch to all supported branches, since this doco has been wrong right along -- we certainly haven't changed the I/O behavior of these types in many years. | 03 July 2010, 04:03:06 UTC |
276a8f4 | Robert Haas | 03 July 2010, 02:57:46 UTC | Additional cross-references to window functions documentation. Erik Rijkers | 03 July 2010, 02:57:46 UTC |
97301ab | Andrew Dunstan | 02 July 2010, 23:25:27 UTC | Unbreak MSVC builds by removing copydir.c from list of libpgport files | 02 July 2010, 23:25:27 UTC |
ce51747 | Robert Haas | 02 July 2010, 20:36:49 UTC | Remove hstore % text[] operator; use slice() function instead. David Wheeler, with one small correction by me. | 02 July 2010, 20:36:49 UTC |
bb0fe9f | Robert Haas | 02 July 2010, 17:03:30 UTC | Move copydir.c from src/port to src/backend/storage/file The previous commit to make copydir() interruptible prevented postgres.exe from linking on MinGW and Cygwin, because on those platforms libpgport_srv.a can't freely reference symbols defined by the backend. Since that code is already backend-specific anyway, just move the whole file into the backend rather than adding further kludges to deal with the symbols needed by CHECK_FOR_INTERRUPTS(). This probably needs some further cleanup, but this commit just moves the file as-is, which should hopefully be enough to turn the buildfarm green again. | 02 July 2010, 17:03:30 UTC |
621cf14 | Bruce Momjian | 02 July 2010, 02:44:32 UTC | Issue 'mkdir' hint when replying CREATE TABLESPACE in recovery mode. Per idea from Fujii Masao | 02 July 2010, 02:44:32 UTC |
71d6d07 | Robert Haas | 01 July 2010, 20:12:40 UTC | Allow copydir() to be interrupted. This makes ALTER DATABASE .. SET TABLESPACE and CREATE DATABASE more sensitive to interrupts. Backpatch to 8.4, where ALTER DATABASE .. SET TABLESPACE was introduced. We could go back further, but in the absence of complaints about the CREATE DATABASE case it doesn't seem worth it. Guillaume Lelarge, with a small correction by me. | 01 July 2010, 20:12:40 UTC |
600fc1d | Tom Lane | 01 July 2010, 15:52:52 UTC | Get rid of some more stuff that duplicates c.h or port.h. | 01 July 2010, 15:52:52 UTC |
14bd1c3 | Bruce Momjian | 01 July 2010, 14:37:53 UTC | Remove port.h prototypes from pg_upgrade.h, per report from Robert Haas. | 01 July 2010, 14:37:53 UTC |
c6cf306 | Robert Haas | 01 July 2010, 14:10:21 UTC | Allow ALTER TABLE .. SET TABLESPACE to be interrupted. Backpatch to 8.0, where tablespaces were introduced. Guillaume Lelarge | 01 July 2010, 14:10:21 UTC |
c37e009 | Bruce Momjian | 01 July 2010, 02:33:21 UTC | Update 9.0 release notes so streaming replication and hot standby is not assumed to require continuous archiving. Per report from Fujii Masao | 01 July 2010, 02:33:21 UTC |
350ab44 | Heikki Linnakangas | 30 June 2010, 18:10:23 UTC | stringToNode() and deparse_expression_pretty() crash on invalid input, but we have nevertheless exposed them to users via pg_get_expr(). It would be too much maintenance effort to rigorously check the input, so put a hack in place instead to restrict pg_get_expr() so that the argument must come from one of the system catalog columns known to contain valid expressions. Per report from Rushabh Lathia. Backpatch to 7.4 which is the oldest supported version at the moment. | 30 June 2010, 18:10:23 UTC |
71a4d5c | Andrew Dunstan | 30 June 2010, 14:25:24 UTC | Correct missing/misspelled surname. | 30 June 2010, 14:25:24 UTC |
67bc0b2 | Bruce Momjian | 30 June 2010, 02:43:10 UTC | Document that /bin/true on Windows is implemented by 'REM'. | 30 June 2010, 02:43:10 UTC |
e1f8d97 | Bruce Momjian | 29 June 2010, 22:29:14 UTC | In documentation, use "lower case"/"upper case" consistently (use space between words). | 29 June 2010, 22:29:14 UTC |
5016b69 | Bruce Momjian | 29 June 2010, 22:23:02 UTC | Document that shared_preload_libraries and local_preload_libraries lowercase the library names, unless double-quoted. | 29 June 2010, 22:23:02 UTC |
5dbf489 | Tom Lane | 29 June 2010, 21:20:19 UTC | Add compatibility note warning that plpgsql is now stricter about the column datatypes of composite results, per gripe from Marcel Asio. Some desultory copy-editing of plpgsql-related sections of the release notes. | 29 June 2010, 21:20:19 UTC |
b57ddcc | Bruce Momjian | 29 June 2010, 18:44:58 UTC | Add C comment about why synchronous_commit=off behavior can lose committed transactions in a postmaster crash. | 29 June 2010, 18:44:58 UTC |
89474cc | Peter Eisentraut | 29 June 2010, 04:12:47 UTC | Message tuning | 29 June 2010, 04:12:47 UTC |
a3401be | Peter Eisentraut | 29 June 2010, 00:18:11 UTC | Use different function names for plpython3 handlers, to avoid clashes in pg_pltemplate This should have a catversion bump, but it's still being debated whether it's worth it during beta. | 29 June 2010, 00:18:11 UTC |