summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2007-12-11Make CSV column ordering a bit more logical.Alvaro Herrera
2007-12-11Make documentation of -W options more accurate and uniform.Tom Lane
2007-12-11Remove the long-deprecated -u option from psql, since it does nothing veryTom Lane
useful and confuses people who think it is the same as -U. (Eventually we might want to re-introduce it as being an alias for -U, but that should not happen until the switch has actually not been there for a few releases.) Likewise in pg_dump and pg_restore. Per gripe from Robert Treat and subsequent discussion.
2007-12-11Extend the format of CSV logs to include the additional information suppliedAlvaro Herrera
with the logged event. CSV logs are now a first-class citizen along plain text logs in that they carry much of the same information. Per complaint from depesz on bug #3799.
2007-12-11Use _USE_32BIT_TIME_T when building with MSVC. Also, enforce that it'sMagnus Hagander
used when building addons. Dave Page
2007-12-10Fix attribution for Rime of the Ancient Mariner (obviously it's beenTom Lane
too long since freshman English :-()
2007-12-09The E. J. Pratt verse used as a tsearch test case is unfortunately stillTom Lane
under copyright in the US and many other places. Substitute a little something from a poet who's more safely dead. Per gripe from Bjorn Munch.
2007-12-09Fix bogus prompt for password in -u case. Per gripe from Robert Treat.Tom Lane
2007-12-09Fix up the PQconnectionUsedPassword mess: create a separateTom Lane
PQconnectionNeedsPassword function that tells the right thing for whether to prompt for a password, and improve PQconnectionUsedPassword so that it checks whether the password used by the connection was actually supplied as a connection argument, instead of coming from environment or a password file. Per bug report from Mark Cave-Ayland and subsequent discussion.
2007-12-08Fix mergejoin cost estimation so that we consider the statistical ranges ofTom Lane
the two join variables at both ends: not only trailing rows that need not be scanned because there cannot be a match on the other side, but initial rows that will be scanned without possibly having a match. This allows a more realistic estimate of startup cost to be made, per recent pgsql-performance discussion. In passing, fix a couple of bugs that had crept into mergejoinscansel: it was not quite up to speed for the task of estimating descending-order scans, which is a new requirement in 8.3.
2007-12-07Realign the running text in this file to 79 characters wide. Some otherPeter Eisentraut
copy-editing.
2007-12-06Disable asserts by default on msvc build (to make it the sameMagnus Hagander
as in unix)
2007-12-06Change wording of logged message when cancelling an autovacuum task, usingAlvaro Herrera
american speling (unlike this commit message). Per complaint from Mike C. on bug #3790 and subsequent discussion.
2007-12-04Don't send an empty SSPI negotiation packet at the end of the negotiation.Magnus Hagander
Fixes bug #3750
2007-12-03Fix build_minmax_path() to cope if an IS NULL clause turns up in theTom Lane
indexable-clauses list for a btree index. Formerly it just Asserted that all such clauses were opclauses, but that's no longer true in 8.3. Per bug #3796 from Matthias Schoeneich.
2007-12-03Default to integer timestamps being off until 8.4, to correspondMagnus Hagander
to the settings used for other platforms.
2007-12-03Don't try to install README.spiMagnus Hagander
Hannes Eder
2007-12-03Stamp 8.3beta4.REL8_3_BETA4Tom Lane
2007-12-03Revert COPY OUT to follow the pre-8.3 handling of ASCII control characters,Tom Lane
namely that \r, \n, \t, \b, \f, \v are dumped as those two-character representations rather than a backslash and the literal control character. I had made it do the other to save some code, but this was ill-advised, because dump files in which these characters appear literally are prone to newline mangling. Fortunately, doing it the old way should only cost a few more lines of code, and not slow down the copy loop materially. Per bug #3795 from Lou Duchez.
2007-12-01Code review for LIKE ... INCLUDING INDEXES patch. Fix failure to propagateTom Lane
constraint status of copied indexes (bug #3774), as well as various other small bugs such as failure to pstrdup when needed. Allow INCLUDING INDEXES indexes to be merged with identical declared indexes (perhaps not real useful, but the code is there and having it not apply to LIKE indexes seems pretty unorthogonal). Avoid useless work in generateClonedIndexStmt(). Undo some poorly chosen API changes, and put a couple of routines in modules that seem to be better places for them.
2007-12-01Suppress compiler warnings in recent plperl patch. Avoid uselessly expensiveTom Lane
lookup of the well-known OID of textout().
2007-12-01Revert inadvertantly committed change.Andrew Dunstan
2007-12-01Workaround for perl problem where evaluating UTF8 regexes can causeAndrew Dunstan
implicit loading of modules, thereby breaking Safe rules. We compile and call a tiny perl function on trusted interpreter init, after which the problem does not occur.
2007-11-30Avoid incrementing the CommandCounter when CommandCounterIncrement is calledTom Lane
but no database changes have been made since the last CommandCounterIncrement. This should result in a significant improvement in the number of "commands" that can typically be performed within a transaction before hitting the 2^32 CommandId size limit. In particular this buys back (and more) the possible adverse consequences of my previous patch to fix plan caching behavior. The implementation requires tracking whether the current CommandCounter value has been "used" to mark any tuples. CommandCounter values stored into snapshots are presumed not to be used for this purpose. This requires some small executor changes, since the executor used to conflate the curcid of the snapshot it was using with the command ID to mark output tuples with. Separating these concepts allows some small simplifications in executor APIs. Something for the TODO list: look into having CommandCounterIncrement not do AcceptInvalidationMessages. It seems fairly bogus to be doing it there, but exactly where to do it instead isn't clear, and I'm disinclined to mess with asynchronous behavior during late beta.
2007-11-30Repair bug that allowed RevalidateCachedPlan to attempt to rebuild a cachedTom Lane
plan before the effects of DDL executed in an immediately prior SPI operation had been absorbed. Per report from Chris Wood. This patch has an unpleasant side effect of causing the number of CommandCounterIncrement()s done by a typical plpgsql function to approximately double. Amelioration of the consequences of that will be undertaken in a separate patch.
2007-11-30Add win32error.c to libpq, needed to resolve _dosmaperr.Magnus Hagander
2007-11-30Use _dosmaperr() to deal with errors opening files in pgwin32_open().Magnus Hagander
Per complaint from Alvaro and subsequent discussion.
2007-11-29Translation updatesPeter Eisentraut
2007-11-28Make a cleanup pass over error reports in tsearch code. Use ereportTom Lane
for user-facing errors, fix some poor choices of errcode, adhere to message style guide.
2007-11-28Improve test coverage of CLOBBER_CACHE_ALWAYS by having it also forceTom Lane
reloading of operator class information on each use of LookupOpclassInfo. Had this been in place a year ago, it would have helped me find a bug in the then-new 'operator family' code. Now that we have a build farm member testing CLOBBER_CACHE_ALWAYS on a regular basis, it seems worth expending a little bit of effort here.
2007-11-28Adjust the names of a couple of tsearch index support functions that hadTom Lane
inappropriately generic-sounding names. This is more or less free since we already forced initdb for the next beta, and it may prevent confusion or name conflicts (particularly at the C-global-symbol level) down the road. Per my proposal yesterday.
2007-11-28Install a lookaside cache to speed up repeated lookups of the same operatorTom Lane
by short-circuiting schema search path and ambiguous-operator resolution computations. Remarkably, this buys as much as 45% speedup of repetitive simple queries that involve operators that are not an exact match to the input datatypes. It should be marginally faster even for exact-match cases, though I've not had success in proving an improvement in benchmark tests. Per report from Guillame Smet and subsequent discussion.
2007-11-28Proper capitalization of IspellPeter Eisentraut
2007-11-28Fix XML Schema structure for char types without length (bug #3782)Peter Eisentraut
2007-11-28Improve terminologyPeter Eisentraut
2007-11-28Fix typoPeter Eisentraut
2007-11-28Properly recognize and announce input errors.Peter Eisentraut
2007-11-28Change a stop word on the right-hand-side in the thesaurus file to be anBruce Momjian
ERROR, not NOTICE.
2007-11-27Fix plpgsql to not lookup block labels except in contexts where a block labelTom Lane
is sane (eg, EXIT argument or first part of a qualified identifier), and cause more-closely-nested record variables to take precedence over outer block labels. This cures the breakage exhibited by Marko Kreen that 8.3 no longer allowed a function's name to be used for a variable within the function, and makes plpgsql's handling of block labels more like Oracle's. It's important to fix this now because we are documenting the use of block labels as variable qualifiers for the first time in 8.3.
2007-11-27Fix pg_regress to check the directory it is actually reading files from,Tom Lane
not the image that (theoretically) should exist in the current directory. Jørgen Austvik
2007-11-27Add quote_literal(anyelement) to preserve (and, in fact, extend) aTom Lane
useful consequence of the former liberal implicit casting to text; namely that you can feed non-string values to quote_literal() and get unsurprising results. Per discussion.
2007-11-27Suppress compiler warning.Tom Lane
2007-11-27Make casts from xml to text independent of the XML option setting, thusPeter Eisentraut
immutable and indexable. Also fix the volatility settings of some other XML-related functions.
2007-11-27correct capitalizationPeter Eisentraut
2007-11-26Fix select_common_type() so that it can select a domain type, if all inputsTom Lane
to a UNION, CASE, or related construct are of the same domain type. The main part of this routine smashes domains to their base types, which seems necessary because the logic involves TypeCategory() and IsPreferredType(), neither of which work usefully on domains. However, we can add a first pass that just detects whether all the inputs are exactly the same type, and if so accept that without question (so long as it's not UNKNOWN). Per recent gripe from Dean Rasheed. In passing, remove some tests for InvalidOid, which have clearly been dead code for quite some time now, because getBaseType() would fail on that input. Also, clarify the manual's not-very-precise description of the existing algorithm's behavior.
2007-11-25Allow for X as well as x to be the prefix for hexadecimal character ref ↵Andrew Dunstan
entity numbers, as in HTML.
2007-11-25Fix XML tag namespace change inadvertantly missed from previous fix. AddAndrew Dunstan
regression test for XML names and numeric entities.
2007-11-25Use double quotes for quoting xml attributes.Peter Eisentraut
2007-11-25Fix thinko in comment.Tom Lane
2007-11-24Reduce routine successful-archiving message from LOG to DEBUG1 grade,Tom Lane
to reduce chattiness of logs. Per discussion. Simon Riggs