aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add a few items to the release notes, and make a few more minor cleanups.Neil Conway2005-09-12
|
* Tweak TCP-keepalive code so that an invalid setting doesn't cause usTom Lane2005-09-12
| | | | | | | to drop connections unceremoniously. Also some other marginal cleanups: don't query getsockopt() repeatedly if it fails, and avoid having the apparent definition of struct Port depend on which system headers you might have included or not. Oliver Jowett and Tom Lane.
* Many small improvements and copy edits to the release notes. Use "—"Neil Conway2005-09-11
| | | | | | rather than "-" for the "dash" character. Correct SGML markup. Make references to the names of contributors more consistent. Rewrite a bit of prose, and make some other similar cleanups.
* Fix some corner-case bugs in _sendSQLLine's parsing of SQL commandsTom Lane2005-09-11
| | | | | | | | | > found in a pg_dump archive. It had problems with dollar-quote tags broken across bufferload boundaries (this may explain bug report from Rod Taylor), also with dollar-quote literals of the form $a$a$..., and was also confused about the rules for backslash in double quoted identifiers (ie, they're not special). Also put in placeholder support for E'...' literals --- this will need more work later.
* 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.
* Update URL for FAQ_MINGW.Bruce Momjian2005-09-10
|
* 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.
* Add a note about CSV lines with trailing spaces.Andrew Dunstan2005-09-05
| | | | Suggestion by Darcy Buskermolen, reworded by me.
* 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.
* Fix typo in Richard's last name.Alvaro Herrera2005-09-04
|
* libpgport routines need nonstandard palloc to work on Windows.Tom Lane2005-09-03
| | | | Propagate hack that's in dirmod.c to copydir.c.
* Add idea:Bruce Momjian2005-09-03
| | | | | | < cmin/cmax pair and is stored in local memory. > cmin/cmax pair and is stored in local memory. Another idea is to > store both cmin and cmax only in local memory.
* Add log display label for unnamed server-side portals.Bruce Momjian2005-09-02
|
* Fix the spelling.Tom Lane2005-09-02
|
* Update.Bruce Momjian2005-09-02
| | | | | | | | | | | < have its heap and index files truncated. One issue is < that no other backend should be able to add to the table < at the same time, which is something that is currently < allowed. > removed or have its heap and index files truncated. One > issue is that no other backend should be able to add to > the table at the same time, which is something that is > currently allowed.
* Update:Bruce Momjian2005-09-02
| | | | | | | | | | > o Allow COPY on a newly-created table to skip WAL logging 450a452,456 > On crash recovery, the table involved in the COPY would > have its heap and index files truncated. One issue is > that no other backend should be able to add to the table > at the same time, which is something that is currently > allowed.
* Update:Bruce Momjian2005-09-02
| | | | | < o Allow COPY into an empty table to skip WAL logging > o Allow COPY into an new table to skip WAL logging
* Update listen_addresses description.Bruce Momjian2005-09-02
| | | | Darcy Buskermolen
* Add:Bruce Momjian2005-09-02
| | | | | | | | | | | > * Use UTF8 encoding for NLS messages so all server encodings can > read them properly < o %Add support for Unicode < < To fix this, the data needs to be converted to/from UTF16/UTF8 < so the Win32 wcscoll() can be used, and perhaps other functions < like towupper(). However, UTF8 already works with normal < locales but provides no ordering or character set classes.
* Update wording:Bruce Momjian2005-09-02
| | | | | | | | < could only see committed rows from another transaction. However, > could only see rows from another completed transaction. However, 981c981 < proper visibility of the row, for example, for cursors. > proper visibility of the row's cmin, for example, for cursors.
* Add:Bruce Momjian2005-09-02
| | | | > o Allow COPY into an empty table to skip WAL logging
* 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.
* Add text:Bruce Momjian2005-09-02
| | | | | | | | | | | | | | | | | | | | | | * Merge xmin/xmax/cmin/cmax back into three header fields Before subtransactions, there used to be only three fields needed to store these four values. This was possible because only the current transaction looks at the cmin/cmax values. If the current transaction created and expired the row the fields stored where xmin (same as xmax), cmin, cmax, and if the transaction was expiring a row from a another transaction, the fields stored were xmin (cmin was not needed), xmax, and cmax. Such a system worked because a transaction could only see committed rows from another transaction. However, subtransactions can see rows from outer transactions, and once the subtransaction completes, the outer transaction continues, requiring the storage of all four fields. With subtransactions, an outer transaction can create a row, a subtransaction expire it, and when the subtransaction completes, the outer transaction still has to have proper visibility of the row, for example, for cursors. One possible solution is to create a phantom cid which represents a cmin/cmax pair and is stored in local memory.
* Add some notes about how pg_dump relates to the practices recommendedTom Lane2005-09-02
| | | | under 'Populating a Database'.
* Update performance discussion for 8.1. Add a little more explanatoryTom Lane2005-09-02
| | | | | material in the EXPLAIN section, update examples to match current reality, show examples of bitmap indexscans as well as plain ones.
* Duplicate:Bruce Momjian2005-09-02
| | | | | | | | | | | | | | < * Maintain a map of recently-expired rows < < This allows vacuum to target specific pages for possible free space < without requiring a sequential scan. < Update entry: > One complexity is that index entries still have to be vacuumed, and > doing this without an index scan (by using the heap values to find the > index entry) might be slow and unreliable, especially for user-defined > index functions.
* Correct comment about why contrib/xml2 isn't built automatically.Tom Lane2005-09-01
|
* Update storage.sgml to reflect current reality.Tom Lane2005-09-01
|
* 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.
* 8.0.3 is now the most recent version.Bruce Momjian2005-09-01
|
* Update disk space computation because oids are now optional.Bruce Momjian2005-09-01
|
* Fix unportable uses of <ctype.h> functions. Per Sergey Koposov.Tom Lane2005-09-01
|
* Add:Bruce Momjian2005-08-30
| | | | > * Eventually enable escape_string_warning and standard_conforming_strings
* Add regression tests for disabling constraints.Bruce Momjian2005-08-30
| | | | Gavin Sherry
* Remove a couple of obsolete statements about how many buffers you canTom Lane2005-08-30
| | | | fit into a 512K shared memory segment.
* 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.
* Improve table describing shared memory parameters.Tom Lane2005-08-30
|
* Mention max_prepared_transactions in PREPARE TRANSACTION reference page,Tom Lane2005-08-30
| | | | per Bruce's suggestion.
* 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
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 17:27:16 +0000