- 03 12月, 2008 3 次提交
-
-
由 Peter Eisentraut 提交于
-
由 Heikki Linnakangas 提交于
-
由 Heikki Linnakangas 提交于
wait for the previous instead of the new file to be archived. Based on patch by Simon Riggs.
-
- 02 12月, 2008 7 次提交
-
-
由 Magnus Hagander 提交于
-
由 Heikki Linnakangas 提交于
gin_cmp_tslexeme and gin_cmp_prefix functions. Should shave off a few cycles from GIN operations.
-
由 Magnus Hagander 提交于
the * character at the beginning of a pattern, and it does not match subdomains. Since this means we no longer need fnmatch, remove the imported implementation from port, along with the autoconf check for it.
-
由 Alvaro Herrera 提交于
-
由 Tom Lane 提交于
outer join clauses. Given, say, ... from a left join b on a.a1 = b.b1 where a.a1 = 42; we'll deduce a clause b.b1 = 42 and then mark the original join clause redundant (we can't remove it completely for reasons I don't feel like squeezing into this log entry). However the original implementation of that wasn't bulletproof, because clause_selectivity() wouldn't honor this_selec if given nonzero varRelid --- which in practice meant that it worked as desired *except* when considering index scan quals. Which resulted in bogus underestimation of the size of the indexscan result for an inner indexscan in an outer join, and consequently a possibly bad choice of indexscan vs. bitmap scan. Fix by introducing an explicit test into clause_selectivity(). Also, to make sure we don't trigger that test in corner cases, change the convention to be that this_selec > 1, not this_selec = 1, means it's been marked redundant. Per trouble report from Scara Maccai. Back-patch to 8.2, where the problem was introduced.
-
由 Heikki Linnakangas 提交于
is treated like a non-digit separator. This fixes the inconsistency in examples like: to_timestamp('2008-01-2', 'YYYY-MM-DD') -- didn't work and to_timestamp('2008-1-02', 'YYYY-MM-DD') -- did work
-
由 Tom Lane 提交于
toasted values, since those could get dropped once the cursor's transaction is over. Per bug #4553 from Andrew Gierth. Back-patch as far as 8.1. The bug actually exists back to 7.4 when holdable cursors were introduced, but this patch won't work before 8.1 without significant adjustments. Given the lack of field complaints, it doesn't seem worth the work (and risk of introducing new bugs) to try to make a patch for the older branches.
-
- 01 12月, 2008 10 次提交
-
-
由 Tom Lane 提交于
-
由 Michael Meskes 提交于
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
由 Tom Lane 提交于
value-per-call mode. This should be more efficient in normal usage, but the real problem with the prior coding was that it returned with a SPI call still active. That could cause problems if execution was interleaved with anything else that might use SPI.
-
由 Tom Lane 提交于
Per buildfarm results.
-
由 Tom Lane 提交于
that a Portal is a useful and sufficient additional argument for CreateDestReceiver --- it just isn't, in most cases. Instead formalize the approach of passing any needed parameters to the receiver separately. One unexpected benefit of this change is that we can declare typedef Portal in a less surprising location. This patch is just code rearrangement and doesn't change any functionality. I'll tackle the HOLD-cursor-vs-toast problem in a follow-on patch.
-
由 Tom Lane 提交于
the basic representational details (typlen, typalign, typbyval, typstorage) to be copied from an existing type rather than listed explicitly in the CREATE TYPE command. The immediate reason for this is to provide a simple solution for add-on modules that want to define types represented as int8, float4, or float8: as of 8.4 the appropriate PASSEDBYVALUE setting is platform-specific and so it's hard for a SQL script to know what to do. This patch fixes the contrib/isn breakage reported by Rushabh Lathia.
-
由 Tom Lane 提交于
This was a thinko introduced in a patch from last February; it results in memory leakage if an SRF is shut down before the actual end of query, because subsequent code will be running in a longer-lived context than it's expecting to be.
-
- 29 11月, 2008 6 次提交
-
-
由 Tom Lane 提交于
regardless of plan changes. Per intermittent buildfarm failures on "pigeon" and others.
-
由 Tom Lane 提交于
to drop a table that is referenced by an open cursor. Fix unstable ecpg regression test result that was produced by this oversight.
-
由 Tom Lane 提交于
but I think this is enough to turn the buildfarm green again.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
RHS that can't be unique-ified --- join_is_legal has to check that before deciding to build a join, else we'll have an unimplementable joinrel. Per report from Greg Stark.
-
由 Tom Lane 提交于
-
- 28 11月, 2008 3 次提交
-
-
由 Magnus Hagander 提交于
-
由 Peter Eisentraut 提交于
a mismatching installation. Pick a default port number calculated from the version number, and try a few times with other numbers if that one doesn't work. Check if we can connect to the port before starting our own postmaster, to detect some other server already running there. To simplify the code, drop --temp-port option and use --port for both temp-install and pre-installed case.
-
由 Heikki Linnakangas 提交于
the sample contains just a one tsvector, containing only one lexeme.
-
- 27 11月, 2008 11 次提交
-
-
由 Heikki Linnakangas 提交于
-
由 Heikki Linnakangas 提交于
as soon as the first page fills up, and is marked as (almost) full, though.
-
由 Peter Eisentraut 提交于
PL/pgSQL has much to do with SQL/PSM.
-
由 Peter Eisentraut 提交于
business in core.
-
由 Peter Eisentraut 提交于
-
由 Heikki Linnakangas 提交于
-
由 Tom Lane 提交于
that the presented list of equivalent operations is meant to be the primary definition of what it does. Per comment from Guillaume Smet.
-
由 Tom Lane 提交于
DestReceiver created during postquel_start needs to be destroyed during postquel_end. In a moment of brain fade I had assumed this would be taken care of by FreeQueryDesc, but it's not (and shouldn't be).
-
由 Heikki Linnakangas 提交于
-
由 Michael Meskes 提交于
-
由 Michael Meskes 提交于
interval style into ecpg.
-