- 11 Oct, 2005 1 commit
-
-
Tom Lane authored
A RestrictInfo representing an OR clause now contains two versions of the contained expression, one with sub-RestrictInfos and one without. clause_selectivity() should descend to the version with sub-RestrictInfos so that it has a chance of caching its results for the OR's sub-clauses. Failing to do so resulted in redundant planner effort.
-
- 10 Oct, 2005 6 commits
-
-
Tom Lane authored
emit when given the --clean option, in favor of individual DROP ROLE commands. The old technique could not possibly work in 8.1, and was never a very good idea anyway IMHO. The DROP ROLE approach has the defect that the DROPs will fail for roles that own objects or have privileges, but perhaps we can improve that later.
-
Tom Lane authored
ie removing shared-dependency entries, should happen before non-rollbackable ones. That way a failure during the rollbackable part doesn't leave us with inconsistent state.
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Tom Lane authored
traceable to grant options. As per my earlier proposal, a GRANT made by a role member has to be recorded as being granted by the role that actually holds the grant option, and not the member.
-
Tom Lane authored
-
- 09 Oct, 2005 1 commit
-
-
Tom Lane authored
like '23:59:60' because of fractional-second roundoff problems. Trying to control this upstream of the actual display code was hopeless; the right way is to explicitly round fractional seconds in the display code and then refigure the results if the fraction rounds up to 1. Per bug #1927.
-
- 08 Oct, 2005 8 commits
-
-
Tom Lane authored
-
Tom Lane authored
-
Tom Lane authored
to call krb5_sname_to_principal() always. Also, use krb_srvname rather than the hardwired string 'postgres' as the appl_version string in the krb5_sendauth/recvauth calls, to avoid breaking compatibility with PG 8.0. Magnus Hagander
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 07 Oct, 2005 11 commits
-
-
Tom Lane authored
initialization. Add spinlocking, fix EXEC_BACKEND unsafeness.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
Per request from Marc Munro.
-
Tom Lane authored
testing ownership if the caller isn't interested in any GOPTION bits (which is the common case). It did not matter in 8.0 where the ownership test was just a trivial equality test, but it matters now.
-
Tom Lane authored
level for unrecognized win32 error codes to LOG, and make messages conform to style guide. Per old suggestion from Qingqing Zhou, which seems to have gotten lost in the shuffle.
-
Tom Lane authored
Remove unportable use of tfind/tsearch in favor of bsearch. Fix up random number generator to use random() not rand() and to actually honor its min/max arguments properly. That wasn't so important before, but with exposure of capability to ask for general ranges, it will be.
-
Tom Lane authored
-
Alvaro Herrera authored
-
Bruce Momjian authored
< * Consider compressing indexes by storing key prefix values shared by > * Consider compressing indexes by storing key values duplicated in 735a736,737 > > This is difficult because it requires datatype-specific knowledge.
-
Bruce Momjian authored
< > * Consider compressing indexes by storing key prefix values shared by > several rows as a single index entry
-
- 06 Oct, 2005 8 commits
-
-
Tom Lane authored
CREATE TABLE command, and translate dBase's 'M' field type to 'text'.
-
Tom Lane authored
cache lookup in the success case. This won't help much for cases where the given relation is far down the search path, but it does not hurt in any cases either; and it requires only a little new code. Per gripe from Jim Nasby about slowness of \d with many tables.
-
Neil Conway authored
current backend in pg_listener, so there is little point in making the PID to register part of async.c's public API. Other minor tweaks.
-
Neil Conway authored
-
Tom Lane authored
the parameter's name (if any) as the default column name for SELECT FROM the function, rather than the function name as previously. I still think this is a bad idea, but I lost the argument. Force decompilation of function RTEs to specify full aliases always, to reduce the odds of this decision breaking dumped views.
-
Tom Lane authored
predicate_implied_by() to detect redundant filter conditions, but forgot that predicate_implied_by() assumes its first argument contains only immutable functions. Add a check to guarantee that. Also, test to see if filter conditions can be discarded because they are redundant with the predicate of a partial index.
-
Peter Eisentraut authored
information item is not available.
-
Tom Lane authored
generated by bitmap index scans. Along the way, simplify and speed up the code for counting sequential and index scans; it was both confusing and inefficient to be taking care of that in the per-tuple loops, IMHO. initdb forced because of internal changes in pg_stat view definitions.
-
- 05 Oct, 2005 5 commits
-
-
Neil Conway authored
fixes by Neil Conway.
-
Bruce Momjian authored
-
Tom Lane authored
comment, it can at least test whether the expression returns set.
-
Tom Lane authored
-Wold-style-definition, per recent discussion.
-
Michael Meskes authored
-