aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Silence compiler warning about printf format for HANDLE.Itagaki Takahiro2010-01-04
|
* Dept of second thoughts: my first cut at supporting "x IS NOT NULL" btreeTom Lane2010-01-03
| | | | | | | | | indexscans would do the wrong thing if index_rescan() was called with a NULL instead of a new set of scankeys and the index was DESC order, because sk_strategy would not get flipped a second time. I think that those provisions for a NULL argument are dead code now as far as the core backend goes, but possibly somebody somewhere is still using it. In any case, this refactoring seems clearer, and it's definitely shorter.
* Make ssize_t 64-bit on Win64, for compatibility with for example plpython.Magnus Hagander2010-01-02
|
* Add missing schema-qualification in tab completion query.Tom Lane2010-01-02
|
* Fix similar_escape() to convert parentheses to non-capturing style.Tom Lane2010-01-02
| | | | | | | | | | | This is needed to avoid unwanted interference with SUBSTRING behavior, as per bug #5257 from Roman Kononov. Also, add some basic intelligence about character classes (bracket expressions) since we now have several behaviors that aren't appropriate inside a character class. As with the previous patch in this area, I'm reluctant to back-patch since it might affect applications that are relying on the prior behavior.
* check_exclusion_constraint didn't actually work correctly for indexTom Lane2010-01-02
| | | | | | | expressions: FormIndexDatum requires the estate's scantuple to already point at the tuple the values are supposedly being extracted from. Adjust test case so that this type of confusion will be exposed. Per report from hubert depesz lubaczewski.
* Update copyright for the year 2010.Bruce Momjian2010-01-02
|
* Silence compiler warning about size of size_t being larger than the resultMagnus Hagander2010-01-02
| | | | variable it's stored in. We know this can never happen. Per discussion.
* Set proper sizes for size_t and void* on 64-bit Windows builds.Magnus Hagander2010-01-02
| | | | Tsutomu Yamada
* Support 64-bit shared memory when building on 64-bit Windows.Magnus Hagander2010-01-02
| | | | Tsutomu Yamada
* Fix one more cast for _open_osfhandle().Magnus Hagander2010-01-02
| | | | Tsutomu Yamada
* Fix cast for _open_osfhandle().Magnus Hagander2010-01-02
| | | | Tsutomu Yamada
* Add an "argisrow" field to NullTest nodes, following a plan made way back inTom Lane2010-01-01
| | | | | | 8.2beta but never carried out. This avoids repetitive tests of whether the argument is of scalar or composite type. Also, be a bit more paranoid about composite arguments in some places where we previously weren't checking.
* Support "x IS NOT NULL" clauses as indexscan conditions. This turns outTom Lane2010-01-01
| | | | | | | | | | | to be just a minor extension of the previous patch that made "x IS NULL" indexable, because we can treat the IS NOT NULL condition as if it were "x < NULL" or "x > NULL" (depending on the index's NULLS FIRST/LAST option), just like IS NULL is treated like "x = NULL". Aside from any possible usefulness in its own right, this is an important improvement for index-optimized MAX/MIN aggregates: it is now reliably possible to get a column's min or max value cheaply, even when there are a lot of nulls cluttering the interesting end of the index.
* Silence compiler warning on 64-bit windows buildMagnus Hagander2010-01-01
|
* Detect a 64-bit build environment on Windows, and generate the appropriateMagnus Hagander2010-01-01
| | | | | | project files. Based on the work of Tsutomu Yamada, but much refactored.
* Delete solution cache file on clean, if it exists.Magnus Hagander2010-01-01
|
* Update SQL features supported listPeter Eisentraut2010-01-01
|
* Make the win32 putenv() override update *all* present versions of theMagnus Hagander2010-01-01
| | | | | | | | MSVCRxx runtime, not just the current + Visual Studio 6 (MSVCRT). Clearly there can be an almost unlimited number of runtimes loaded at the same time. Per report from Hiroshi Inoue
* Suppress compiler warning, per buildfarm member narwhalTom Lane2009-12-31
|
* Suppress compiler warning (pid_t isn't int everywhere)Tom Lane2009-12-31
|
* Add missing 'static' tag.Tom Lane2009-12-31
|
* Redefine Datum as uintptr_t, instead of unsigned long.Tom Lane2009-12-31
| | | | | | | This is more in keeping with modern practice, and is a first step towards porting to Win64 (which has sizeof(pointer) > sizeof(long)). Tsutomu Yamada, Magnus Hagander, Tom Lane
* Update SQL features list for aggregate ORDER BY supportPeter Eisentraut2009-12-31
|
* Add information_schema.triggered_update_columnsPeter Eisentraut2009-12-31
| | | | This reflects the recently added support for triggers on columns.
* enable examples to compile on Windows. patch from Hiroshi Saito.Andrew Dunstan2009-12-31
|
* Fill in information schema column for trigger WHEN conditionPeter Eisentraut2009-12-30
|
* Dept of second thoughts: recursive case in ANALYZE shouldn't emit aTom Lane2009-12-30
| | | | | pgstats message. This might need to be done differently later, but with the current logic that's what should happen.
* Revise pgstat's tracking of tuple changes to improve the reliability ofTom Lane2009-12-30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | decisions about when to auto-analyze. The previous code depended on n_live_tuples + n_dead_tuples - last_anl_tuples, where all three of these numbers could be bad estimates from ANALYZE itself. Even worse, in the presence of a steady flow of HOT updates and matching HOT-tuple reclamations, auto-analyze might never trigger at all, even if all three numbers are exactly right, because n_dead_tuples could hold steady. To fix, replace last_anl_tuples with an accurately tracked count of the total number of committed tuple inserts + updates + deletes since the last ANALYZE on the table. This can still be compared to the same threshold as before, but it's much more trustworthy than the old computation. Tracking this requires one more intra-transaction counter per modified table within backends, but no additional memory space in the stats collector. There probably isn't any measurable speed difference; if anything it might be a bit faster than before, since I was able to eliminate some per-tuple arithmetic operations in favor of adding sums once per (sub)transaction. Also, simplify the logic around pgstat vacuum and analyze reporting messages by not trying to fold VACUUM ANALYZE into a single pgstat message. The original thought behind this patch was to allow scheduling of analyzes on parent tables by artificially inflating their changes_since_analyze count. I've left that for a separate patch since this change seems to stand on its own merit.
* Update SQL conformance: search conditions on triggers are supportedPeter Eisentraut2009-12-30
|
* Revert makefile refactoring (version 1.123) because it doesn't workPeter Eisentraut2009-12-30
| | | | | when building several files at once (e.g., gmake postgres-A4.pdf postgres-US.pdf).
* Exclude part of the product name string that is localized in Japanese versionsMagnus Hagander2009-12-30
| | | | | | of MSVC when detecting MSVC version. Hiroshi Inoue
* Reset minRecoveryPoint at checkpoints, so that we don't uselessly updateHeikki Linnakangas2009-12-30
| | | | | | it in the control file at crash recovery following an archive recovery. Per Fujii Masao and subsequent discussion.
* Set errno to zero before invoking SSL_read or SSL_write. It appears thatTom Lane2009-12-30
| | | | | | | | | | | at least in some Windows versions, these functions are capable of returning a failure indication without setting errno. That puts us into an infinite loop if the previous value happened to be EINTR. Per report from Brendan Hill. Back-patch to 8.2. We could take it further back, but since this is only known to be an issue on Windows and we don't support Windows before 8.2, it does not seem worth the trouble.
* Reject invalid input in int2vectorin.Robert Haas2009-12-30
| | | | | | | | | | Since the int2vector type is intended only for internal use, this patch doesn't worry about prettifying the error messages, which has the fringe benefit of avoiding creating additional translatable strings. For a type intended to be used by end-users, we would want to do better, but the approach taken here seems like the correct trade-off for this case. Caleb Welton
* Add an index on pg_inherits.inhparent, and use it to avoid seqscans inTom Lane2009-12-29
| | | | | | | find_inheritance_children(). This is a complete no-op in databases without any inheritance. In databases where there are just a few entries in pg_inherits, it could conceivably be a small loss. However, in databases with many inheritance parents, it can be a big win.
* Add the ability to store inheritance-tree statistics in pg_statistic,Tom Lane2009-12-29
| | | | | | | | and teach ANALYZE to compute such stats for tables that have subclasses. Per my proposal of yesterday. autovacuum still needs to be taught about running ANALYZE on parent tables when their subclasses change, but the feature is useful even without that.
* Previous fix for temporary file management broke returning a set fromHeikki Linnakangas2009-12-29
| | | | | | | | | | | | | | PL/pgSQL function within an exception handler. Make sure we use the right resource owner when we create the tuplestore to hold returned tuples. Simplify tuplestore API so that the caller doesn't need to be in the right memory context when calling tuplestore_put* functions. tuplestore.c automatically switches to the memory context used when the tuplestore was created. Tuplesort was already modified like this earlier. This patch also removes the now useless MemoryContextSwitch calls from callers. Report by Aleksei on pgsql-bugs on Dec 22 2009. Backpatch to 8.1, like the previous patch that broke this.
* Small wording improvement and clarification in PL/pgSQL trigger documentationPeter Eisentraut2009-12-28
|
* Remove PGDLLIMPORT used for binary upgrade; must be on the externs, per Tom.Bruce Momjian2009-12-28
|
* Add PGDLLIMPORT for binary_upgrade global variables so shared objectBruce Momjian2009-12-28
| | | | libraries can access them.
* Remove non-ascii characters from source code.Bruce Momjian2009-12-28
|
* Avoid memory leak if pgstat_vacuum_stat is interrupted partway through.Tom Lane2009-12-27
| | | | | | | | | | | The temporary hash tables made by pgstat_collect_oids should be allocated in a short-term memory context, which is not the default behavior of hash_create. Noted while looking through hash_create calls in connection with Robert Haas' recent complaint. This is a pre-existing bug, but it doesn't seem important enough to back-patch. The hash table is not so large that it would matter unless this happened many times within a session, which seems quite unlikely.
* Remove a couple of unnecessary calls of CreateCacheMemoryContext. TheseTom Lane2009-12-27
| | | | | | | probably got there via blind copy-and-paste from one of the legitimate callers, so rearrange and comment that code a bit to make it clearer that this isn't a necessary prerequisite to hash_create. Per observation from Robert Haas.
* Remove now unreferenced variable.Magnus Hagander2009-12-27
|
* If the MSVCRT module is not found in the current binary, proceed to updateMagnus Hagander2009-12-27
| | | | | system and local environments anyway, instead of aborting. (This will happen in a MSVC build with no or very few external libraries linked in)
* Add backend and pg_dump code to allow preservation of pg_enum oids, forBruce Momjian2009-12-27
| | | | | | use in binary upgrades. Bump catalog version for detection by pg_migrator of new backend API.
* Zero-label enums:Bruce Momjian2009-12-26
| | | | Allow enums to be created with zero labels, for use during binary upgrade.
* Fix brain fade in join-removal patch: a pushed-down clause in the outer join'sTom Lane2009-12-25
| | | | | restrict list is not just something to ignore, it's actually grounds to abandon the optimization entirely. Per bug #5255 from Matteo Beccati.
* Add missing <indexterm><primary>...</primary>...</indexterm> tags for a coupleRobert Haas2009-12-25
| | | | | | of HS-related parameters. Fujii Masao
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-03 10:32:25 +0000