aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add some documentation for constraint exclusion and basic partitioning.Neil Conway2005-11-01
| | | | From Simon Riggs; cleanup and editorialization by Neil Conway.
* Make an editorial pass over the reference pages.Tom Lane2005-11-01
|
* Provide a --no-locale option for pg_regress and a corresponding NOLOCALE=1Andrew Dunstan2005-11-01
| | | | | | | setting for the regression makefile, allowing Windows users to force locale settings since Windows does not get its locale from the environment. Per Petr Jelinek.
* Update supported-platforms entry for Tru64.Tom Lane2005-10-31
|
* Mention in the docs that temporary/non-temp tables can not shareBruce Momjian2005-10-31
| | | | referential integrity relationships.
* Add sanity check of queryTeodor Sigaev2005-10-31
|
* Update supported-platforms list.Tom Lane2005-10-30
|
* tag it for rc1REL8_1_0RC1PostgreSQL Daemon2005-10-30
|
* Fix psql ref typo.Bruce Momjian2005-10-30
| | | | Andreas Seltenreich
* Fix some allocation size calculation errors that would cause pgbenchTom Lane2005-10-29
| | | | to fail with large test scripts.
* Update a couple of obsolete comments.Tom Lane2005-10-29
|
* Translation updatesPeter Eisentraut2005-10-29
|
* Message correctionsPeter Eisentraut2005-10-29
|
* Update supported-platforms list.Tom Lane2005-10-28
|
* Fix broken markup.Tom Lane2005-10-28
|
* Reorder code so that we don't have to hold a critical section whileTom Lane2005-10-28
| | | | | reserving SLRU space for a new MultiXact. The original coding would have treated out-of-disk-space as a PANIC condition, which is unnecessary.
* Clean up AIX build to avoid 'duplicate symbol' warnings, by moving useTom Lane2005-10-28
| | | | | | | of postgres.imp file into BE_DLLLIBS macro. This makes the AIX build work more like the Windows and Darwin builds, which have similar requirements to mention a backend library when linking shared libraries that will be dynamically loaded into the backend.
* Fix race condition in multixact code: it's possible to try to read aTom Lane2005-10-28
| | | | | | | | | | multixact's starting offset before the offset has been stored into the SLRU file. A simple fix would be to hold the MultiXactGenLock until the offset has been stored, but that looks like a big concurrency hit. Instead rely on knowledge that unset offsets will be zero, and loop when we see a zero. This requires a little extra hacking to ensure that zero is never a valid value for the offset. Problem reported by Matteo Beccati, fix ideas from Martijn van Oosterhout, Alvaro Herrera, and Tom Lane.
* 1 Fix problem with lost precision in rank with OR-ed lexemesTeodor Sigaev2005-10-28
| | | | 2 Allow tsquery_in to input void tsquery: resolve dump/restore problem with tsquery
* Remove mention that \x doesn't affect backslash commands.Bruce Momjian2005-10-28
|
* Add an ifneq to avoid make warning on AIX --- there is a separate ruleTom Lane2005-10-27
| | | | | for postgres: on line 86, and line 43 shouldn't be used. Noted while looking at kookaburra buildfarm results.
* Tweak buffer manager so that 'internal' accesses to a buffer do notTom Lane2005-10-27
| | | | | | | | advance its usage_count. This includes writes of dirty buffers triggered by bgwriter, checkpoint, or FlushRelationBuffers, as well as various corner cases that really ought not count as accesses to the page. Should make for some marginal improvement in the quality of our decisions about when to recycle buffers. Per suggestion from ITAGAKI Takahiro.
* Update:Bruce Momjian2005-10-27
| | | | | < o Allow ALTER TABLE RENAME CONSTRAINT > o Add ALTER TABLE RENAME CONSTRAINT, update index name also
* Add:Bruce Momjian2005-10-27
| | | | | > o Have ALTER INDEX update the name of a constraint using that index > o Allow ALTER TABLE RENAME CONSTRAINT
* Add mention that .pgpass localhost matches tcp and unix domain sockets.Bruce Momjian2005-10-27
|
* Add mention of errfinish.Bruce Momjian2005-10-27
|
* Disable expanded mode only for \d tablename, not for all backslashBruce Momjian2005-10-27
| | | | commands. Per complaint that \df+ is clearer in expanded mode.
* Add comment documenting actual failure case of usingBruce Momjian2005-10-27
| | | | | interval_justify_hours in timestamp subtraction. TODO already has text description.
* Add items from Tom:Bruce Momjian2005-10-27
| | | | | | | | | | | | | | | | | | | < o Add a GUC variable to allow output of interval values in ISO8601 < format 212a211,223 > o Add a GUC variable to allow output of interval values in ISO8601 > format > o Improve timestamptz subtraction to be DST-aware > > Currently, subtracting one date from another that crosses a > daylight savings time adjustment can return '1 day 1 hour', but > adding that back to the first date returns a time one hour in > the future. This is caused by the adjustment of '25 hours' to > '1 day 1 hour', and '1 day' is the same time the next day, even > if daylight savings adjustments are involved. > > o Fix interval display to support values exceeding 2^31 hours > o Add overflow checking to timestamp and interval arithmetic
* Add info about using rsync to make base backups. Per report fromTom Lane2005-10-26
| | | | Jeff Frost, it may be necessary to ignore specific exit codes.
* Adjust parser so that POSTQUEL-style implicit RTEs are stored withTom Lane2005-10-26
| | | | | | inFromCl true, meaning that they will list out as explicit RTEs if they are in a view or rule. Update comments about inFromCl to reflect the way it's now actually used. Per recent discussion.
* Rename config section headings.Bruce Momjian2005-10-26
| | | | Simon Riggs
* Fix longstanding bug that would sometimes let the planner generate a bad planTom Lane2005-10-25
| | | | | | | | | | for an outer join; symptom is bogus error "RIGHT JOIN is only supported with merge-joinable join conditions". Problem was that select_mergejoin_clauses did its tests in the wrong order. We need to force left join not right join for a merge join when there are non-mergeable join clauses; but the test for this only accounted for mergejoinability of the clause operator, and not whether the left and right Vars were of the proper relations. Per report from Jean-Pierre Pelletier.
* Add:Bruce Momjian2005-10-25
| | | | | | | | > > o Add auto-expanded mode so expanded output is used if the row > length is wider than the screen width. > > Consider using auto-expanded mode for backslash commands like \df+.
* Convert explanation of interval change into something resembling grammaticalTom Lane2005-10-25
| | | | English, and fix the incorrect example.
* Remove justify_hours call from interval_mul and interval_div, and makeTom Lane2005-10-25
| | | | | | | some small stylistic improvements in these functions. Also fix several places where TMODULO() was being used with wrong-sized quotient argument, creating a risk of overflow --- interval2tm was actually capable of going into an infinite loop because of this.
* Small grammar correction.Tom Lane2005-10-25
|
* Fix Windows setitimer() emulation to not depend on delivering an APCTom Lane2005-10-25
| | | | | | to the main thread. This allows removal of WaitForSingleObjectEx() calls from the main thread, thereby allowing us to re-enable Qingqing Zhou's CHECK_FOR_INTERRUPTS performance improvement. Qingqing, Magnus, et al.
* Update 24 hours/1 day distinction in release notes.Bruce Momjian2005-10-25
|
* Change trace_sort to output to the log, rather than the user's terminal.Bruce Momjian2005-10-25
|
* Update the URL for "The Hitch-Hiker's Guide to Evolutionary Computation".Bruce Momjian2005-10-25
| | | | Sergey E. Koposov
* IBM has addressed the socket address storage issue as of AIX 5.3Bruce Momjian2005-10-24
| | | | | | | maintenance level 5300-03; the following patch adds documentation to FAQ_AIX. Chris Browne
* Add:Bruce Momjian2005-10-24
| | | | | > * Allow user-defined functions retuning a domain value to enforce domain > constraints
* More forcefully recommend MD5 over crypt authentication.Bruce Momjian2005-10-24
|
* Fix incorrect wording about function failure time on unsafe ops - theseAndrew Dunstan2005-10-24
| | | | | are now caught by the validator. And a small visit from the perl style police: check the return value from open().
* I have applied the following patch to document PQinitSSL() andBruce Momjian2005-10-24
| | | | | | | | | | | PQregisterThreadLock(). I also remove the crypt() mention in the libpq threading section and added a single sentence in the client-auth manual page under crypt(). Crypt authentication is so old now that a separate paragraph about it seemed unwise. I also added a comment about our use of locking around pqGetpwuid().
* Ensure that a plpgsql LOOP with an empty body still executes at leastTom Lane2005-10-24
| | | | | one CHECK_FOR_INTERRUPTS() call, so that you can control-C out of the loop. Reported by Merlin Moncure.
* A bit of minor copy-editing.Tom Lane2005-10-23
|
* I've confirmed 8.1beta4 passes regression tests on all hardware platformsTom Lane2005-10-23
| | | | of RHEL 4. Update supported-platforms list accordingly.
* update configure and bugtemplate for beta 4 ...REL8_1_0BETA4PostgreSQL Daemon2005-10-22
|