aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Avoid changing stdin/stdout to binary mode on Windows unless that isTom Lane2005-09-11
| | | | | | | really the source or destination of the archive. I think this will resolve recent complaints that password prompting is broken in pg_restore on Windows. Note that password prompting and reading from stdin is an unworkable combination on Windows ... but that was true anyway.
* Given its current definition that depends on time(NULL), timetz_zoneTom Lane2005-09-09
| | | | | | | | | is certainly no longer immutable, but must indeed be marked volatile. I wonder if it should use the value of now() (that is, transaction start time) so that it could be marked stable. But it's probably not important enough to be worth changing the code for ... indeed, I'm not even going to force an initdb for this catalog change, seeing that we just did one a few hours ago.
* timestamptz_izone should return the input, not NULL, when the inputTom Lane2005-09-09
| | | | | | is a non-finite timestamp, for consistency with related functions. In other words: +infinity rotated to a different timezone is still +infinity.
* Fix the various forms of AT TIME ZONE to accept either timezones foundTom Lane2005-09-09
| | | | | | | | | in the zic database or zone names found in the date token table. This preserves the old ability to do AT TIME ZONE 'PST' along with the new ability to do AT TIME ZONE 'PST8PDT'. Per gripe from Bricklen Anderson. Also, fix some inconsistencies in usage of TZ_STRLEN_MAX --- the old code had the potential for one-byte buffer overruns, though given alignment considerations it's unlikely there was any real risk.
* Create the pg_pltemplate system catalog to hold template informationTom Lane2005-09-08
| | | | | | for procedural languages. This replaces the hard-wired table I had originally proposed as a stopgap solution. For the moment, the initial contents only include languages shipped with the core distribution.
* Update regression tests for new USA timezone data. Mea culpa for notTom Lane2005-09-08
| | | | realizing that the regression tests could be affected.
* Update timezone data files to release 2005m of the zic database.Tom Lane2005-09-07
| | | | | Among other changes, this reflects the recently passed change in USA daylight savings rules.
* Implement a preliminary 'template' facility for procedural languages,Tom Lane2005-09-05
| | | | | | | | | | | | | | as per my recent proposal. For now the template data is hard-wired in proclang.c --- this should be replaced later by a new shared system catalog, but we don't want to force initdb during 8.1 beta. This change lets us cleanly load existing dump files even if they contain outright wrong information about a PL's support functions, such as a wrong path to the shared library or a missing validator function. Also, we can revert the recent kluges to make pg_dump dump PL support functions that are stored in pg_catalog. While at it, I removed the code in pg_regress that replaced $libdir with a hardcoded path for temporary installations. This is no longer needed given our support for relocatable installations.
* 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.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 05:49:19 +0000