Commit Graph

  • 74ffc77279 Code review for log_line_prefix patch. Cooperate with StringInfo instead of fighting it, avoid hard-wired (and wrong) assumption about max length of prefix, cause %l to actually work as documented, don't compute data we may not need. Tom Lane 2004-03-19 02:23:59 +00:00
  • 8726591720 Make test_fsync use optimizer flag. Bruce Momjian 2004-03-18 23:27:29 +00:00
  • cbaf1aaeba Fix log_executor_stats if() test. Bruce Momjian 2004-03-18 23:26:17 +00:00
  • 2ef0ff89af Add Unixware thread support from Larry Rosenman. Bruce Momjian 2004-03-18 23:23:58 +00:00
  • 6b34711824 Allocate 16mb file for testing. Bruce Momjian 2004-03-18 20:09:33 +00:00
  • 9e231bab65 Have program default to 1000 loops, and add file name and loop option. Bruce Momjian 2004-03-18 19:54:00 +00:00
  • 9ae9ad155d Add comment about using this testing for wal_sync_method. Bruce Momjian 2004-03-18 17:23:56 +00:00
  • b2906c5be3 Add fsync tests: Bruce Momjian 2004-03-18 15:26:27 +00:00
  • 5ddecd1e27 Mention which fsync methods are unavailable. Bruce Momjian 2004-03-18 14:02:58 +00:00
  • 69138a9429 Add permission mode to opens(). Bruce Momjian 2004-03-18 04:11:41 +00:00
  • bfaa9a0ada Add missing include Bruce Momjian 2004-03-18 04:04:36 +00:00
  • 00051c9b56 Remove acccidental object/binary files. Bruce Momjian 2004-03-18 03:57:58 +00:00
  • 9f2696f266 Add fsync test program. It tests fsync to see if times for fsync are the same when done on the write() ile descriptor and a new descriptor. Bruce Momjian 2004-03-18 03:56:59 +00:00
  • 3700335baf Done: Bruce Momjian 2004-03-17 22:30:10 +00:00
  • fbac1272b8 During btree index build, sort equal-keyed tuples according to their TID (heap position). This doesn't do anything to the validity of the finished index, but by pretending to qsort() that there are no really equal keys in the sort, we can avoid performance problems with qsort implementations that have trouble with large numbers of equal keys. Patch from Manfred Koizar. Tom Lane 2004-03-17 22:24:58 +00:00
  • 55f7c3300d Reimplement CASE val WHEN compval1 THEN ... WHEN compval2 THEN ... END so that the 'val' is computed only once, per recent discussion. The speedup is not much when 'val' is just a simple variable, but could be significant for larger expressions. More importantly this avoids issues with multiple evaluations of a volatile 'val', and it allows the CASE expression to be reverse-listed in its original form by ruleutils.c. Tom Lane 2004-03-17 20:48:43 +00:00
  • 8c702ea7ac Modify: Bruce Momjian 2004-03-17 17:40:44 +00:00
  • 774571fd08 Fix pg_autovacuum to handle unsigned and oids better. Bruce Momjian 2004-03-17 13:16:28 +00:00
  • d245b6bd9f Document SPI_push() and SPI_pop(). Bruce Momjian 2004-03-17 01:05:10 +00:00
  • c1352052ef Replace the switching function ExecEvalExpr() with a macro that jumps directly to the appropriate per-node execution function, using a function pointer stored by ExecInitExpr. This speeds things up by eliminating one level of function call. The function-pointer technique also enables further small improvements such as only making one-time tests once (and then changing the function pointer). Overall this seems to gain about 10% on evaluation of simple expressions, which isn't earthshaking but seems a worthwhile gain for a relatively small hack. Per recent discussion on pghackers. Tom Lane 2004-03-17 01:02:24 +00:00
  • 2c7e473434 Add: Bruce Momjian 2004-03-16 16:13:38 +00:00
  • 40f456ce56 Remove double-rename used by Win32 on busy files. Not needed anymore. Bruce Momjian 2004-03-16 05:05:58 +00:00
  • e2d8c1b2bb log_statement was not removed by the previous patch. It only updated its description. Bruce Momjian 2004-03-15 17:57:51 +00:00
  • 8526f537cc The "cvs add" of test_thread_implicit.pgc seems to have been missed, i've attached this again. Bruce Momjian 2004-03-15 16:27:43 +00:00
  • bda6e04ba0 Check for EOF on pipe differs under win32, as it is based on a socket implementation. Bruce Momjian 2004-03-15 16:21:37 +00:00
  • f744c0f760 float8-small-is-zero and float8-exp-three-digits will likely need similar changes. Bruce Momjian 2004-03-15 16:20:52 +00:00
  • 3947f653f9 * postmaster.c: cleanup pmdaemonize under win32; missed failure message in CreateOptsFile * s_lock.c: minor comment fix * findbe.c: variables not used under win32 moved within #ifndef WIN32 case Bruce Momjian 2004-03-15 16:18:43 +00:00
  • 7b6fba9d06 Handle OID's and unsigned values better in pg_autovacuum. Bruce Momjian 2004-03-15 16:17:30 +00:00
  • dea47eee06 Windows uses codepages rather than the environment, so we work around that by querying the environment explicitly first for LC_COLLATE and LC_CTYPE. We have to do this because initdb passes those values in the environment. If there is nothing there we fall back on the codepage. Bruce Momjian 2004-03-15 16:14:26 +00:00
  • 221c0adaa8 Update random regression test text to be clearer. Bruce Momjian 2004-03-15 16:11:42 +00:00
  • 48c9fbd35c Update random test description because it fails less frequently now. Bruce Momjian 2004-03-15 16:06:43 +00:00
  • d6b57925ca Remove GUC log_statement, log_pid, log_timestamp, log_source_port. Functionality superceeded by log_line_prefix. Bruce Momjian 2004-03-15 15:56:28 +00:00
  • 6812e95a28 Improve random regression tests to fail less frequently. Bruce Momjian 2004-03-15 15:46:25 +00:00
  • 98bb1d2085 Fix typo. Bruce Momjian 2004-03-15 14:21:30 +00:00
  • 10afaf472a Mention Linux syslog will sync lines to disk, and describe how to disable it. Bruce Momjian 2004-03-15 14:15:45 +00:00
  • e8c3205037 Add PQmbdsplen() which returns the "display length" of a character. Still some works needed: - UTF-8, MULE_INTERNAL always returns 1 Tatsuo Ishii 2004-03-15 10:41:26 +00:00
  • 1bc2d544b9 Localize our dependencies on the way to create NAN or INFINITY. Per recent proposal to pghackers. Tom Lane 2004-03-15 03:29:22 +00:00
  • 89ab5c4abf Remove grotty special-case code in coerce_to_target_type() that implemented casts to varchar and bpchar using a cast-to-text function. This is a holdover from before we had pg_cast; it now makes more sense to just list these casts in pg_cast. While at it, add pg_cast entries for the other direction (casts from varchar/bpchar) where feasible. Tom Lane 2004-03-15 01:13:41 +00:00
  • 9c99b3f51e Update Solaris thread flags, per Jim Seymour Bruce Momjian 2004-03-14 23:51:57 +00:00
  • 64fe1fd239 Update Solaris thread flags, per Jim Seymour Bruce Momjian 2004-03-14 23:51:48 +00:00
  • 04226b6404 Tweak planner so that index expressions and predicates are matched to queries without regard to whether coercions are stated explicitly or implicitly. Per suggestion from Stephan Szabo. Tom Lane 2004-03-14 23:41:27 +00:00
  • 0175b6d101 Fix error in termination of COPY IN mode when using V2 protocol. Report and fix per ljb, 8-Mar-04. Tom Lane 2004-03-14 22:01:01 +00:00
  • e1d08faf04 Fix error in termination of COPY IN mode when using V2 protocol. Report and fix per ljb, 8-Mar-04. Tom Lane 2004-03-14 22:00:54 +00:00
  • 6e7a0f3550 Mark linux as thread-enabled with new 7.5 tests. Bruce Momjian 2004-03-14 15:06:13 +00:00
  • 48f3ddf991 Fix ecpg_sqlca_key_destructor to return void. Bruce Momjian 2004-03-14 14:47:33 +00:00
  • 036457f35e > (I also see some post-7.4.1 changes in src/template/solaris, so you > possibly should look there too.) [snip] > Bruce Momjian 2004-03-14 14:01:54 +00:00
  • b76c536e2e > (I also see some post-7.4.1 changes in src/template/solaris, so you > possibly should look there too.) [snip] > Bruce Momjian 2004-03-14 14:01:43 +00:00
  • e6bc372174 Committed Informix compat bug fix to 7.4 as well. Michael Meskes 2004-03-14 12:18:35 +00:00
  • 757fb0e5a9 - Fixed Informix compat math functions to cope with the situations where one argument takes the result. - Applied thread patches by Lee Kindness Michael Meskes 2004-03-14 12:16:30 +00:00
  • 80ac9b06ac Portability fixes and bug fixes for recent floating point input changes. In particular, don't depend on strtod() to accept 'NaN' and 'Infinity' inputs (while this is required by C99, not all platforms are compliant with that yet). Also, don't require glibc's behavior from isinf(): it seems that on a lot of platforms isinf() does not itself distinguish between negative and positive infinity. Neil Conway 2004-03-14 05:22:52 +00:00
  • 7665d1bc16 Teach psql to show the location of syntax errors visually, per recent discussions. Patch by Fabien Coelho and Tom Lane. Still needs to be taught about multi-screen-column kanji characters; Tatsuo has promised to provide the needed infrastructure for that. Tom Lane 2004-03-14 04:25:18 +00:00
  • 181d4d410a Rename README's to match directory names. Mention copyright matches PostgreSQL's. Bruce Momjian 2004-03-14 03:19:13 +00:00
  • a8a3b54724 Arrange to emit a CONTEXT: SQL function "foo" entry in an error message that is reporting a prechecking error in a SQL function. This is to cue client-side code that the syntax error position, if any, is with respect to the function body and not the outer command. Tom Lane 2004-03-14 01:58:41 +00:00
  • afaf252cee Done: Bruce Momjian 2004-03-13 23:17:39 +00:00
  • b88fa3b196 Generate a WARNING when the column types in a foreign key constraint are incompatible enough to prevent indexscanning the referenced table. Also, improve the error message that pops out when we can't implement the FK at all for lack of a usable equality operator. Fabien Coelho, with some review by Tom Lane. Tom Lane 2004-03-13 22:09:14 +00:00
  • 695c241e5a Repair memory leakage introduced into the non-hashed aggregate case by 7.4 rewrite for hashed aggregate support. If the transition data type is pass-by-reference, the transValue must be pfreed when starting a new group boundary, else we have a one-value-per-group leakage. Thanks to Rae Steining for providing a reproducible test case. Tom Lane 2004-03-13 00:54:35 +00:00
  • 642cd0ab13 Repair memory leakage introduced into the non-hashed aggregate case by 7.4 rewrite for hashed aggregate support. If the transition data type is pass-by-reference, the transValue must be pfreed when starting a new group boundary, else we have a one-value-per-group leakage. Thanks to Rae Steining for providing a reproducible test case. Tom Lane 2004-03-13 00:54:10 +00:00
  • 58e351113f Translation updates Dennis Bjorklund 2004-03-12 18:32:51 +00:00
  • 73f3ab692d Fixes recent changes to test. For immediate application. Bruce Momjian 2004-03-12 14:08:05 +00:00
  • e3d6ee6c28 Update FAQ with current release version. Bruce Momjian 2004-03-12 13:51:57 +00:00
  • fab1a5950b Update Russian FAQ, Viktor Vislobokov Bruce Momjian 2004-03-12 13:51:33 +00:00
  • 27731fd2fa Translation updates Dennis Bjorklund 2004-03-12 12:59:09 +00:00
  • 9bcaa8e283 Translation updates Dennis Bjorklund 2004-03-12 12:38:36 +00:00
  • 1c89c51b9e Rename incorrect references to nonblock.c to noblock.c. Claudio. Bruce Momjian 2004-03-12 04:33:41 +00:00
  • be7976d5a2 Fix a typo in the documentation for geqo_effort. Neil Conway 2004-03-12 00:56:00 +00:00
  • fe9c4420e4 Improve documentation for the newly-added NOWAIT clause of LOCK TABLE. Neil Conway 2004-03-12 00:52:23 +00:00
  • bfd6f52b0e Allow 'Infinity' and '-Infinity' as input to the float4 and float8 types. Update the regression tests and the documentation to reflect this. Remove the UNSAFE_FLOATS #ifdef. Neil Conway 2004-03-12 00:25:43 +00:00
  • fe6e922136 Translation updates Dennis Bjorklund 2004-03-11 15:48:57 +00:00
  • 0f8c4bc4a2 Document the SSL and Kerberos are not thread-safe. Bruce Momjian 2004-03-11 02:39:10 +00:00
  • e2ded829f6 Revise int2/int4/int8/float4/float8 input routines to allow for any amount of leading or trailing whitespace (where "whitespace" is defined by isspace()). This is for SQL conformance, as well as consistency with other numeric types (e.g. oid, numeric). Neil Conway 2004-03-11 02:11:14 +00:00
  • 0b86ade1c2 Add NOWAIT option to LOCK command Tatsuo Ishii 2004-03-11 01:47:41 +00:00
  • 60a068b389 Move non-blocking code into its own /port file, for code clarity. Bruce Momjian 2004-03-10 21:12:49 +00:00
  • ae22a6c185 Fix a typo. Neil Conway 2004-03-10 20:10:26 +00:00
  • ef41d22e55 Improvements to README.CVS Neil Conway 2004-03-10 01:34:53 +00:00
  • c9d8901b3f Improvements to README.CVS Neil Conway 2004-03-10 01:31:15 +00:00
  • eb7ff67cea Remove HISTORY and INSTALL. Have them generated by the tarball scripts. Bruce Momjian 2004-03-10 00:28:27 +00:00
  • 0bcc2beb4a Remove HISTORY and INSTALL. Have them generated by the tarball scripts. Bruce Momjian 2004-03-10 00:28:11 +00:00
  • f28d5614ce Tweak some text to avoid using <command>SET</command> as a verb, per suggestion from Peter E. Neil Conway 2004-03-09 23:15:47 +00:00
  • df6b11db52 Add comment for Win32. Bruce Momjian 2004-03-09 22:40:10 +00:00
  • 68c4df98c5 Remove blank line in Makefile. Bruce Momjian 2004-03-09 20:10:19 +00:00
  • 832e6df893 Remove blank line in Makefile. Bruce Momjian 2004-03-09 20:10:10 +00:00
  • 86d7f1187a Add HISTORY/INSTALL clean target to 7.4.X. Bruce Momjian 2004-03-09 20:08:21 +00:00
  • 66cb7e2e99 Add HISTORY/INSTALL clean target to 7.4.X. Bruce Momjian 2004-03-09 20:08:10 +00:00
  • 3ab5aa02f8 Build scanner output when making a distribution. Peter Eisentraut 2004-03-09 19:47:05 +00:00
  • 47110ace3a Add documentation for the recent 'ALSO' patch for CREATE RULE. Along the way, fix a typo and make a few SGML cleanups. Neil Conway 2004-03-09 19:30:21 +00:00
  • 7ea8735e71 Rebuild HISTORY file to match our official style sheets. Bruce Momjian 2004-03-09 17:40:52 +00:00
  • f31a43f9ae Rebuild HISTORY file to match our official style sheets. Bruce Momjian 2004-03-09 17:40:27 +00:00
  • 80ec228389 Refer to GUC variables using <xref> tags rather than <varname> tags, where appropriate. Add "id" and "xreflabel" tags to the descriptions of the GUC variables to facilitate this. Also make a few minor docs cleanups. Neil Conway 2004-03-09 16:57:47 +00:00
  • 8567bb2d06 Corrects a typo, introduces missing variables, and rearranges the initialization of stats process under EXEC_BACKEND. Bruce Momjian 2004-03-09 05:11:53 +00:00
  • eeec31774a Determines the PKGLIBDIR equivalent under win32. Requires pgsql lib and bin directories to be packaged under the same root directory (eg. <some path>/pgsql/bin and <some path>/pgsql/lib) for the win32 port, which does not appear to be an onerous restriction. Bruce Momjian 2004-03-09 05:06:45 +00:00
  • 943eae92fb Add ALSO keyword to CREATE RULE. Bruce Momjian 2004-03-09 05:05:41 +00:00
  • 53cd7cd8a9 Make a separate win32 debug DLL along with the non-debug version: Bruce Momjian 2004-03-09 04:53:37 +00:00
  • f0f4e82f45 The win32 port backend will require the functionality provided by canonicalize_path. Patch moves it from initdb.c to port/path.c. Bruce Momjian 2004-03-09 04:49:02 +00:00
  • 96ef6682e3 Done: Bruce Momjian 2004-03-09 04:45:48 +00:00
  • 2d3fe86bc4 Add: Bruce Momjian 2004-03-09 04:43:07 +00:00
  • af96aa9ab1 I wanted to submit some changes to the bundled postgres startup script for Mac OS X. I added calls to utilize the bundled apache rotatelogs script in the DB startup for log rotation. Also modified startup parameters file to allow using the "SystemStarter" utility to start/stop/restart postgres with a rotating log file. Bruce Momjian 2004-03-09 01:59:13 +00:00
  • e0bed412a2 Have SGML make clean remove text files output as well Bruce Momjian 2004-03-08 23:59:23 +00:00
  • 4679e875c0 Add comment about why ON COMMENT in non-current database throws just an warning. Bruce Momjian 2004-03-08 21:35:59 +00:00
  • 8226ed2204 Update German FAQ. Bruce Momjian 2004-03-08 17:39:04 +00:00
  • fb5eb6ac87 Update German FAQ. Bruce Momjian 2004-03-08 17:38:31 +00:00