summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2009-06-26Cleanup and code review for the patch that made bgwriter active duringTom Lane
archive recovery. Invent a separate state variable and inquiry function for XLogInsertAllowed() to clarify some tests and make the management of writing the end-of-recovery checkpoint less klugy. Fix several places that were incorrectly testing InRecovery when they should be looking at RecoveryInProgress or XLogInsertAllowed (because they will now be executed in the bgwriter not startup process). Clarify handling of bad LSNs passed to XLogFlush during recovery. Use a spinlock for setting/testing SharedRecoveryInProgress. Improve quite a lot of comments. Heikki and Tom
2009-06-26Translation updates for 8.4 release.Peter Eisentraut
File that are translated less than 80% have been removed, as per new translation team policy.
2009-06-26Extract tarballs with "o" option (tar xof), to behave reasonably when runPeter Eisentraut
as root, as would usually be the case during make install. per bug #4883
2009-06-26Use $(TAR) instead of tar in makefiles.Peter Eisentraut
2009-06-25Add __attribute__((format_arg(1))) to the declaration of err_gettext(),Tom Lane
to restore gcc's ability to crosscheck format arguments within elog.c. Noted in a test compilation with -Wformat-nonliteral enabled.
2009-06-25Fix some serious bugs in archive recovery, now that bgwriter is activeHeikki Linnakangas
during it: When bgwriter is active, the startup process can't perform mdsync() correctly because it won't see the fsync requests accumulated in bgwriter's private pendingOpsTable. Therefore make bgwriter responsible for the end-of-recovery checkpoint as well, when it's active. When bgwriter is active (= archive recovery), the startup process must not accumulate fsync requests to its own pendingOpsTable, since bgwriter won't see them there when it performs restartpoints. Make startup process drop its pendingOpsTable when bgwriter is launched to avoid that. Update minimum recovery point one last time when leaving archive recovery. It won't be updated by the end-of-recovery checkpoint because XLogFlush() sees us as out of recovery already. This fixes bug #4879 reported by Fujii Masao.
2009-06-25Man pages back to lowercase names, with additional fixup to make the .soPeter Eisentraut
links work.
2009-06-25Make prior patch pgindent-safe.Tom Lane
2009-06-25The code to unlink dropped relations in FinishPreparedTransaction() wasHeikki Linnakangas
acting like runs inside WAL recovery, but it doesn't. I must've copy-pasted this from a redo-function in the relation forks patch. Noticed by Tom Lane while he was looking through callers of smgrdounlink().
2009-06-25Disable pg_standby -l option because the backend doesn't expect the recoveredHeikki Linnakangas
file to be a symlink. We tried to fix this issue with an earlier server-side patch, but it didn't fix the whole issue. The same bug is present in older releases as well, but the 8.4 train is about to leave the station, and I'm not sure if have consensus on whether we can remove the -l option in back-branches or do we need to attempt a server-side fix to make symlinking safe. Patch by Simon Riggs, per discussion on bug identified by Fujii Masao.
2009-06-25Disallow empty passwords in LDAP authentication, the same wayMagnus Hagander
we already do it for PAM.
2009-06-24Correct grammar in picksplit debug messagesPeter Eisentraut
2009-06-24Fix incorrect LDAP example, noted by Tom.Magnus Hagander
2009-06-24parse_ident_usermap() shuold use ereport(LOG) and not ERROR, and put theMagnus Hagander
return value in the *error_p variable. Noted by Tom.
2009-06-23Provide a link to the UPDATE reference page in the 'Updating Data'Tom Lane
section of the docs. Per suggestion from Brad Bowman.
2009-06-23Properly initialize SSL engines when used from libpq. This is required forMagnus Hagander
most external engines. Per report and initial code from Lars Kanis
2009-06-23Fix an ancient error in dist_ps (distance from point to line segment), whichTom Lane
a number of other geometric operators also depend on. It miscalculated the slope of the perpendicular to the given line segment anytime that slope was other than 0, infinite, or +/-1. In some cases the error would be masked because the true closest point on the line segment was one of its endpoints rather than the intersection point, but in other cases it could give an arbitrarily bad answer. Per bug #4872 from Nick Roosevelt. Bug goes clear back to Berkeley days, so patch all supported branches. Make a couple of cosmetic adjustments while at it.
2009-06-23Fix the makefiles to fail cleanly if Perl is needed but not present. ThisTom Lane
used to work as intended, but got broken some time ago (a quoted empty string is not an empty string), and got broken some more by the changes to generate ecpg's preproc.y automatically. Given all the unprotected uses of $(PERL) elsewhere, it seems best to make use of the $(missing) script rather than trying to ensure each such use is protected individually. Also fix various bits of documentation that omitted to mention Perl as a requirement for building from a CVS pull. Per a complaint from Robert Haas.
2009-06-22bundle RC2REL8_4_RC2Marc G. Fournier
2009-06-22For bulk write operations (eg COPY IN), use a ring buffer of 16MB insteadTom Lane
of the 256KB limit originally enforced by a patch committed 2008-11-06. Per recent test results, the smaller size resulted in an undesirable decrease in bulk data loading speed, due to COPY processing frequently getting blocked for WAL flushing. This area might need more tweaking later, but this setting seems to be good enough for 8.4.
2009-06-22Make to_timestamp and friends skip leading spaces before an integer field,Tom Lane
even when not in FM mode. This improves compatibility with Oracle and with our pre-8.4 behavior, as per bug #4862. Brendan Jurd Add a couple of regression test cases for this. In passing, get rid of the labeling of the individual test cases; doesn't seem to be good for anything except causing extra work when inserting a test... Tom Lane
2009-06-22Add more explicit note that the parameters of MOVE are identical to FETCH.Peter Eisentraut
per David Wheeler
2009-06-22Revert dubious message wording change.Tom Lane
2009-06-21Message fixesPeter Eisentraut
2009-06-20Fix things so that array_agg_finalfn does not modify or free its inputTom Lane
ArrayBuildState, per trouble report from Merlin Moncure. By adopting this fix, we are essentially deciding that aggregate final-functions should not modify their inputs ever. Adjust documentation and comments to match that conclusion.
2009-06-19Extend man page installation hackery so that the man page section is alsoPeter Eisentraut
fixed up in the .so links.
2009-06-19Don't convert the man page names to lower case, so that the .so links work.Peter Eisentraut
This is pretty much a workaround for incomplete tools, but having the man page names in upper case looks more natural anyway.
2009-06-19Add manvolnum, so that man pages are generated.Peter Eisentraut
2009-06-18Don't attempt to "rm" directories on uninstall.Peter Eisentraut
2009-06-18Recursive Joins -> Recursive QueriesPeter Eisentraut
per Erik Rijkers
2009-06-18Add some more documentation and cross-links on using dblink with SQL/MED.Peter Eisentraut
2009-06-18Refine the use of terminology around bound and unbound cursors and cursorPeter Eisentraut
variables. Remove the confusing term "reference cursor".
2009-06-18Fix a few errors in comments. Patch by Fujii Masao, plus the one inHeikki Linnakangas
visibilitymap.c by me.
2009-06-18Fix the just-reported problem that you can't specify all four trigger eventTom Lane
types in CREATE TRIGGER. While at it, clean up the amazingly tedious and inextensible way that the trigger event type list was handled. Per report from Greg Sabino Mullane.
2009-06-17Proofreading for Bruce's recent round of documentation proofreading.Tom Lane
Most of those changes were good, but some not so good ...
2009-06-17ExecAgg() failed to finish running out set-returning functions in the lastTom Lane
aggregated tuple of a run. Per report from Laurenz Albe. This is a new bug in 8.4, but only because prior versions rejected SRFs in an Agg plan node altogether.
2009-06-17Add another link of a GUC variable to where it is explained.Peter Eisentraut
2009-06-17Fix typo in error message: tgargv -> tg_argvPeter Eisentraut
2009-06-14Change test tables in copy2 regression test to be temporary tables.Tom Lane
This prevents autovacuum from reclaiming free space in them and causing the test's output row order to change, which is causing intermittent bogus failure reports in the buildfarm. Backpatch to 8.3. The issue exists further back, but since autovacuum was not on by default before 8.3, it's not a problem for buildfarm testing.
2009-06-13Fix get_sort_group_operators() so that it doesn't think arrays can be groupedTom Lane
via hashing. Eventually we ought to make that possible, but it won't happen for 8.4. Per yesterday's report from Robert Haas.
2009-06-13Tweak the display of incoming foreign-key constraints in \d, per discussionPeter Eisentraut
on hackers. Also, take that string out of the translation roster, since it's now entirely pseudo-SQL.
2009-06-12Improve documentation about GiST opclass support functions.Tom Lane
Dimitri Fontaine
2009-06-12Fix several places where a function was declared static and then definedTom Lane
without static. Per testing with a compiler that complains about this.
2009-06-12Add info about minimum recommended AIX fix levels, per Laurenz Albe.Tom Lane
2009-06-12time to tag rc1 ...REL8_4_RC1Marc G. Fournier
2009-06-12Tighten typedef check for Linux.Bruce Momjian
2009-06-12Mention BSD/OS find_typedef behavior.Bruce Momjian
2009-06-11Document struct/union problem with pgindent.Bruce Momjian
2009-06-11Update release notes to today.Tom Lane
2009-06-11Revisit AlterTableCreateToastTable's API once again, hoping to make it whatTom Lane
pg_migrator actually needs and not just a partial solution. We have to be able to specify the OID that the new toast table should be created with.