Commit Graph

  • d4d5fdabbb Update docs for Borland CC build. Bruce Momjian 2004-09-27 19:43:17 +00:00
  • 32b24bfa97 Remove inclusion of windows.h now that it is included in c.h, per idea from Peter. Bruce Momjian 2004-09-27 19:16:03 +00:00
  • 7ceec70fc7 Add: Bruce Momjian 2004-09-27 14:17:51 +00:00
  • 08e9f6974c Remove completed items: Bruce Momjian 2004-09-27 14:15:49 +00:00
  • d56b9fdaa8 Synced parser. Removed Oracle transaction syntax to fix shift/reduce error. Michael Meskes 2004-09-27 09:59:17 +00:00
  • ae9df0b22b Addition to documentation about cvsup. From Andrew Dunstan, minor SGML tweak by Neil Conway. Neil Conway 2004-09-27 05:54:58 +00:00
  • cb7fc63d3e Remove references to the ODBC driver from the main source tree. From Kris Jurka. Neil Conway 2004-09-27 04:18:28 +00:00
  • 64a60590ba A few minor list-related cleanups: Neil Conway 2004-09-27 04:12:03 +00:00
  • 0ed07d49d5 Code cleanup: don't bother casting the argument to pfree() to void * from another pointer type. Per C89, this is unnecessary, and it is common practice throughout the rest of the tree anyway. Neil Conway 2004-09-27 04:01:23 +00:00
  • 93371ed3a5 update for beta3, and update Copyright date to 2004 REL8_0_0BETA3 PostgreSQL Daemon 2004-09-27 02:17:14 +00:00
  • ae8f7313ab Rewrite ReadArrayStr() to avoid O(N^2) behavior on large strings, and hopefully improve code clarity while at it. One intentional semantics change: a backslashed space will not be treated as removable trailing whitespace, as the prior coding would do. ISTM that if it wouldn't be considered removable leading whitespace, it shouldn't be stripped at the end either. Tom Lane 2004-09-27 01:39:02 +00:00
  • 5a2c8cf4b1 Fix misstatement in docs: CREATE TABLE AS is now part of the standard. Neil Conway 2004-09-26 23:48:07 +00:00
  • 7ac258c2f3 Fix multiple breakages in our support for SSL certificates. Tom Lane 2004-09-26 22:51:49 +00:00
  • 9236c79c8e Use ULL not LL in UINT64CONST. Tom Lane 2004-09-26 15:13:42 +00:00
  • 786f3d147d Here is a patch that adds the version info from libpq.rc to the DLL build in mingw. The MSVC build already did this, but it was not linked into the mingw one. Bruce Momjian 2004-09-26 02:14:47 +00:00
  • e9ec10494e Use <> not "" for include of pthread.h. Bruce Momjian 2004-09-26 01:40:55 +00:00
  • 6e7dd37384 Refresh for recent changes. Bruce Momjian 2004-09-26 01:33:55 +00:00
  • c86cc37f62 Repair bug that would allow libpq to think a command had succeeded when it really hadn't, due to double output of previous command's response. Fix prevents recursive entry to libpq routines. Found by Jan Wieck. Tom Lane 2004-09-26 00:26:56 +00:00
  • 09a893117a Repair bug that would allow libpq to think a command had succeeded when it really hadn't, due to double output of previous command's response. Fix prevents recursive entry to libpq routines. Found by Jan Wieck. Tom Lane 2004-09-26 00:26:28 +00:00
  • 26b5d5317b Persuade plpython to build on OS X. Tom Lane 2004-09-24 20:08:42 +00:00
  • b120485f9c GUC assign hooks that look at external state in deciding whether a setting is valid must ignore that state and permit the assignment anyway when source is PGC_S_OVERRIDE. Otherwise they may disallow a rollback at transaction abort, which is The Wrong Thing. Per example from Michael Fuhr 12-Sep-04. Tom Lane 2004-09-24 19:43:03 +00:00
  • 12a2121c75 Fix slightly misleading description of PERFORM syntax. Tom Lane 2004-09-24 18:54:14 +00:00
  • ae72283816 Cleanup some ancient Ultrix / Alpha code in main() that is intended to modify how unaligned memory accesses are dealt with. Document that this is really what is going on, and merge the NOFIXADE and NOPRINTADE code paths. Neil Conway 2004-09-24 06:29:07 +00:00
  • 3331180bb4 shmdt takes a void* parameter, per Kris Jurka. Tom Lane 2004-09-24 05:27:35 +00:00
  • 00b821a11b Fix gratuitous weirdness in function prototype, per Kris Jurka. Tom Lane 2004-09-24 05:16:35 +00:00
  • 2f132ebff7 Okay, I'm tired of reading gripes from OS X users ... add a regression variant file to cover OS X 10.3's bizarre minus-zero behavior. Tom Lane 2004-09-24 04:58:46 +00:00
  • 682598139e Get rid of /*-inside-comment warning. My fault. Tom Lane 2004-09-24 01:48:43 +00:00
  • be8eafa09d ExecProcAppend() wasn't called ExecAppend() because the latter name was formerly used in execMain. Since that is no longer the case, this patch renames ExecProcAppend() to ExecAppend() for the sake of consistency. Neil Conway 2004-09-24 01:36:37 +00:00
  • 1d1b8191ce Minor improvements to the release notes. Neil Conway 2004-09-24 01:31:32 +00:00
  • 409b38f514 Fix TAS assembly stuff for Solaris/386. (I'm not in a position to actually test this, but it couldn't be broken any worse than it was...) Tom Lane 2004-09-24 00:21:32 +00:00
  • ae169e84f7 Improve description of Execute message behavior, per Oliver Jowett. Tom Lane 2004-09-23 23:35:07 +00:00
  • 688f0c56dc Fix ALTER TABLE OWNER to adjust the ownership of dependent sequences, not only indexes. Alvaro Herrera, with some kibitzing by Tom Lane. Tom Lane 2004-09-23 23:20:24 +00:00
  • fb147dc30e If we're going to print unrecognized result codes from SSL_get_error in open_client_SSL, surely we should do it everywhere. Also make message formatting conform to style guide. Tom Lane 2004-09-23 20:27:50 +00:00
  • fa6fa8e549 This patch attempts to outline the supported level of SSL within libpq. I haven't mentioned any of ~/.postgresql/{root.crt,postgresql.crt,postresql.key} even though they are checked for in the code, since they do not appear to be supported. I base this on discussions in pgsql-hackers. Bruce Momjian 2004-09-23 13:31:09 +00:00
  • fb755b6dd4 This patch logs the error code in the default case, so that the user stands a chance of looking it up. "Unrecognised error" is always disheartening. :-) Bruce Momjian 2004-09-23 13:20:45 +00:00
  • 31ae87c332 This patch attempts to note the use of the root.crt file in the server. Given that PostgreSQL will output a message complaining about it's absence if you're using SSL mode, I feel it's important that it gets a mention in the documentation at some point. Bruce Momjian 2004-09-23 13:16:02 +00:00
  • 505d9be3e6 Update CREATE TABLE AS docs to reflect the fact that CREATE TABLE AS was added to the SQL:2003 standard. Neil Conway 2004-09-23 03:43:57 +00:00
  • 6a84723d7d Minor tweak to pg_controldata usage information, per suggestion from Dennis Björklund. Also, remove some redundant #include directives. Neil Conway 2004-09-23 00:47:44 +00:00
  • bca0383f9a Update installation docs for PL/Python to note that distutils is now required. Original patch from James William Pye, editorializing by Neil Conway. Neil Conway 2004-09-23 00:30:13 +00:00
  • 9fcbe2af11 Arrange for hash join to skip scanning the outer relation if it detects that the inner one is completely empty. Per recent discussion. Also some cosmetic cleanups in nearby code. Tom Lane 2004-09-22 19:13:52 +00:00
  • 5d9f5c20dd Issue a CHECKPOINT just after creating the regression database. Without this, it's hard to debug core-dump test failures, because WAL replay will enthusiastically remove the core file (along with the rest of the regression database directory). Per recent discussion, not to mention bitter experience. Tom Lane 2004-09-22 19:11:19 +00:00
  • bebaf70613 Adjust ExecMakeTableFunctionResult to produce a single all-nulls row when a function that returns a single tuple (not a setof tuple) returns NULL. This seems to be the most consistent behavior. It would have taken a bit less code to make it return an empty table (zero rows) but ISTM a non-SETOF function ought always return exactly one row. Per bug report from Ivan-Sun1. Tom Lane 2004-09-22 17:41:51 +00:00
  • b84788debc Minor cleanup of libpq/LO examples: fix some memory leaks, update a comment or two. Neil Conway 2004-09-22 05:12:45 +00:00
  • a94edb4c7b Some improvements for the tab-completion of psql. This should address all of the items in the todo list and adds some new things as well. Specifically: Neil Conway 2004-09-22 04:25:16 +00:00
  • a3c53c834f This patch from Alvaro Herrera adds transaction ID to the list of log_line_prefix escapes. The escape sequence used for this is %x. %x previously meant "postmaster et al. stop here" -- this has been renamed to %q. Neil Conway 2004-09-22 03:55:27 +00:00
  • 665d3736fb Clarify TODO item: we ought to implement updatable views per SQL99, not SQL92 (the former defines a much more ambitious subset of views that need to be updatable). Neil Conway 2004-09-21 05:38:54 +00:00
  • 95f20b96d4 Rotate on time boundaries that are sensible per local time rather than GMT. Also, avoid truncating the file we just wrote into, which might otherwise easily happen at DST boundaries. Ed L. and Tom Lane. Tom Lane 2004-09-21 00:21:25 +00:00
  • 6da0c439ee Change some of the existing plpgsql regression test cases so that they exercise dollar quoting and named function parameters. AFAICS we had no tests of either feature before. Tom Lane 2004-09-20 23:00:12 +00:00
  • 2f48836b1f Some editorializing on the docs for the dollar-quoting feature: fix grammar, don't drop discussions into the middle of unrelated discussions, etc. Tom Lane 2004-09-20 22:48:29 +00:00
  • 5b564e5307 Fix some shortcomings in psql's autocommit-off mode concerning detection of commands for which a transaction block should not be forced. Recognize VACUUM and other PreventTransactionChain commands; handle nested /* .. */ comments correctly; handle multibyte encodings correctly. Michael Paesold with some kibitzing from Tom Lane. Tom Lane 2004-09-20 18:51:19 +00:00
  • 9332d0baba Documentation improvements, per Josh Berkus. Tom Lane 2004-09-20 17:53:59 +00:00
  • fbbdfa413e Translation update Peter Eisentraut 2004-09-20 08:15:29 +00:00
  • 14946a80c0 Translation update Peter Eisentraut 2004-09-20 08:15:05 +00:00
  • f0183634d6 Translation update Peter Eisentraut 2004-09-20 08:07:15 +00:00
  • 398d4822a4 Translation updates Peter Eisentraut 2004-09-20 07:57:14 +00:00
  • cb2a8a9e00 Translation updates Peter Eisentraut 2004-09-20 07:49:54 +00:00
  • fa942e8010 Translation updates Peter Eisentraut 2004-09-20 07:44:42 +00:00
  • 768b647ead Now that I look, table 8-1 has some other marginal misstatements in it. If we're going to put brackets around optional precision specs in some entries, we'd better do it in all. Tom Lane 2004-09-20 04:19:50 +00:00
  • f6279e9ed7 Minor documentation cleanup and improvement. Neil Conway 2004-09-20 00:04:19 +00:00
  • fa8eb8a726 Add defenses against plpython functions being declared to take or return pseudotypes. Not sure why I neglected to add these checks at the same time I added them to the other PLs, but it seems I did. Tom Lane 2004-09-19 23:38:21 +00:00
  • 84c7cef5eb Fix estimate_num_groups to be able to use expression-index statistics when there is an expressional index matching a GROUP BY item. Tom Lane 2004-09-18 19:39:50 +00:00
  • 66343dde64 Put the brackets in the right places in timestamp entries in table 8-1. Spotted by Josh Purinton. Tom Lane 2004-09-18 15:28:16 +00:00
  • 089fb6c4ce Put the brackets in the right places in timestamp entries in table 8-1. Spotted by Josh Purinton. Tom Lane 2004-09-18 15:28:03 +00:00
  • 122016379d Move comment at end of line to a separate line so trailing tabs don't become part of the make variable value. Peter Eisentraut 2004-09-18 13:28:54 +00:00
  • f44a64901e Fix memory leak in tokenize_file, per report from Vadim Passynkov. Tom Lane 2004-09-18 01:23:12 +00:00
  • 4b9d84d450 Fix memory leak in tokenize_file, per report from Vadim Passynkov. Tom Lane 2004-09-18 01:22:58 +00:00
  • f6d278364e Improve documentation of log rotation options, per Ed L. Tom Lane 2004-09-17 22:40:46 +00:00
  • 915351e9c7 Add support for GNU/Hurd and GNU/*BSD. For our purposes, they behave just like Linux; we just need to recognize the system types. Peter Eisentraut 2004-09-17 22:31:59 +00:00
  • 24cfc14019 New config.guess and config.sub Peter Eisentraut 2004-09-17 22:09:21 +00:00
  • 152a101f2b Allow WIN1250 as server encoding. Peter Eisentraut 2004-09-17 21:59:57 +00:00
  • 0428840864 Here is a patch bringing oid2name into the 21st century. Tom Lane 2004-09-17 21:14:19 +00:00
  • f4d5c52a83 Hashed LEFT JOIN would miss outer tuples with no inner match if the join was large enough to be batched and the tuples fell into a batch where there were no inner tuples at all. Thanks to Xiaoyu Wang for finding a test case that exposed this long-standing bug. Tom Lane 2004-09-17 18:29:54 +00:00
  • 44ed69c8f3 Hashed LEFT JOIN would miss outer tuples with no inner match if the join was large enough to be batched and the tuples fell into a batch where there were no inner tuples at all. Thanks to Xiaoyu Wang for finding a test case that exposed this long-standing bug. Tom Lane 2004-09-17 18:29:40 +00:00
  • c57bcb7b2c Hashed LEFT JOIN would miss outer tuples with no inner match if the join was large enough to be batched and the tuples fell into a batch where there were no inner tuples at all. Thanks to Xiaoyu Wang for finding a test case that exposed this long-standing bug. Tom Lane 2004-09-17 18:29:24 +00:00
  • 50ff806700 Hashed LEFT JOIN would miss outer tuples with no inner match if the join was large enough to be batched and the tuples fell into a batch where there were no inner tuples at all. Thanks to Xiaoyu Wang for finding a test case that exposed this long-standing bug. Tom Lane 2004-09-17 18:29:10 +00:00
  • a5713ec427 Hashed LEFT JOIN would miss outer tuples with no inner match if the join was large enough to be batched and the tuples fell into a batch where there were no inner tuples at all. Thanks to Xiaoyu Wang for finding a test case that exposed this long-standing bug. Tom Lane 2004-09-17 18:28:53 +00:00
  • 054b78ba38 Now that xmax and cmin are distinct fields again, we should zero xmax when creating a new tuple. This is just for debugging sanity, though, since nothing should be paying any attention to xmax when the HEAP_XMAX_INVALID bit is set. Tom Lane 2004-09-17 18:09:55 +00:00
  • 12ce26f8da Hyperlink a reference to DROP CAST in the CREATE CAST reference page. Neil Conway 2004-09-17 02:06:33 +00:00
  • 04d15d120c Make discovery of python_configdir architecture independent. Solution from James William Pye. Joe Conway 2004-09-16 23:30:30 +00:00
  • 9f6df6c4a6 Fix oversight: there's no reason for PG_TRY to use sigsetjmp(buf,1) since we don't change the signal mask during normal backend operations. Use sigsetjmp(buf,0) to avoid many unnecessary kernel calls. Tom Lane 2004-09-16 21:59:17 +00:00
  • 914e177a3e Remove contrib/pg_logger, per recent discussion. Tom Lane 2004-09-16 21:20:20 +00:00
  • 1cfd2012a6 Remove erroneous Assert, per example from Kris Jurka. Tom Lane 2004-09-16 21:08:12 +00:00
  • 257cccbe5e Add some marginal tweaks to eliminate memory leakages associated with subtransactions. Trivial subxacts (such as a plpgsql exception block containing no database access) now demonstrably leak zero bytes. Tom Lane 2004-09-16 20:17:49 +00:00
  • 86fff990b2 RecentXmin is too recent to use as the cutoff point for accessing pg_subtrans --- what we need is the oldest xmin of any snapshot in use in the current top transaction. Introduce a new variable TransactionXmin to play this role. Fixes intermittent regression failure reported by Neil Conway. Tom Lane 2004-09-16 18:35:23 +00:00
  • 8f9f198603 Restructure subtransaction handling to reduce resource consumption, as per recent discussions. Invent SubTransactionIds that are managed like CommandIds (ie, counter is reset at start of each top transaction), and use these instead of TransactionIds to keep track of subtransaction status in those modules that need it. This means that a subtransaction does not need an XID unless it actually inserts/modifies rows in the database. Accordingly, don't assign it an XID nor take a lock on the XID until it tries to do that. This saves a lot of overhead for subtransactions that are only used for error recovery (eg plpgsql exceptions). Also, arrange to release a subtransaction's XID lock as soon as the subtransaction exits, in both the commit and abort cases. This avoids holding many unique locks after a long series of subtransactions. The price is some additional overhead in XactLockTableWait, but that seems acceptable. Finally, restructure the state machine in xact.c to have a more orthogonal set of states for subtransactions. Tom Lane 2004-09-16 16:58:44 +00:00
  • 42c0d1f3cd Minor doc tweak: mention that function names can be optionally schema- qualified. Neil Conway 2004-09-16 04:16:08 +00:00
  • 6a2869f64e Fix a read of uninitialized memory in array_out(). Perform some minor cosmetic code cleanup at the same time. Neil Conway 2004-09-16 03:15:54 +00:00
  • d1b0d965b1 Cosmetic PL/PgSQL fix: declare the second parameter plpgsql_dstring_append as a const char *, so that we don't need to cast away a const in gram.y Neil Conway 2004-09-14 23:46:46 +00:00
  • 1459d8c4b0 Mark as done: Bruce Momjian 2004-09-14 14:34:45 +00:00
  • cb66748bdf New translation Peter Eisentraut 2004-09-14 05:50:33 +00:00
  • e992444faa Translation update Peter Eisentraut 2004-09-14 05:44:40 +00:00
  • db64df4b1c Fix contrib/cube and contrib/seg to compile on Windows. Andreas Pflug Tom Lane 2004-09-14 04:21:38 +00:00
  • 92244e8e54 Fix some minor issues with the new Win32 service code for autovacuum, and add documentation. Dave Page Tom Lane 2004-09-14 04:06:20 +00:00
  • b04e70b11e Adjust tsearch2.sql to avoid use of COPY FROM STDIN, so as to simplify life for the Win32 installer. Per Dave Page. Tom Lane 2004-09-14 03:58:54 +00:00
  • 4f7d3e0faf Win32 compile fix for misc_utils. Claudio Natoli Tom Lane 2004-09-14 03:50:17 +00:00
  • bf06825e31 Win32 compile fixes for pgbench, pgcrypto, and tsearch. Claudio Natoli Tom Lane 2004-09-14 03:39:55 +00:00
  • fc564686a7 Fix contrib/dbase to compile under Win32. Laurent Ballester Tom Lane 2004-09-14 03:28:28 +00:00
  • 296fb57b20 Make pltcl work on Win32. Magnus Hagander Tom Lane 2004-09-14 03:21:27 +00:00
  • 65ff0ed455 Fix small memory leak in psql. Neil Conway 2004-09-13 23:07:12 +00:00
  • adf9a28bb8 Translation update Peter Eisentraut 2004-09-13 20:53:10 +00:00