aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Fix ALTER DATABASE RENAME to allow the operation if user is a superuserTom Lane2005-03-12
| | | | | who for some reason isn't marked usecreatedb. Per report from Alexander Pravking. Also fix sloppy coding in have_createdb_privilege().
* Fix problem with infinite recursion between write_syslogger_file andTom Lane2005-03-12
| | | | | | | | elog if the former has trouble writing its file. Code review for Magnus' patch to redirect stderr to syslog on Windows (Bruce's version seems right, but did some minor prettification). Backpatch both changes to 8.0 branch.
* Properly implement "Response files" for bcc. Add URL's to describe theBruce Momjian2005-03-07
| | | | feature for Win32 and bcc.
* Replace ARC cache management algorithm with the similar but slightlyTom Lane2005-03-03
| | | | | | | | | simpler 2Q algorithm, to avoid possible problems with the pending patent on ARC. Testing so far suggests that there is little if any performance loss from doing this. Note that this patch is going into the 8.0 branch only; a much more extensive revision is planned for HEAD.
* Release proclock immediately in RemoveFromWaitQueue() if it representsTom Lane2005-03-01
| | | | | | no held locks. This maintains the invariant that proclocks are present only for procs that are holding or awaiting a lock; when this is not true, LockRelease will fail. Per report from Stephen Clouse.
* Adjust OR indexscan logic to not generate redundant condition-free ORTom Lane2005-03-01
| | | | | | indexscans involving partial indexes. These would always be dominated by a simple indexscan on such an index, so there's no point in considering them. Fixes overoptimism in a patch I applied last October.
* Revert the logic for expanding AND/OR conditions in pred_test() to whatTom Lane2005-03-01
| | | | | | it was in 7.4, and add some comments explaining why it has to be this way. I broke it for OR'd index predicates in a fit of code cleanup last summer. Per example from Sergey Koshcheyev.
* Tab indent all actions in bcc32.mak, and do it on win32.mak too forBruce Momjian2005-02-27
| | | | consistency. Backpatch only bcc32.mak to 8.0.X.
* Add linking from /port to bcc makefile.Bruce Momjian2005-02-25
|
* Try to get Borland CC to compile.Bruce Momjian2005-02-21
| | | | Backpatch to 8.0.X which doesn't work right now.
* New arrangement to always let the bgwriter do checkpoints brokeTom Lane2005-02-19
| | | | | CHECKPOINT and some other commands in the context of a standalone backend. Allow a standalone backend to do its own checkpoints.
* Ensure that the resolved datatype of any unknown Param is propagatedTom Lane2005-02-19
| | | | | into the sub-SELECT targetlist when it appears in the context INSERT INTO foo SELECT $1 ... Per report from Abhijit Menon-Sen.
* ALTER LANGUAGE RENAME has never worked. Per Sergey Yatskevich.Tom Lane2005-02-14
|
* Print file name and errno string on rmtree failure.Bruce Momjian2005-02-13
| | | | Backpatch to 8.0.X.
* Translation updatesPeter Eisentraut2005-02-11
|
* Fix SPI cursor support to allow scanning the results of utility commandsTom Lane2005-02-10
| | | | | | that return tuples (such as EXPLAIN). Per gripe from Michael Fuhr. Side effect: fix an old bug that unintentionally disabled backward scans for all SPI-created cursors.
* Fixed more parsing bugs in other CREATE statements.Michael Meskes2005-02-10
|
* ALTER TABLE ADD COLUMN exhibits a significant memory leak when adding aNeil Conway2005-02-09
| | | | | | | | | | | | | | | | | | | | column with a default expression. In that situation, we need to rewrite the heap relation. To evaluate the new default expression, we use ExecEvalExpr(); however, this can allocate memory in the current memory context, and ATRewriteTable() does not switch out of the active portal's heap memory context. The end result is a rather large memory leak (on the order of gigabytes for a reasonably sized table). This patch changes ATRewriteTable() to switch to the per-tuple memory context before beginning the per-tuple loop. It also removes an explicit heap_freetuple() in the loop, since that is no longer needed. In an unrelated change, I noticed the code was scanning through the attributes of the new tuple descriptor for each tuple of the old table. I changed this to use precomputation, which should slightly speed up the loop. Thanks to steve@deefs.net for reporting the leak.
* Fixed bug in parsing of CREATE AS statement.Michael Meskes2005-02-09
|
* If we're gonna check for array overrun, we really should do so beforeTom Lane2005-02-08
| | | | overrunning the array, not after.
* Prevent 4 more buffer overruns in the PL/PgSQL parser. This is just aNeil Conway2005-02-07
| | | | | minimally-invasive fix for stable branches; a cleaner fix will be committed to HEAD soon.
* Repair CLUSTER failure after ALTER TABLE SET WITHOUT OIDS. Turns outTom Lane2005-02-06
| | | | | | | there are corner cases involving dropping toasted columns in which the previous coding would fail, too: the new version of the table might not have any TOAST table, but we'd still propagate possibly-wide values of dropped columns forward.
* 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.
* 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.
* Stamp 8.0 branch as 8.0.1.Tom Lane2005-01-30
|
* Translation updatesPeter Eisentraut2005-01-30
|
* 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.
* Backpatch translationsPeter Eisentraut2005-01-27
|
* 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.
* Propagate ecpg core dump fix into 8.0 branch.Tom Lane2005-01-26
|
* 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
|
* Translation updatePeter Eisentraut2005-01-25
|
* 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
|