aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Marginal hack to merge adjacent ReleaseBuffer/ReadBuffer calls intoTom Lane2005-02-05
| | | | | ReleaseAndReadBuffer during GIST index searches. We already did this in btree and rtree, might as well do it here too.
* Refactor some duplicated code in lock.c: create UnGrantLock(), move codeNeil Conway2005-02-04
| | | | from LockRelease() and LockReleaseAll() into it. From Heikki Linnakangas.
* Fix minor thinko in logic to set dump order when dumping from a pre-7.3Tom Lane2005-02-03
| | | | | database: aggregates should be dumped in the same pass as operators, not in the same pass as functions.
* Ensure that all details of the ARC algorithm are hidden within freelist.c.Tom Lane2005-02-03
| | | | | This refactoring does not change any algorithms or data structures, just remove visibility of the ARC datastructures from other source files.
* Improve performance of fmgr.c calling routines for cases with more thanTom Lane2005-02-02
| | | | two arguments. Per suggestions from A. Ogawa.
* Adjust constant-folding of CASE expressions so that the simple comparisonTom Lane2005-02-02
| | | | | | | | form of CASE (eg, CASE 0 WHEN 1 THEN ...) can be constant-folded as it was in 7.4. Also, avoid constant-folding result expressions that are certainly unreachable --- the former coding was a bit cavalier about this and could generate unexpected results for all-constant CASE expressions. Add regression test cases. Per report from Vlad Marchenko.
* Add to release checklist:Bruce Momjian2005-02-02
| | | | * Update inet/cidr data types with newest Bind patches
* Fixed bug in parsing of #line statement in declare section.Michael Meskes2005-02-02
|
* Add support for temporary views, including documentation and regressionNeil Conway2005-02-02
| | | | | | | | tests. Contributed by Koju Iijima, review from Neil Conway, Gavin Sherry and Tom Lane. Also, fix error in description of WITH CHECK OPTION clause in the CREATE VIEW reference page: it should be "CASCADED", not "CASCADE".
* Fix a bug induced by the list-rewrite that resulted in incrementing theNeil Conway2005-02-01
| | | | command counter more than necessary. Per report from Michael Fuhr.
* Adjust estimate_num_groups() to not clamp per-relation group countTom Lane2005-02-01
| | | | | | | estimate to less than the number of values estimated for any one grouping Var, as suggested by Manfred. This is intuitively right, and what's more it puts the plan choices in the subselect regression test back the way they were before ...
* Adjust plpgsql to allow assignment to an element of an array that isTom Lane2005-02-01
| | | | | | initially NULL. For 8.0 we changed the main executor to have this behavior in an UPDATE of an array column, but plpgsql's equivalent case was overlooked. Per report from Sven Willenberger.
* Sync inet formatting code with recent BIND releases. In particular,Tom Lane2005-02-01
| | | | | fix bug with inconsistent selection of default mask length for "class D" addresses. Per report from Steve Atkins.
* When dealing with multiple grouping columns coming from the same table,Tom Lane2005-01-28
| | | | | | | | | clamp the estimated number of groups to table row count over 10, instead of table row count; this reflects a heuristic that people probably won't group over a near-unique set of columns, and the knowledge that we don't currently have any way to estimate the correlation of the columns better than guessing. This change creates a trivial plan change in one of the regression tests.
* Improve planner's estimation of the space needed for HashAgg plans:Tom Lane2005-01-28
| | | | | | look at the actual aggregate transition datatypes and the actual overhead needed by nodeAgg.c, instead of using pessimistic round numbers. Per a discussion with Michael Tiemann.
* pg_aggregate.h fails to compile standalone, for lack of an #includeTom Lane2005-01-28
| | | | defining List.
* Adjust mkdir_p to do stat() before trying mkdir(). Avoids problems onTom Lane2005-01-28
| | | | | Solaris and should be a little faster anyway, since in most scenarios all but perhaps the last path component will already exist.
* Check that aggregate creator has the right to execute the transitionTom Lane2005-01-27
| | | | functions of the aggregate, at both aggregate creation and execution times.
* Small patch to move get_grosysid() from catalog/aclchk.c toNeil Conway2005-01-27
| | | | | | utils/cache/lsyscache.c where it can be used by other things. Also cleans up both get_usesysid() and get_grosysid() a bit. From Stephen Frost.
* Change heap_modifytuple() to require a TupleDesc rather than aNeil Conway2005-01-27
| | | | | Relation. Patch from Alvaro Herrera, minor editorializing by Neil Conway.
* Provide a more descriptive error message when the return type of an SRFNeil Conway2005-01-27
| | | | | does not match what the query expected. From Brendan Jurd, minor editorializing by Neil Conway.
* Generalize TRUNCATE to support truncating multiple tables in oneTom Lane2005-01-27
| | | | | | | | command. This is useful because we can allow truncation of tables referenced by foreign keys, so long as the referencing table is truncated in the same command. Alvaro Herrera
* Add regression tests for recent cursor/savepoint bug fixed by Alvaro andNeil Conway2005-01-27
| | | | Tom.
* Close all cursors created during a failed subtransaction. This is neededTom Lane2005-01-26
| | | | | | to avoid problems when a cursor depends on objects created or changed in the same subtransaction. We'd like to do better someday, but this seems the only workable answer for 8.0.1.
* On Windows, set the postmaster executable's stack size to 4MB, so thatTom Lane2005-01-26
| | | | it agrees with the default value of max_stack_depth.
* Minor tweak to avoid unnecessary memory bloat when dumping extremely wideTom Lane2005-01-26
| | | | | | column values in -d mode. Per report from Marty Scholes. This doesn't completely solve the issue, because we still need multiple copies of the field value, but at least one copy can be got rid of painlessly ...
* Make pg_dump and pg_restore handle binary archive formats correctlyTom Lane2005-01-26
| | | | when using stdout/stdin on Windows.
* Use SHGetFolderPath instead of SHGetSpecialFolderPath to find theTom Lane2005-01-26
| | | | APPDATA directory on Windows. Magnus Hagander
* Fix breakage created by addition of separate 'acl pass' in pg_dump.Tom Lane2005-01-25
| | | | Also clean up incredibly poor style in TocIDRequired() usage.
* Add missing "ko".Peter Eisentraut2005-01-25
|
* Fixed segfault due to freeing a struct definition twice if it was a named ↵Michael Meskes2005-01-25
| | | | struct used in a typedef.
* Regression tests for recent bugfix to ALTER TABLE ADD COLUMN: ensure thatNeil Conway2005-01-25
| | | | | constraints on domain types are properly enforced, even if the newly added column has no default value. Per bug #1433.
* Fix ALTER TABLE ADD COLUMN so that constraints of domain types areTom Lane2005-01-24
| | | | | enforced properly when there is no explicit default value for the new column. Per report from Craig Perras.
* Disallow LOAD to non-superusers. Per report from John Heasman.Tom Lane2005-01-24
|
* Fix memory leak in rtdosplit, per report from Clive Page.Tom Lane2005-01-24
|
* Document why CREATE CONSTRAINT TRIGGER doesn't tab complete.Bruce Momjian2005-01-23
|
* The result of a FULL or RIGHT join can't be assumed to be sorted by theTom Lane2005-01-23
| | | | | left input's sorting, because null rows may be inserted at various points. Per report from Ferenc Lutischá¸n.
* Add tools/find_gt_lt to find < and > in SGML source.Bruce Momjian2005-01-23
| | | | | Lowercase some uppercase tags so tools is more reliable at finding problems.
* pg_dump dumped the wrong tablespace for an index (ie, the parent table'sTom Lane2005-01-23
| | | | | tablespace instead of the index's own), except when the index was created as a constraint. Report and fix by Tanida Yutaka.
* New routine _getObjectDescription() failed to cope with some aspects ofTom Lane2005-01-23
| | | | | | pre-7.3 pg_dump archive files: namespace isn't there, and in some cases te->tag may already be quotified. Per report from Alan Pevec and followup testing.
* Mention issue with < and > in docs.Bruce Momjian2005-01-22
|
* This patch updates the regression tests to allow "make installcheck" toNeil Conway2005-01-22
| | | | | | pass if "default_with_oids" is set to false. I took the approach of explicitly adding WITH OIDS to the CREATE TABLEs where necessary, rather than tweaking the default_with_oids GUC var.
* Trivial fix: remove some stray leading whitespace.Neil Conway2005-01-20
|
* Refactor transformExpr() by creating separate functions for most of theNeil Conway2005-01-19
| | | | expression types.
* Add some basic regression tests for refcursors in PL/PgSQL.Neil Conway2005-01-19
|
* This patch makes some improvements to the rtree index implementation:Neil Conway2005-01-18
| | | | | | | | | | | | | | | | | | | | | | (1) Keep a pin on the scan's current buffer and mark buffer. This avoids the need to do a ReadBuffer() for each tuple produced by the scan. Since ReadBuffer() is expensive, this is a significant win. (2) Convert a ReleaseBuffer(); ReadBuffer() pair into ReleaseAndReadBuffer(). Surely not a huge win, but it saves a lock acquire/release... (3) Remove a bunch of duplicated code in rtget.c; make rtnext() handle both the "initial result" and "subsequent result" cases. (4) Add support for index tuple killing (5) Remove rtscancache(): it is dead code, for the same reason that gistscancache() is dead code (an index scan ought not be invoked with NoMovementScanDirection). The end result is about a 10% improvement in rtree index scan perf, according to contrib/rtree_gist/bench.
* Replace the use of "0" with "NULL" where appropriate in dllist.c, forNeil Conway2005-01-18
| | | | good style and to satisfy sparse. From Alvaro Herrera.
* Win32 8.1 stamp.Bruce Momjian2005-01-18
|
* Update version stamps for 8.1 as listed in RELEASE_CHANGES.Bruce Momjian2005-01-18
|
* Translation updatesPeter Eisentraut2005-01-17
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-16 18:57:25 +0000