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

Commit Graph

  • 0b2adc1e5f Add: Bruce Momjian 2005-03-23 02:41:29 +00:00
  • 09c165e41e Remove: < o Update to use the newer COPY syntax Bruce Momjian 2005-03-23 02:21:01 +00:00
  • ee10720834 Add for pg_dump: Bruce Momjian 2005-03-23 02:14:11 +00:00
  • aab0159cfb Add: Bruce Momjian 2005-03-23 01:25:07 +00:00
  • 4201ba2459 Remove: Bruce Momjian 2005-03-23 00:36:14 +00:00
  • 5869e883ee WAL must log CREATE and DROP DATABASE operations *without* using any explicit paths, so that the log can be replayed in a data directory with a different absolute path than the original had. To avoid forcing initdb in the 8.0 branch, continue to accept the old WAL log record types; they will never again be generated however, and the code can be dropped after the next forced initdb. Per report from Oleg Bartunov. We still need to think about what it really means to WAL-log CREATE TABLESPACE commands: we more or less have to put the absolute path into those, but how to replay in a different context?? Tom Lane 2005-03-23 00:04:25 +00:00
  • cad86e253b WAL must log CREATE and DROP DATABASE operations *without* using any explicit paths, so that the log can be replayed in a data directory with a different absolute path than the original had. To avoid forcing initdb in the 8.0 branch, continue to accept the old WAL log record types; they will never again be generated however, and the code can be dropped after the next forced initdb. Per report from Oleg Bartunov. We still need to think about what it really means to WAL-log CREATE TABLESPACE commands: we more or less have to put the absolute path into those, but how to replay in a different context?? Tom Lane 2005-03-23 00:03:37 +00:00
  • bd9b4a9d46 Use InitFunctionCallInfoData() macro instead of MemSet in performance critical places in execQual. By Atsushi Ogawa; some minor cleanup by moi. Tom Lane 2005-03-22 20:13:09 +00:00
  • 94e03330cb Create a routine PageIndexMultiDelete() that replaces a loop around PageIndexTupleDelete() with a single pass of compactification --- logic mostly lifted from PageRepairFragmentation. I noticed while profiling that a VACUUM that's cleaning up a whole lot of deleted tuples would spend as much as a third of its CPU time in PageIndexTupleDelete; not too surprising considering the loop method was roughly O(N^2) in the number of tuples involved. Tom Lane 2005-03-22 06:17:03 +00:00
  • 1cef5beeea Fix quote_ident to use quote_identifier rather than its own, not quite up-to-speed logic; in particular this will cause it to quote names that match keywords. Remove unnecessary multibyte cruft from quote_literal (all backend-internal encodings are 8-bit-safe). Tom Lane 2005-03-21 16:29:31 +00:00
  • 775d28302c Fix quote_ident to use quote_identifier rather than its own, not quite up-to-speed logic; in particular this will cause it to quote names that match keywords. Remove unnecessary multibyte cruft from quote_literal (all backend-internal encodings are 8-bit-safe). Tom Lane 2005-03-21 16:29:20 +00:00
  • 6a8eb1a7b6 pgcrypto update: Neil Conway 2005-03-21 05:24:52 +00:00
  • 19b676869a pgcrypto update: Neil Conway 2005-03-21 05:22:14 +00:00
  • 1ea9169b42 pgcrypto update: Neil Conway 2005-03-21 05:21:04 +00:00
  • b160d6b9dc pgcrypto update: Neil Conway 2005-03-21 05:19:55 +00:00
  • fa332a06ec * construct "struct {} list [] = {}" confuses pgindent - split those. It was a bad style to begin with, and now several loops can be clearer. * pgcrypto.c: Fix function comments * crypt-gensalt.c, crypt-blowfish.c: stop messing with errno * openssl.c: use px_free instead pfree * px.h: make redefining px_alloc/px_realloc/px_free easier Neil Conway 2005-03-21 05:18:46 +00:00
  • 3cc8661232 Remove support for libmhash/libmcrypt. Neil Conway 2005-03-21 05:17:16 +00:00
  • ee4ddac137 Convert index-related tuple handling routines from char 'n'/' ' to bool convention for isnull flags. Also, remove the useless InsertIndexResult return struct from index AM aminsert calls --- there is no reason for the caller to know where in the index the tuple was inserted, and we were wasting a palloc cycle per insert to deliver this uninteresting value (plus nontrivial complexity in some AMs). I forced initdb because of the change in the signature of the aminsert routines, even though nothing really looks at those pg_proc entries... Tom Lane 2005-03-21 01:24:04 +00:00
  • fe7015f5e8 Change the return value of HeapTupleSatisfiesUpdate() to be an enum, rather than an integer, and fix the associated fallout. From Alvaro Herrera. Neil Conway 2005-03-20 23:40:34 +00:00
  • 9e0dd84596 On Windows, use QueryPerformanceCounter instead of gettimeofday for EXPLAIN ANALYZE instrumentation. Magnus Hagander Tom Lane 2005-03-20 22:27:52 +00:00
  • 354049c709 Remove unnecessary calls of FlushRelationBuffers: there is no need to write out data that we are about to tell the filesystem to drop. smgr_internal_unlink already had a DropRelFileNodeBuffers call to get rid of dead buffers without a write after it's no longer possible to roll back the deleting transaction. Adding a similar call in smgrtruncate simplifies callers and makes the overall division of labor clearer. This patch removes the former behavior that VACUUM would write all dirty buffers of a relation unconditionally. Tom Lane 2005-03-20 22:00:54 +00:00
  • 683f60da3d Add mention of why malloc() has to be used in snprintf.c. Bruce Momjian 2005-03-20 13:54:53 +00:00
  • 8c72526fe9 Department of second thoughts. Remove FRONTEND from snprintf.c because snprintf is called before the memory system is started. We have to just malloc/free. There are no elogs in the code so we should be fine. Bruce Momjian 2005-03-20 03:53:39 +00:00
  • 169adfcf74 Fix typo in Makefile. Bruce Momjian 2005-03-20 02:44:45 +00:00
  • 83ebbfac75 Another change for FRONTEND snprintf.c. Bruce Momjian 2005-03-20 02:40:28 +00:00
  • 614fcbeba7 Mark snprintf.c as a file that uses FRONTEND and needs to a version in the server-side port library. Somehow I missed that change when I added memory allocation to snprintf.c. Bruce Momjian 2005-03-20 02:39:33 +00:00
  • 1c14db5a77 Done: > * -Allow the size of the buffer cache used by temporary objects to be Bruce Momjian 2005-03-20 01:57:11 +00:00
  • 91728fa26c Add temp_buffers GUC variable to allow users to determine the size of the local buffer arena for temporary table access. Tom Lane 2005-03-19 23:27:11 +00:00
  • d65522aeb6 Upgrade localbuf.c to use a hash table instead of linear search to find already-allocated local buffers. This is the last obstacle in the way of setting NLocBuffer to something reasonably large. Tom Lane 2005-03-19 17:39:43 +00:00
  • 8ae13aac52 Put 'dump complete' message in the right place, so it comes out where it's supposed to when --file option is used. Tom Lane 2005-03-18 17:33:03 +00:00
  • 2e629080f7 Put 'dump complete' message in the right place, so it comes out where it's supposed to when --file option is used. Tom Lane 2005-03-18 17:32:55 +00:00
  • 817bc021b7 Need to reset local buffer pin counts, not only shared buffer pins, before we attempt any file deletions in ShutdownPostgres. Per Tatsuo. Tom Lane 2005-03-18 16:16:20 +00:00
  • 88164799ce Need to reset local buffer pin counts, not only shared buffer pins, before we attempt any file deletions in ShutdownPostgres. Per Tatsuo. Tom Lane 2005-03-18 16:16:09 +00:00
  • fc80f5fe73 Added patch by Christof Petig <christof@petig-baender.de> to work around gcc bug on powerpc and amd64. Michael Meskes 2005-03-18 10:01:14 +00:00
  • 1f418555cf Added patch by Christof Petig <christof@petig-baender.de> to work around gcc bug on powerpc and amd64. Michael Meskes 2005-03-18 10:00:43 +00:00
  • cef01c3355 Avoid infinite loop in InvalidateBuffer if we ourselves are holding a pin on the victim buffer. Tom Lane 2005-03-18 05:25:23 +00:00
  • b03072571e Need to release buffer pins before attempting to drop files during backend exit. Per report from Bruce. Tom Lane 2005-03-18 05:24:24 +00:00
  • afb66ad8dd Need to release buffer pins before attempting to drop files during backend exit. Per report from Bruce. Tom Lane 2005-03-18 05:24:13 +00:00
  • bcfe5088e5 Treat EPERM as a non-error case when checking to see if old postmaster is still alive. This improves our odds of not getting fooled by an unrelated process when checking a stale lock file. Other checks already in place, plus one newly added in checkDataDir(), ensure that we cannot attempt to usurp the place of a postmaster belonging to a different userid, so there is no need to error out. Add comments indicating the importance of these other checks. Tom Lane 2005-03-18 03:49:19 +00:00
  • 7a969cad2e Treat EPERM as a non-error case when checking to see if old postmaster is still alive. This improves our odds of not getting fooled by an unrelated process when checking a stale lock file. Other checks already in place, plus one newly added in checkDataDir(), ensure that we cannot attempt to usurp the place of a postmaster belonging to a different userid, so there is no need to error out. Add comments indicating the importance of these other checks. Tom Lane 2005-03-18 03:48:49 +00:00
  • d344505d1b This patch moves some code for preprocessing FOR UPDATE from grouping_planner() to preprocess_targetlist(), according to a comment in grouping_planner(). I think the refactoring makes sense, and moves some extraneous details out of grouping_planner(). Neil Conway 2005-03-17 23:45:09 +00:00
  • 5955ebe334 Add link to INSERT in docs. Bruce Momjian 2005-03-17 20:24:34 +00:00
  • 7911e3a081 Backpatch to 8.0.X, already in HEAD: Bruce Momjian 2005-03-17 17:28:59 +00:00
  • 28d150d8e9 Update file system snapshot docs. Bruce Momjian 2005-03-17 15:38:46 +00:00
  • 57fdb2b0d8 Update obsolete comment. Tom Lane 2005-03-17 15:25:51 +00:00
  • 72cbc5982d Trivial comment tweak. Neil Conway 2005-03-17 05:47:01 +00:00
  • 118bf5bc22 Mention tablespaces as a problem for using file system snapshots. Bruce Momjian 2005-03-17 05:10:11 +00:00
  • ca2d08579e Document use of rsync for file system backups. Bruce Momjian 2005-03-17 05:03:37 +00:00
  • 82c46e5a70 Add mention of compatibility problem with turning off backslash escapes: Bruce Momjian 2005-03-17 04:42:15 +00:00
  • 7111a14fba Factor duplicate snprintf code into functions. Bruce Momjian 2005-03-17 03:18:14 +00:00
  • 957f51ea6b Add a reference to the documentation on alternate index operator classes in the locale docs. Patch from Chris KL, editorialization by Neil Conway. Neil Conway 2005-03-17 00:22:24 +00:00
  • d663d3ba3a This patch makes \d on tables and views sort fk constraints, triggers and rules alphabetically in the output. This makes it the same as for indexes and stops the irritating random or reverse ordering it currently has. Neil Conway 2005-03-16 23:52:18 +00:00
  • f402125926 Force initdb cause of encoding additions. Bruce Momjian 2005-03-16 22:59:42 +00:00
  • f97aebd162 Revise TupleTableSlot code to avoid unnecessary construction and disassembly of tuples when passing data up through multiple plan nodes. A slot can now hold either a normal "physical" HeapTuple, or a "virtual" tuple consisting of Datum/isnull arrays. Upper plan levels can usually just copy the Datum arrays, avoiding heap_formtuple() and possible subsequent nocachegetattr() calls to extract the data again. This work extends Atsushi Ogawa's earlier patch, which provided the key idea of adding Datum arrays to TupleTableSlots. (I believe however that something like this was foreseen way back in Berkeley days --- see the old comment on ExecProject.) A test case involving many levels of join of fairly wide tables (about 80 columns altogether) showed about 3x overall speedup, though simple queries will probably not be helped very much. Tom Lane 2005-03-16 21:38:10 +00:00
  • 712f053587 Add sprintf support, that were were missing. Bruce Momjian 2005-03-16 21:27:23 +00:00
  • ca66797308 pgindent snprintf.c for consistency. Bruce Momjian 2005-03-16 15:12:18 +00:00
  • 2306f63dea Fix snprintf for %*$. Bruce Momjian 2005-03-16 15:11:43 +00:00
  • fb7d212fbe Add CVS \r\n regression tests. Bruce Momjian 2005-03-16 06:05:53 +00:00
  • 888271ed15 Fix snprintf to handle %$ properly by storing and reordering the arguments. Bruce Momjian 2005-03-16 06:00:58 +00:00
  • 89ea098714 Add missing include for new lc_ctype_is_c() function. Bruce Momjian 2005-03-16 01:49:20 +00:00
  • 83e87e6f2e Add missing include for new lc_ctype_is_c() function. Bruce Momjian 2005-03-16 01:49:10 +00:00
  • fb2c2d83e0 Prevent locale-aware handling of upper, lower, and initcap when the locale is C. Bruce Momjian 2005-03-16 00:03:02 +00:00
  • 494f30c953 Prevent locale-aware handling of upper, lower, and initcap when the locale is C. Bruce Momjian 2005-03-16 00:02:49 +00:00
  • 963ffe4cc4 Wrap the implementation of fork_process() inside #ifndef WIN32 -- this should hopefully unbreak the Win32 build. Apologies for breaking it in the first place. Neil Conway 2005-03-16 00:02:39 +00:00
  • 86ad33cd48 Update to 8.0.1. Bruce Momjian 2005-03-15 22:38:23 +00:00
  • 05be5cc4e0 Add: Bruce Momjian 2005-03-15 05:31:27 +00:00
  • d5bc23878a Update Win32 item: Bruce Momjian 2005-03-15 04:01:21 +00:00
  • 17c8276d24 Clean up win1252 documentation. Mention how we determine the number of bytes/character for each encoding. Bruce Momjian 2005-03-15 02:30:33 +00:00
  • 2c4dea126a Issue free space notices to both the user and the server log file. Bruce Momjian 2005-03-14 20:15:09 +00:00
  • 28bcc344b5 Make pg_dump emit a useful error message, instead of just dumping core, if it finds a pg_rewrite entry for which there is no pg_class entry. Per report from Andrew Slobodyanyk. Tom Lane 2005-03-14 18:57:33 +00:00
  • e7fb9f18bf Add support for Win1252 encoding. Bruce Momjian 2005-03-14 18:31:25 +00:00
  • 2b0bb797ec Bump minor version numbers for 8.1 compared to 8.0. Bruce Momjian 2005-03-14 17:27:50 +00:00
  • 2ed560c99f Completed: Bruce Momjian 2005-03-14 16:37:02 +00:00
  • 9abced035d Fix mistakes in SGML markup. From David Fetter. Neil Conway 2005-03-14 06:49:48 +00:00
  • 251d3f75d0 Note that the -F and -R command line options only affect unaligned output mode. This was already stated in other places in the psql reference page, but not here. Tom Lane 2005-03-14 06:19:01 +00:00
  • a9b05bdc83 Avoid O(N^2) overhead in repeated nocachegetattr calls when columns of a tuple are being accessed via ExecEvalVar and the attcacheoff shortcut isn't usable (due to nulls and/or varlena columns). To do this, cache Datums extracted from a tuple in the associated TupleTableSlot. Also some code cleanup in and around the TupleTable handling. Atsushi Ogawa with some kibitzing by Tom Lane. Tom Lane 2005-03-14 04:41:13 +00:00
  • d1022ce3a1 Document client-only encodings. Bruce Momjian 2005-03-14 03:59:22 +00:00
  • 4973296035 Fix typo on URL. Bruce Momjian 2005-03-14 03:07:25 +00:00
  • c1186dd594 Add user: Bruce Momjian 2005-03-14 03:00:26 +00:00
  • a03bb609b3 Finalize character set documentation changes. Bruce Momjian 2005-03-14 02:14:42 +00:00
  • c069655441 Allow ALTER FUNCTION to change a function's strictness, volatility, and whether or not it is a security definer. Changing a function's strictness is required by SQL2003, and the other capabilities make sense. Also, allow an optional RESTRICT noise word to be specified, for SQL conformance. Neil Conway 2005-03-14 00:19:37 +00:00
  • 41e2a80f57 Update comments for new encoding names. Bruce Momjian 2005-03-14 00:19:13 +00:00
  • 826f14f6d3 Some builds (depends on crypto engine support?) of OpenSSL 0.9.7x have EVP_DigestFinal function which which clears all of EVP_MD_CTX. This makes pgcrypto crash in functions which re-use one digest context several times: hmac() and crypt() with md5 algorithm. Neil Conway 2005-03-13 23:46:27 +00:00
  • acb42e9cb9 Some builds (depends on crypto engine support?) of OpenSSL 0.9.7x have EVP_DigestFinal function which which clears all of EVP_MD_CTX. This makes pgcrypto crash in functions which re-use one digest context several times: hmac() and crypt() with md5 algorithm. Neil Conway 2005-03-13 23:45:56 +00:00
  • 5e72d01d20 Update contrib/pgcrypto in 7.3 and 7.2 branches to avoid problems with recent versions of OpenSSL. From Marko Kreen. Neil Conway 2005-03-13 23:42:07 +00:00
  • 638eb4938c Update contrib/pgcrypto in 7.3 and 7.2 branches to avoid problems with recent versions of OpenSSL. From Marko Kreen. Neil Conway 2005-03-13 23:41:44 +00:00
  • bb4c88c29a Add missing identification comment, remove entirely inappropriate include of postgres.h. Tom Lane 2005-03-13 23:32:26 +00:00
  • db5ea2c5cb Add some missing #includes. Tom Lane 2005-03-13 23:27:38 +00:00
  • f38cb720d9 Increment all major version numbers in 8.0.X to force recompile of client aplications so 7.4.X releases can be installed on the same machine as 8.0.X. Bruce Momjian 2005-03-13 22:04:45 +00:00
  • cbc100af66 Increment all major version numbers in 8.0.X to force recompile of client aplications so 7.4.X releases can be installed on the same machine as 8.0.X. Bruce Momjian 2005-03-13 22:04:29 +00:00
  • dffbbb3e55 Forgot that I had intended to replace division by masking in hash calculation. Tom Lane 2005-03-13 19:59:40 +00:00
  • 8264cbcb50 Remove CENTER tag. Bruce Momjian 2005-03-13 19:27:53 +00:00
  • ff02d0a052 Make default_with_oids default to false -- user-created tables will now no longer include OIDs, unless WITH OIDS is specified or the default_with_oids configuration parameter is enabled. Update the docs accordingly. Neil Conway 2005-03-13 09:36:31 +00:00
  • 0edc2f14e0 More ordering adjustments. Bruce Momjian 2005-03-13 05:31:04 +00:00
  • 9423383748 Update obsolete comment. Neil Conway 2005-03-13 05:19:26 +00:00
  • c151e6374c Fix markup. Bruce Momjian 2005-03-13 05:16:33 +00:00
  • 119807e397 More markup changes. Bruce Momjian 2005-03-13 05:11:49 +00:00
  • 1c0aeec65b More cleanups. Bruce Momjian 2005-03-13 04:35:06 +00:00
  • cbe4b4163e More improvements. Bruce Momjian 2005-03-13 04:10:23 +00:00
  • a717ab6fa6 More additions to the table. Bruce Momjian 2005-03-13 03:44:51 +00:00