aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Back out prior patch and instead just suppress SubqueryScan eliminationTom Lane2005-09-05
| | | | | | | | when there are extra resjunk columns in the child node. I found some additional cases involving Append nodes that weren't handled by the prior patch, and it's not clear how to fix them in the same way without breaking inheritance cases. So the prudent path seems to be to narrow the scope of the optimization.
* Clean up version comparison/display code, per gripe from Michael Fuhr.Tom Lane2005-09-05
|
* For non-projecting plan node types such as Limit, set_plan_referencesTom Lane2005-09-05
| | | | | | has to recopy the input plan node's targetlist if it removes a SubqueryScan node just below the non-projecting node. For simplicity I made it recopy always. Per bug report from Allan Wang and Michael Fuhr.
* Conditionally output the server version number in psql if it doesn'tBruce Momjian2005-09-05
| | | | | exactly match the client version number, and warn about major version mismatches.
* libpgport routines need nonstandard palloc to work on Windows.Tom Lane2005-09-03
| | | | Propagate hack that's in dirmod.c to copydir.c.
* Add log display label for unnamed server-side portals.Bruce Momjian2005-09-02
|
* Fix the spelling.Tom Lane2005-09-02
|
* Update listen_addresses description.Bruce Momjian2005-09-02
| | | | Darcy Buskermolen
* Clean up a couple of ad-hoc computations of the maximum number of tuplesTom Lane2005-09-02
| | | | | | | | | | | on a page, as suggested by ITAGAKI Takahiro. Also, change a few places that were using some other estimates of max-items-per-page to consistently use MaxOffsetNumber. This is conservatively large --- we could have used the new MaxHeapTuplesPerPage macro, or a similar one for index tuples --- but those places are simply declaring a fixed-size buffer and assuming it will work, rather than actively testing for overrun. It seems safer to size these buffers in a way that can't overflow even if the page is corrupt.
* In copy_file, use a palloc'd buffer instead of just a local char array;Tom Lane2005-09-02
| | | | | a local array isn't guaranteed to have any particular alignment, and so it could slow down the data transfer.
* Short-circuit AllocSetReset if nothing has been palloc'd in the memoryTom Lane2005-09-01
| | | | | context since the previous AllocSetReset. Original patch by Atsushi Ogawa, editorialized on a little bit by Tom Lane.
* Fix unportable uses of <ctype.h> functions. Per Sergey Koposov.Tom Lane2005-09-01
|
* Add regression tests for disabling constraints.Bruce Momjian2005-08-30
| | | | Gavin Sherry
* Log send() failures when sending to statistics process (but only inTom Lane2005-08-30
| | | | | | assert-enabled builds). This is a temporary measure to see if we can learn anything about those intermittent stats test failures in the buildfarm.
* DropTableSpace forgot to remove dependency on tablespace's owner.Tom Lane2005-08-30
| | | | Per report from Jaime Casanova.
* Fix misleading comment.Tom Lane2005-08-30
|
* Update documentation about shared memory sizing to reflect currentTom Lane2005-08-30
| | | | reality.
* Reduce default value of max_prepared_transactions from 50 to 5. ThisTom Lane2005-08-29
| | | | | | | | | saves nearly 700kB in the default shared memory segment size, which seems worthwhile, and it is a feature that many users won't use anyway. Per Heikki's argument, there is no point in a compromise value --- those who are using 2PC at all will probably want it at least equal to max_connections. But we can't set it to zero by default without breaking the prepared_xacts regression test.
* Fix platform-specific test for path prefix-ness: move it into path.c whereTom Lane2005-08-29
| | | | | it can be done right. Allow explicit use of absolute DataDir path. Per Dave Page.
* Fix misspelled error message.Tom Lane2005-08-29
|
* Allow Win32 libpq will use it's minimal pthread implementation, and ecpgBruce Momjian2005-08-29
| | | | | | will use pthreadGC2. Dave Page
* Sigh, looks like you need '.set mips2' before you can access MIPSTom Lane2005-08-29
| | | | SYNC instruction.
* Tweak nodeBitmapAnd to stop evaluating sub-plan scans if it finds it'sTom Lane2005-08-28
| | | | | got an empty bitmap after any step; the remaining subplans can no longer affect the result. Per a suggestion from Ilia Kantor.
* Fix initdb quoting for Win32 paths in final examples, per Dave Page.Bruce Momjian2005-08-28
|
* Update pthread_self() on Win32 to return DWORD.Bruce Momjian2005-08-28
|
* Use GetCurrentThreadId, per Magnus.Bruce Momjian2005-08-28
|
* Add a SYNC instruction to the S_UNLOCK sequence for MIPS.Tom Lane2005-08-28
|
* Add comment about pthread_self() cast.Bruce Momjian2005-08-28
|
* dumpUserConfig failed (in a pretty harmless way, but failed nonetheless)Tom Lane2005-08-28
| | | | | to cope with a group name when dumping from a pre-8.1 installation. Per report from Stefan Kaltenbrunner.
* cost_agg really ought to charge something per output tuple; else thereTom Lane2005-08-27
| | | | are cases where it appears to have zero run cost.
* Change the division of labor between grouping_planner and query_plannerTom Lane2005-08-27
| | | | | | | | | | | | | | so that the latter estimates the number of groups that grouping will produce. This is needed because it is primarily query_planner that makes the decision between fast-start and fast-finish plans, and in the original coding it was unable to make more than a crude rule-of-thumb choice when the query involved grouping. This revision helps us make saner choices for queries like SELECT ... GROUP BY ... LIMIT, as in a recent example from Mark Kirkwood. Also move the responsibility for canonicalizing sort_pathkeys and group_pathkeys into query_planner; this information has to be available anyway to support the first change, and doing it this way lets us get rid of compare_noncanonical_pathkeys entirely.
* Windows needs WSAStartup() before getaddrinfo() will work. Andrew DunstanTom Lane2005-08-27
|
* Fix two separate bugs in setrefs.c. set_subqueryscan_references needsTom Lane2005-08-27
| | | | | | | | | | | | | | | to copy the whole plan tree before invoking adjust_plan_varnos(); else if there is any multiply-linked substructure, the latter might increment some Var's varno twice. Previously there were some retail copyObject calls inside adjust_plan_varnos, but it seems a lot safer to just dup the whole tree first. Also, set_inner_join_references was trying to avoid work by not recursing if a BitmapHeapScan's bitmapqualorig contained no outer references; which was OK at the time the code was written, I think, but now that create_bitmap_scan_plan removes duplicate clauses from bitmapqualorig it is possible for that field to be NULL while outer references still remain in the qpqual and/or contained indexscan nodes. For safety, always recurse even if the BitmapHeapScan looks to be outer reference free. Per reports from Michael Fuhr and Oleg Bartunov.
* Get the MIPS assembler syntax right. Also add a separate sync command;Tom Lane2005-08-27
| | | | | the reference I consulted yesterday said SC does a SYNC, but apparently this is not true on newer MIPS processors, so be safe.
* Another try at the inlined MIPS spinlock code. Can't test this myself,Tom Lane2005-08-26
| | | | but for sure it's not any more broken than the prior version.
* The idea of using _strncoll() on Windows doesn't work. Revert to sameTom Lane2005-08-26
| | | | code as we use on other platforms when encoding is not UTF8.
* Adjust m68k spinlock code to avoid duplicate in-line and not-in-lineTom Lane2005-08-26
| | | | definitions on recent Linux systems, per Martin Pitt.
* Some more mop-up for Windows IPv6 support. Andrew DunstanTom Lane2005-08-26
|
* Arrange for indexes and toast tables to inherit their ownership fromTom Lane2005-08-26
| | | | | | the parent table, even if the command that creates them is executed by someone else (such as a superuser or a member of the owning role). Per gripe from Michael Fuhr.
* Fix bogus freeaddrinfo() call in WIN32 code, extend gai_strerror toTom Lane2005-08-25
| | | | cover more error codes. Per Petr Jelinek.
* Replace out-of-line tas() assembly code for MIPS with a properlyTom Lane2005-08-25
| | | | constrained GCC inline version. Thiemo Seufer, by way of Martin Pitt.
* Factor out the common subexpression month_remainder * DAYS_PER_MONTHTom Lane2005-08-25
| | | | | | | | | in interval_mul and interval_div. This avoids an optimization bug in A Certain Company's compiler (and given their explanation, I wouldn't be surprised if other compilers blow it too). Besides the code seems more clear this way --- in the original formulation, you had to mentally recognize the common subexpression in order to understand what was going on.
* Back out pfrees for justify_hour function calls.Bruce Momjian2005-08-25
|
* Original assumption that our own getaddrinfo routine would never supportTom Lane2005-08-25
| | | | | | IPv6 is obsoleted by recent Windows patch. Perform the runtime test whenever HAVE_IPV6 is set. This should be OK since initdb can get getaddrinfo from libpgport if needed.
* Fix memory leak when using justify_hours.Bruce Momjian2005-08-25
|
* Update release checklist.Bruce Momjian2005-08-25
|
* Add code to use Windows getaddrinfo and friends if they exist. ThisTom Lane2005-08-24
| | | | | has to be tested dynamically if we want to make portable executables. Chuck McDevitt and Andrew Dunstan.
* Back off allow_nonpic_in_shlib for FreeBSD builds: only set it on i386.Tom Lane2005-08-24
| | | | | This might be overly conservative, but we know it does not work on amd64. Per buildfarm results.
* More beta1 cleanup.Bruce Momjian2005-08-24
|
* Fix SHOW and RESET grammar to accept custom variable names.Tom Lane2005-08-24
|