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

Commit Graph

  • 18ea8ae531 Attached patch takes a swing at improving the autovacuum wording in maintenance.sgml. Bruce Momjian 2005-09-23 02:01:35 +00:00
  • 0135cd88bd Add warning about DOMAINs. Bruce Momjian 2005-09-22 23:56:46 +00:00
  • c79671bdbb Add: Bruce Momjian 2005-09-22 23:54:09 +00:00
  • ec294fc6cb Move table constraint patch up into the main new features section of the release notes. Bruce Momjian 2005-09-22 23:47:44 +00:00
  • d7e4fd99e5 Fix bug introduced into indexable_outerrelids() by an ill-considered "optimization". When we find a potentially useful joinclause, we have to add all its other required_relids to the result, not only the other clause_relids. They are different in the case of a joinclause whose applicability has to be postponed due to outer join. We have to include the extra rels because otherwise, after best_inner_indexscan masks the join rels with index_outer_relids, it will always fail to find the joinclause as applicable. Per report from Husam Tomeh. Tom Lane 2005-09-22 23:25:07 +00:00
  • 8a64ec6285 Add "basic" for table partitioning. Bruce Momjian 2005-09-22 23:24:58 +00:00
  • 9516724bd7 Update FAQ's in 8.0.X branch. Bruce Momjian 2005-09-22 22:14:11 +00:00
  • a5b9e18acc Add instructions. Bruce Momjian 2005-09-22 21:59:50 +00:00
  • 5d075bb4cc Add "codelines" script to compute number of lines in a releaes. Bruce Momjian 2005-09-22 21:58:58 +00:00
  • c37ddf371d Add: Bruce Momjian 2005-09-22 21:50:59 +00:00
  • b3364fc81b pgindent new GIST index code, per request from Tom. Bruce Momjian 2005-09-22 20:44:36 +00:00
  • 08817bdb76 Adjust GiST error messages to conform to message style guidelines. Tom Lane 2005-09-22 18:49:45 +00:00
  • a453951dd9 Take exclusive buffer lock in scan_heap() to eliminate some corner cases in which invalid page data could be transiently written to disk by concurrent bgwriter activity. There doesn't seem any risk of loss of actual user data, but an empty page could possibly be left corrupt if a crash occurs before the correct data gets written out. Pointed out by Alvaro Herrera. Tom Lane 2005-09-22 17:32:58 +00:00
  • 4f915cd377 This patch cleans up the access to members of ItemIdData. It uses existing macros instead of touching directly. Bruce Momjian 2005-09-22 16:46:00 +00:00
  • 62da04f8e3 Add: Bruce Momjian 2005-09-22 16:01:59 +00:00
  • d7a06c2ac8 Fix psql \x by removing puts(). Bruce Momjian 2005-09-22 15:51:51 +00:00
  • a3b9c6988d Suppress port number for unix domain sockets in log connect/disconnect messages. Bruce Momjian 2005-09-22 15:33:36 +00:00
  • d7bb412e9c Remove some dead code. Tom Lane 2005-09-22 15:09:51 +00:00
  • 1128f55659 Fix postgresql.conf lexer to accept doubled single quotes in literal strings. This is consistent with SQL conventions, and since Bruce already changed initdb in a way that assumed it worked like this, seems we'd better make it work like this. Tom Lane 2005-09-21 20:33:34 +00:00
  • dbf952860e Suppress database dump item when --table and/or --schema switch was given, per gripe from Michael Fuhr. Tom Lane 2005-09-21 19:58:02 +00:00
  • bc9d4ec9a1 optimize_minmax_aggregates() neglected to check for inherited tables. Per report from Cesar Paipilla. Tom Lane 2005-09-21 19:15:27 +00:00
  • 99bb9c551e Fix interaction between psql \set AUTOCOMMIT and "ON_ERROR_ROLLBACK" by properly updating transaction state after AUTOCOMMIT. Bruce Momjian 2005-09-20 21:43:08 +00:00
  • 8d86982a11 Merge items: Bruce Momjian 2005-09-20 20:51:30 +00:00
  • b3af584d7d Return proper value for psql -f filename failure if filename open fails. Bruce Momjian 2005-09-20 18:59:15 +00:00
  • b7159824e6 Return proper value for psql -f filename failure if filename open fails. Bruce Momjian 2005-09-20 18:59:02 +00:00
  • 408c140266 autovacuum setting false -> off, for consistency Bruce Momjian 2005-09-20 02:38:35 +00:00
  • a34ec0ab4a Fix typo: Bruce Momjian 2005-09-20 02:21:29 +00:00
  • 7caaf8a022 Add: Bruce Momjian 2005-09-20 02:16:41 +00:00
  • 519d848eb5 Update profile file location. Bruce Momjian 2005-09-20 01:28:14 +00:00
  • 32f2cd3f35 Add: Bruce Momjian 2005-09-20 00:11:00 +00:00
  • 78b06948d0 Remove: Bruce Momjian 2005-09-19 22:32:32 +00:00
  • 658657177e Print proper cause of statement cancel, user interaction or timeout. Bruce Momjian 2005-09-19 17:21:49 +00:00
  • 591a29b398 update timestamp on file. Bruce Momjian 2005-09-19 15:01:28 +00:00
  • bfa47ddc20 Clarify some error messages Peter Eisentraut 2005-09-18 09:48:24 +00:00
  • b98f9898d1 Fix typo in link label, per Evgeny Gridasov. Tom Lane 2005-09-18 04:02:05 +00:00
  • 3743f07a53 Add: Bruce Momjian 2005-09-17 12:12:58 +00:00
  • e8960fc34f Add: Bruce Momjian 2005-09-16 19:39:25 +00:00
  • d5eab81313 Adjust regression for new cancel query message. Bruce Momjian 2005-09-16 19:39:02 +00:00
  • 098d204a6b Update query cancel message: Bruce Momjian 2005-09-16 19:31:04 +00:00
  • 1d734b79a3 Adjust bcc to work for thread changes. Bruce Momjian 2005-09-16 19:00:05 +00:00
  • eab3e9b80d This correction is required of nmake of Windows. Bruce Momjian 2005-09-16 18:58:48 +00:00
  • 892e525e24 Update numbering. Bruce Momjian 2005-09-16 18:07:35 +00:00
  • d64084daa5 Add: Bruce Momjian 2005-09-16 17:37:10 +00:00
  • cd85918090 tag it all beta2 ... REL8_1_0BETA2 PostgreSQL Daemon 2005-09-16 17:15:55 +00:00
  • 0296606f78 Update wording: Bruce Momjian 2005-09-16 16:46:09 +00:00
  • f4516f8732 Small fixes Teodor Sigaev 2005-09-16 14:40:54 +00:00
  • 3f558e3dae Add: Bruce Momjian 2005-09-16 11:24:02 +00:00
  • e4d9b69779 Rename pg_complete_relation_size() to pg_total_relation_size(), for the sake of brevity and clarity. Neil Conway 2005-09-16 05:35:41 +00:00
  • 148c00acbb Update two comments to refer to use the new list API names. Neil Conway 2005-09-16 04:13:18 +00:00
  • b09bfc654d Update release notes for changes between beta1 and beta2. Tom Lane 2005-09-16 03:37:35 +00:00
  • 3e579cf3c0 Add note about pg_autovacuum settings not being saved on a dump, per Robert Treat. Alvaro Herrera 2005-09-16 03:12:32 +00:00
  • dc06734a72 Force the size and alignment of LWLock array entries to be either 16 or 32 bytes. This shouldn't make any difference on x86 machines, where the size happened to be 16 bytes anyway, but on 64-bit machines and machines with slock_t int or wider, it will speed array indexing and hopefully reduce SMP cache contention effects. Per recent experimentation. Tom Lane 2005-09-16 00:30:05 +00:00
  • 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