hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-03-21 03:27:00 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 1dd9b09332 Copy-editing for GiST README. Neil Conway 2005-09-15 17:44:27 +00:00
  • 79fae4a764 Readme about GiST's algorithms Teodor Sigaev 2005-09-15 16:39:15 +00:00
  • 8fb4451a4d Update Snowball. I have to update it because of old version doesn't available on Snowball's site and new version of stemmers can't be compiled with old interface. Teodor Sigaev 2005-09-15 12:41:52 +00:00
  • b4d107a777 Update Snowball. I have to update it because of old version doesn't available on Snowball's site and new version of stemmers can't be compiled with old interface. Teodor Sigaev 2005-09-15 11:56:58 +00:00
  • f82b853b47 1 Update Snowball sources 2 Makefile fixes Teodor Sigaev 2005-09-15 11:14:18 +00:00
  • 3b0453b24f Various documentation improvements. Add a lot of index entries for the builtin functions (although some more entries are still needed), and remove the duplicate index entries that have been causing collateindex.pl warnings. Consistently use "int" and "bigint", rather than a mix of "int", "integer", "int4", "bigint", and "int8". Make parenthesis style in syntax examples more consistent. Various copy-editing for newly-added documentation and SGML markup fixes. Neil Conway 2005-09-14 21:14:26 +00:00
  • 08dc2af91e Tweak the PL/PgSQL regression tests to catch the recently reported bug in parsing cursor declarations. Neil Conway 2005-09-14 18:35:38 +00:00
  • 323f0a6c01 Fix recent breakage of decl_cursor_arglist syntax, per Michael Paesold. Tom Lane 2005-09-14 13:46:47 +00:00
  • 5b0fa0c28c Fix make_tuple_from_row to support nested rowtypes, per gripe from Roman Neuhauser. Update some obsolete comments for exec_eval_datum, too. Tom Lane 2005-09-13 16:16:17 +00:00
  • d6bc885bb9 Minor SGML markup fixes. Neil Conway 2005-09-13 15:24:57 +00:00
  • c93912b711 Document the new autovacuum daemon. Alvaro Herrera 2005-09-13 01:51:18 +00:00
  • 2a11a4937e Fix cut-and-paste-o in TCP keepalives documentation. Tom Lane 2005-09-12 23:09:05 +00:00
  • fe9f96b14c Minor documentation tweak: make the capitalization of a section title consistent with the other sections in this chapter. Neil Conway 2005-09-12 22:39:30 +00:00
  • 8080e8e8ce Ensure that any memory leaked during an error inside the bgwriter is recovered. I did not see any actual leak while testing this in CVS tip, but 8.0 definitely has a problem with leaking the space temporarily palloc'd by BufferSync(). In any case this seems a good idea to forestall similar problems in future. Per report from Arjen van der Meijden. Tom Lane 2005-09-12 22:20:30 +00:00
  • f59b05c95d Ensure that any memory leaked during an error inside the bgwriter is recovered. I did not see any actual leak while testing this in CVS tip, but 8.0 definitely has a problem with leaking the space temporarily palloc'd by BufferSync(). In any case this seems a good idea to forestall similar problems in future. Per report from Arjen van der Meijden. Tom Lane 2005-09-12 22:20:16 +00:00
  • 9813fc1bae Make the documentation of GUC variables a separate chapter, rather than a section of the "Server Run-time Environment" chapter. Also, move the SGML for the new chapter to a separate file and fix the resulting fallout. Neil Conway 2005-09-12 22:11:38 +00:00
  • 37a3ed6e40 Update manual's introduction to indexes to reflect 8.1 changes; in particular the addition of bitmap scans and the relaxation of rules about when multicolumn indexes can be used. Also some minor editorial work in other parts of the chapter. Tom Lane 2005-09-12 19:17:45 +00:00
  • e3523f52f7 Fix a mistake in the documentation for SPI_getbinval(), per Michael Fuhr. Neil Conway 2005-09-12 18:51:29 +00:00
  • 3926b6e9c3 Fix a mistake in the documentation for SPI_getbinval(), per Michael Fuhr. Neil Conway 2005-09-12 18:49:08 +00:00
  • f7259f5ba6 Fix a mistake in the documentation for SPI_getbinval(), per Michael Fuhr. Neil Conway 2005-09-12 18:40:19 +00:00
  • b93a72afbf Forgot to add pg_pltemplate to the list of shared system catalogs that appears in the REINDEX ref page. Tom Lane 2005-09-12 16:43:29 +00:00
  • 39f27463b3 Fixed transaction command handling to not ignore savepoints and to correctly check for errors. Michael Meskes 2005-09-12 11:58:33 +00:00
  • c959d370bf Fixed transaction command handling to not ignore savepoints and to correctly check for errors. Michael Meskes 2005-09-12 11:57:53 +00:00
  • 4fe4563550 Add a few items to the release notes, and make a few more minor cleanups. Neil Conway 2005-09-12 05:10:12 +00:00
  • cc3bda37f7 Tweak TCP-keepalive code so that an invalid setting doesn't cause us 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. Tom Lane 2005-09-12 02:26:33 +00:00
  • f7a5f90c46 Many small improvements and copy edits to the release notes. Use "—" 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. Neil Conway 2005-09-11 23:40:33 +00:00
  • c7d1a8d428 Fix some corner-case bugs in _sendSQLLine's parsing of SQL commands > 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. Tom Lane 2005-09-11 04:10:25 +00:00
  • 3e711451f1 Avoid changing stdin/stdout to binary mode on Windows unless that is 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. Tom Lane 2005-09-11 00:36:35 +00:00
  • e1a7d1b9f3 Avoid changing stdin/stdout to binary mode on Windows unless that is 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. Tom Lane 2005-09-11 00:36:14 +00:00
  • d1348895a7 Update URL for FAQ_MINGW. Bruce Momjian 2005-09-10 05:21:52 +00:00
  • 35979e6c35 Given its current definition that depends on time(NULL), timetz_zone 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. Tom Lane 2005-09-09 06:51:12 +00:00
  • f2ebd01ef0 timestamptz_izone should return the input, not NULL, when the input is a non-finite timestamp, for consistency with related functions. In other words: +infinity rotated to a different timezone is still +infinity. Tom Lane 2005-09-09 06:46:14 +00:00
  • a239af02c3 Fix the various forms of AT TIME ZONE to accept either timezones found 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. Tom Lane 2005-09-09 02:31:50 +00:00
  • 48123de717 Create the pg_pltemplate system catalog to hold template information 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. Tom Lane 2005-09-08 20:07:42 +00:00
  • 16acb8bfd3 Update regression tests for new USA timezone data. Mea culpa for not realizing that the regression tests could be affected. Tom Lane 2005-09-08 16:49:18 +00:00
  • c18cabe8ab Update regression tests for new USA timezone data. Mea culpa for not realizing that the regression tests could be affected. Tom Lane 2005-09-08 16:49:04 +00:00
  • 694da2897b Update timezone data files to release 2005m of the zic database. Among other changes, this reflects the recently passed change in USA daylight savings rules. Tom Lane 2005-09-07 21:39:41 +00:00
  • 69d48cefd1 Update timezone data files to release 2005m of the zic database. Among other changes, this reflects the recently passed change in USA daylight savings rules. Tom Lane 2005-09-07 21:39:25 +00:00
  • e0dedd0559 Implement a preliminary 'template' facility for procedural languages, 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. Tom Lane 2005-09-05 23:50:49 +00:00
  • e35e6b1c37 Back out prior patch and instead just suppress SubqueryScan elimination 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. Tom Lane 2005-09-05 18:59:38 +00:00
  • 2da2d34770 Clean up version comparison/display code, per gripe from Michael Fuhr. Tom Lane 2005-09-05 18:05:13 +00:00
  • 03728942c2 For non-projecting plan node types such as Limit, set_plan_references 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. Tom Lane 2005-09-05 17:25:01 +00:00
  • 2739e1d1c2 Add a note about CSV lines with trailing spaces. Suggestion by Darcy Buskermolen, reworded by me. Andrew Dunstan 2005-09-05 14:44:05 +00:00
  • 656fe39b84 Conditionally output the server version number in psql if it doesn't exactly match the client version number, and warn about major version mismatches. Bruce Momjian 2005-09-05 13:59:08 +00:00
  • e8f35414ef Fix typo in Richard's last name. Alvaro Herrera 2005-09-04 13:40:24 +00:00
  • a17dbec893 libpgport routines need nonstandard palloc to work on Windows. Propagate hack that's in dirmod.c to copydir.c. Tom Lane 2005-09-03 15:55:00 +00:00
  • 57fd3d22d7 Translation update Peter Eisentraut 2005-09-03 07:41:58 +00:00
  • 752b861067 Translation update Peter Eisentraut 2005-09-03 07:41:11 +00:00
  • b72fe49b9c Add idea: Bruce Momjian 2005-09-03 00:41:30 +00:00
  • 11b5c554c2 Add log display label for unnamed server-side portals. Bruce Momjian 2005-09-02 21:50:54 +00:00
  • 0802078556 Fix the spelling. Tom Lane 2005-09-02 21:25:30 +00:00
  • 264cd5f04a Update. Bruce Momjian 2005-09-02 21:23:05 +00:00
  • ef6d5b4e25 Update: Bruce Momjian 2005-09-02 21:10:59 +00:00
  • f8ec875c39 Update: Bruce Momjian 2005-09-02 21:01:20 +00:00
  • 4506ec95cf Update listen_addresses description. Bruce Momjian 2005-09-02 21:00:59 +00:00
  • 5bddded69c Add: Bruce Momjian 2005-09-02 20:11:34 +00:00
  • 3bea1a353f Update wording: Bruce Momjian 2005-09-02 19:51:37 +00:00
  • da08559e9b Add: Bruce Momjian 2005-09-02 19:39:15 +00:00
  • 35e9b1cc1e Clean up a couple of ad-hoc computations of the maximum number of tuples 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. Tom Lane 2005-09-02 19:02:20 +00:00
  • 962a4bb69f In copy_file, use a palloc'd buffer instead of just a local char array; a local array isn't guaranteed to have any particular alignment, and so it could slow down the data transfer. Tom Lane 2005-09-02 18:55:32 +00:00
  • fad7e8edac Add text: Bruce Momjian 2005-09-02 15:22:44 +00:00
  • 6c0398a73f Add some notes about how pg_dump relates to the practices recommended under 'Populating a Database'. Tom Lane 2005-09-02 03:19:53 +00:00
  • 9a412be5eb Update performance discussion for 8.1. Add a little more explanatory material in the EXPLAIN section, update examples to match current reality, show examples of bitmap indexscans as well as plain ones. Tom Lane 2005-09-02 00:57:57 +00:00
  • 55af2a4337 Duplicate: Bruce Momjian 2005-09-02 00:49:57 +00:00
  • ce128c01a6 Correct comment about why contrib/xml2 isn't built automatically. Tom Lane 2005-09-01 22:02:44 +00:00
  • e32a2ec68e Update storage.sgml to reflect current reality. Tom Lane 2005-09-01 20:01:53 +00:00
  • a635ab46be Short-circuit AllocSetReset if nothing has been palloc'd in the memory context since the previous AllocSetReset. Original patch by Atsushi Ogawa, editorialized on a little bit by Tom Lane. Tom Lane 2005-09-01 18:15:42 +00:00
  • 91a21b532d 8.0.3 is now the most recent version. Bruce Momjian 2005-09-01 16:18:51 +00:00
  • fc9b6451a5 Update disk space computation because oids are now optional. Bruce Momjian 2005-09-01 16:18:08 +00:00
  • 14720f7c57 Fix unportable uses of <ctype.h> functions. Per Sergey Koposov. Tom Lane 2005-09-01 15:34:31 +00:00
  • bc0650660a Add: Bruce Momjian 2005-08-30 23:25:23 +00:00
  • 59b4cef1eb Add regression tests for disabling constraints. Bruce Momjian 2005-08-30 18:57:48 +00:00
  • 571be6f381 Remove a couple of obsolete statements about how many buffers you can fit into a 512K shared memory segment. Tom Lane 2005-08-30 15:48:28 +00:00
  • ba5f900b3d Fix missing rows in query update a=.. where a... with GiST index on column 'a' Backpatch from 8.0 branch Teodor Sigaev 2005-08-30 08:48:16 +00:00
  • d4235f9f18 Fix missing rows in query update a=.. where a... with GiST index on column 'a' Backpatch from 8.0 branch Teodor Sigaev 2005-08-30 08:36:52 +00:00
  • 13ff51baf2 Fix missing rows in query update a=.. where a... with GiST index on column 'a' Teodor Sigaev 2005-08-30 07:57:48 +00:00
  • b740be2520 Log send() failures when sending to statistics process (but only in assert-enabled builds). This is a temporary measure to see if we can learn anything about those intermittent stats test failures in the buildfarm. Tom Lane 2005-08-30 02:47:37 +00:00
  • e038e89466 Improve table describing shared memory parameters. Tom Lane 2005-08-30 02:09:29 +00:00
  • cc367951a9 Mention max_prepared_transactions in PREPARE TRANSACTION reference page, per Bruce's suggestion. Tom Lane 2005-08-30 01:37:38 +00:00
  • 13065c7174 DropTableSpace forgot to remove dependency on tablespace's owner. Per report from Jaime Casanova. Tom Lane 2005-08-30 01:08:47 +00:00
  • 139b1f61ce Fix misleading comment. Tom Lane 2005-08-30 01:07:54 +00:00
  • 78ef2d3feb Update documentation about shared memory sizing to reflect current reality. Tom Lane 2005-08-30 00:58:48 +00:00
  • 037709e0b3 Reduce default value of max_prepared_transactions from 50 to 5. This 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. Tom Lane 2005-08-29 21:38:18 +00:00
  • 8aec77fb9f Fix platform-specific test for path prefix-ness: move it into path.c where it can be done right. Allow explicit use of absolute DataDir path. Per Dave Page. Tom Lane 2005-08-29 19:39:39 +00:00
  • 6b44d796c7 Fix misspelled error message. Tom Lane 2005-08-29 01:32:00 +00:00
  • 1a6fe83011 Allow Win32 libpq will use it's minimal pthread implementation, and ecpg will use pthreadGC2. Bruce Momjian 2005-08-29 00:47:35 +00:00
  • 846ed05de6 Sigh, looks like you need '.set mips2' before you can access MIPS SYNC instruction. Tom Lane 2005-08-29 00:41:44 +00:00
  • 2d03390945 Sigh, looks like you need '.set mips2' before you can access MIPS SYNC instruction. Tom Lane 2005-08-29 00:41:34 +00:00
  • 46a0eee300 Tweak nodeBitmapAnd to stop evaluating sub-plan scans if it finds it's got an empty bitmap after any step; the remaining subplans can no longer affect the result. Per a suggestion from Ilia Kantor. Tom Lane 2005-08-28 22:47:20 +00:00
  • 75e90bbf69 Fix initdb quoting for Win32 paths in final examples, per Dave Page. Bruce Momjian 2005-08-28 22:21:46 +00:00
  • 3b85fc3a52 Update pthread_self() on Win32 to return DWORD. Bruce Momjian 2005-08-28 21:42:28 +00:00
  • a78a530829 Add: Bruce Momjian 2005-08-28 18:52:37 +00:00
  • 8046c1c7e6 Use GetCurrentThreadId, per Magnus. Bruce Momjian 2005-08-28 18:49:01 +00:00
  • 9f70dce4ce Add a SYNC instruction to the S_UNLOCK sequence for MIPS. Tom Lane 2005-08-28 18:26:07 +00:00
  • 7319ab9a59 Add a SYNC instruction to the S_UNLOCK sequence for MIPS. Tom Lane 2005-08-28 18:26:01 +00:00
  • 0c172b215a Add comment about pthread_self() cast. Bruce Momjian 2005-08-28 16:37:48 +00:00
  • 0845538f3a dumpUserConfig failed (in a pretty harmless way, but failed nonetheless) to cope with a group name when dumping from a pre-8.1 installation. Per report from Stefan Kaltenbrunner. Tom Lane 2005-08-28 16:31:37 +00:00
  • 974e3cf30a cost_agg really ought to charge something per output tuple; else there are cases where it appears to have zero run cost. Tom Lane 2005-08-27 22:37:00 +00:00
  • 4e5fbb34b3 Change the division of labor between grouping_planner and query_planner 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. Tom Lane 2005-08-27 22:13:44 +00:00
  • 9e56c5a4cf Windows needs WSAStartup() before getaddrinfo() will work. Andrew Dunstan Tom Lane 2005-08-27 18:44:03 +00:00