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

Commit Graph

  • 1de44349f4 Fix bug in GB18030 conversion script Tatsuo Ishii 2003-08-24 05:00:45 +00:00
  • 3d0d78ce2f Bring the makefiles up to our conventions. Peter Eisentraut 2003-08-23 04:25:29 +00:00
  • 4682776302 Enable uninstalling data files that were installed from a subdirectory of the source tree. Peter Eisentraut 2003-08-23 04:23:38 +00:00
  • 200b7d11af Fix uninstall target. Peter Eisentraut 2003-08-23 04:22:34 +00:00
  • 588970c399 Correct uninstall target. Peter Eisentraut 2003-08-23 04:21:59 +00:00
  • b0a0a80618 Sigh, I'm an idiot ... SSL_ERROR_WANT_READ isn't an error condition at all, it just means 'no data available yet'. Tom Lane 2003-08-22 21:57:44 +00:00
  • 29a43f398a Tweak grammar to use FastAppend rather than lappend when constructing expr_lists. This appears to be the only remaining O(N^2) bottleneck in processing many-way 'x IN (a,b,c,...)' conditions. Tom Lane 2003-08-22 20:34:33 +00:00
  • 92ee2528d8 Tweak processing of multiple-index-scan plans to reduce overhead when handling many-way scans: instead of re-evaluating all prior indexscan quals to see if a tuple has been fetched more than once, use a hash table indexed by tuple CTID. But fall back to the old way if the hash table grows to exceed SortMem. Tom Lane 2003-08-22 20:26:43 +00:00
  • 38e2bf6283 ISpell info updated Teodor Sigaev 2003-08-21 15:53:21 +00:00
  • ef38ca9b3d Translation updates Peter Eisentraut 2003-08-20 21:10:01 +00:00
  • 432fb5b886 Updates for array documentation, from Joe Conway. Tom Lane 2003-08-19 06:06:48 +00:00
  • 80860c32d9 Improve dynahash.c's API so that caller can specify the comparison function as well as the hash function (formerly the comparison function was hardwired as memcmp()). This makes it possible to eliminate the special-purpose hashtable management code in execGrouping.c in favor of using dynahash to manage tuple hashtables; which is a win because dynahash knows how to expand a hashtable when the original size estimate was too small, whereas the special-purpose code was too stupid to do that. (See recent gripe from Stephan Szabo about poor performance when hash table size estimate is way off.) Free side benefit: when using string_hash, the default comparison function is now strncmp() instead of memcmp(). This should eliminate some part of the overhead associated with larger NAMEDATALEN values. Tom Lane 2003-08-19 01:13:41 +00:00
  • 23e10843db When compiling a plpgsql trigger function, include the OID of the table the trigger is attached to in the hashkey. This ensures that we will create separate compiled trees for each table the trigger is used with, avoiding possible datatype-mismatch problems if the tables have different rowtypes. This is essentially the same bug recently identified in plpython --- though plpgsql doesn't seem as prone to crash when the rowtype changes underneath it. But failing robustly is no substitute for just working. Tom Lane 2003-08-18 19:16:02 +00:00
  • 141490354e Done: Bruce Momjian 2003-08-18 02:52:45 +00:00
  • e945246321 Fix ARRAY[] construct so that in multidimensional case, elements can be anything yielding an array of the proper kind, not only sub-ARRAY[] constructs; do subscript checking at runtime not parse time. Also, adjust array_cat to make array || array comply with the SQL99 spec. Tom Lane 2003-08-17 23:43:27 +00:00
  • de9c553f6b Clean up locktable init code per recent gripe from Kurt Roeckx. No change in behavior, but old code would have failed to detect overrun of MAX_LOCKMODES. Tom Lane 2003-08-17 22:41:12 +00:00
  • c771838106 Somebody forgot to include any actual documentation for ADD_MISSING_FROM. Tom Lane 2003-08-17 22:19:15 +00:00
  • 4215947986 Update documentation to reflect the fact that ORDER BY, GROUP BY, etc are now driven by the default btree opclass, rather than assuming that particular operator names have the needed semantics. Tom Lane 2003-08-17 22:09:00 +00:00
  • 1b68704482 Fix broken markup. Tom Lane 2003-08-17 22:05:13 +00:00
  • ec646dbc65 Create a 'type cache' that keeps track of the data needed for any particular datatype by array_eq and array_cmp; use this to solve problems with memory leaks in array indexing support. The parser's equality_oper and ordering_oper routines also use the cache. Change the operator search algorithms to look for appropriate btree or hash index opclasses, instead of assuming operators named '<' or '=' have the right semantics. (ORDER BY ASC/DESC now also look at opclasses, instead of assuming '<' and '>' are the right things.) Add several more index opclasses so that there is no regression in functionality for base datatypes. initdb forced due to catalog additions. Tom Lane 2003-08-17 19:58:06 +00:00
  • d89578ccbe Add to release notes. Bruce Momjian 2003-08-17 05:24:52 +00:00
  • 42588d436d Add: Bruce Momjian 2003-08-17 05:23:13 +00:00
  • a9f9a97906 I almost forgot mark in docs "to_char(interval)" as deprecated function. This useless routine will removed in 7.5. It's already discussed (see hackers list archive). Bruce Momjian 2003-08-17 04:52:41 +00:00
  • 7f5079db98 Add: Bruce Momjian 2003-08-17 04:50:57 +00:00
  • 41477b9a83 This patch makes two minor fixes to the docs: (1) fixes a spelling mistake in the PREPARE ref page (2) Makes some English more consistent, in the ref pages for some of the client apps (3) Adds a link to the libpq docs in the vacuumdb ref page. Bruce Momjian 2003-08-17 04:46:59 +00:00
  • e7f266e5fe There is a misstatement in the CLOSE reference page, now that we have cursors that might outlive their creating transactions. A patch is attached that fixes this (suggestions on better wording are welcome). Bruce Momjian 2003-08-17 04:46:00 +00:00
  • b433f405c5 Add: Bruce Momjian 2003-08-17 04:43:48 +00:00
  • 2326ade600 I just noticed that the sample pg_hba.conf in the docs doesn't contain any use of CIDR masks - here's a patch that adds a couple of sample lines and associated comments. Bruce Momjian 2003-08-17 04:39:11 +00:00
  • f7d9aa8fbf The attached patch adds some clarification to the documentation of the binary format read/created by COPY BINARY. It also mentions the contrib/binarycopy module. Bruce Momjian 2003-08-17 04:33:02 +00:00
  • 6499ebb72b Add: Bruce Momjian 2003-08-17 04:28:15 +00:00
  • 237b4d6845 Add: Bruce Momjian 2003-08-17 04:18:01 +00:00
  • 01d0d34694 Add: Bruce Momjian 2003-08-17 03:56:16 +00:00
  • d4be99f63d (I always forget what the magic numbers 0 through 2 means for the "syslog" option.) Bruce Momjian 2003-08-17 03:17:22 +00:00
  • 3297804e14 Add mention of sort_mem in the restore docs. Bruce Momjian 2003-08-17 03:14:26 +00:00
  • bb8586d19d Update for 7.3 tips URL. Bruce Momjian 2003-08-17 00:41:46 +00:00
  • b770dc954e Add to libpq changes made by Tom for new protocol. Bruce Momjian 2003-08-17 00:20:21 +00:00
  • 4369432405 Not needed, already in CVS. Bruce Momjian 2003-08-17 00:14:13 +00:00
  • bfeabcc84f Add description of error style. Bruce Momjian 2003-08-16 23:53:54 +00:00
  • 226bae27b9 Add mention that Kerberos 4 isn't recommended. Bruce Momjian 2003-08-16 23:33:49 +00:00
  • edc999b09a Make NEED_REENTRANT_FUNC_NAMES _require_ *_r functions, and add tests to configure to report if they are not found. Bruce Momjian 2003-08-16 15:35:51 +00:00
  • dcfa89537a Updated the blob regression test to actually use the getBlob/getClob methods and test them, in addition to testing the underlying LargeObject API methods. Barry Lind 2003-08-15 18:45:11 +00:00
  • 5cad6813fb Fixed improper message length for the connection termination message 'X' when using the V3 protocol. Barry Lind 2003-08-15 18:36:58 +00:00
  • d3fe721a40 Eliminate function start_parse_fh and macro YY_INPUT Teodor Sigaev 2003-08-15 13:44:35 +00:00
  • 432ca9116b Rewrite array_cmp to not depend on deconstruct_array. Should be a little faster, but more importantly does not leak memory. Still needs more work though, per my recent note to pgsql-hackers. Tom Lane 2003-08-15 00:22:26 +00:00
  • 43bb02863f Add disk rotation idea to WAL todo emails. Bruce Momjian 2003-08-14 23:13:42 +00:00
  • 0684043e39 Minor copy-editing. Tom Lane 2003-08-14 23:13:27 +00:00
  • b72c1b9f63 Adjustment for unixware threading. Bruce Momjian 2003-08-14 21:24:38 +00:00
  • bb0b73cd73 Mark unixware as having threaded support. Bruce Momjian 2003-08-14 21:14:17 +00:00
  • 483363b03d Fix longstanding thinko in SSL protocol documentation: the server's initial response is 'S', not 'Y', when it is willing to do SSL. Tom Lane 2003-08-14 20:09:31 +00:00
  • 4529d2cf27 Add missing quotes. Tom Lane 2003-08-14 18:56:41 +00:00
  • 80cedf9ba0 Someone moved PageOutput here from common.c, but forgot to move all the #includes it depends on. Tom Lane 2003-08-14 18:49:42 +00:00
  • dbb4dd29e9 Remove unnecessary #include's (see c.h). Tom Lane 2003-08-14 18:48:35 +00:00
  • 71b0fe5b2e Workaround for platforms that have getaddrinfo() without AI_NUMERICHOST. We don't actually need the flag, so just #define it as zero in such cases. Tom Lane 2003-08-14 18:32:55 +00:00
  • 2b5f049f7c Handle double-quotes correctly in user names in ACL lists. Tom Lane 2003-08-14 14:19:11 +00:00
  • 8e97f45f88 Document threading status. Bruce Momjian 2003-08-14 05:27:18 +00:00
  • a4a31d3967 Adjust for compiler options for compiler bug. Bruce Momjian 2003-08-13 23:59:49 +00:00
  • c01641f8ae libpq failed to cope with COPY FROM STDIN if the command was issued via extended query protocol, because it sends Sync right after Execute without realizing that the command to be executed is COPY. There seems to be no reasonable way for it to realize that, either, so the best fix seems to be to make the backend ignore Sync during copy-in mode. Bit of a wart on the protocol, but little alternative. Also, libpq must send another Sync after terminating the COPY, if the command was issued via Execute. Tom Lane 2003-08-13 18:56:21 +00:00
  • 0be731ad44 Add PQexecPrepared() and PQsendQueryPrepared() functions, to allow libpq users to perform Bind/Execute of previously prepared statements. Per yesterday's discussion, this offers enough performance improvement to justify bending the 'no new features during beta' rule. Tom Lane 2003-08-13 16:29:03 +00:00
  • 5be44fa453 Move MemoryContextCheck() call from bottom of PostgresMain loop to just before CommitTransactionCommand(). This is a more sensible place to put it since commit discards a lot of contexts, and we'd not find out about stomps affecting only transaction-local contexts. Tom Lane 2003-08-13 16:16:23 +00:00
  • 364ef51484 Correct error messages Teodor Sigaev 2003-08-13 14:41:59 +00:00
  • bcec1e617a More accuracy work with MinWords option of headline function Teodor Sigaev 2003-08-13 14:37:55 +00:00
  • c090b053fe I'm quite fond of doing VPATH builds, i.e. building outside the source tree. This also catches lots of little Makefile bugs, so here's a small patch for one of them (replacing an explicit reference to thread.c with a reference to it as the first prerequsite of the rule makes make look for it in the place where it was found (the source tree) rather than in the build tree. (using GNU make 3.79.1) Bruce Momjian 2003-08-13 03:12:04 +00:00
  • 9234591071 Include 'IPv4', 'IPv6', or 'Unix' in socket-creation failure messages, in hopes of soothing fears of those with partial IPv6 support. Still an open question whether we should report EAFNOSUPPORT errors at all, though. Tom Lane 2003-08-12 22:42:01 +00:00
  • 90ade5b775 Cope with NoData message from backend. Needed for case where PQexecParams is used with a statement that doesn't return data. Tom Lane 2003-08-12 21:34:44 +00:00
  • b6e5823eda Marginal hacks to move some processing out of the per-client-message processing loop; avoids extra overhead when using parse/bind/execute messages instead of single Query message. Tom Lane 2003-08-12 18:52:38 +00:00
  • fcb90fdc95 Change some frequently-reached elog(DEBUG...) calls to ereport(DEBUG...) for speed reasons. (ereport falls out much more quickly when no output is needed than elog does.) Tom Lane 2003-08-12 18:23:21 +00:00
  • 1c6702f6fc Avoid unnecessary work when stats collection is disabled. Tighten search loop in pgstat_initstats. Per report from Gavin Sherry. Tom Lane 2003-08-12 16:21:18 +00:00
  • e3d97d7da2 Applied patch from Oliver Jowett to clean up the jdbc regression test build Barry Lind 2003-08-11 23:42:04 +00:00
  • 302f1a86dc Rewriter and planner should use only resno, not resname, to identify target columns in INSERT and UPDATE targetlists. Don't rely on resname to be accurate in ruleutils, either. This fixes bug reported by Donald Fraser, in which renaming a column referenced in a rule did not work very well. Tom Lane 2003-08-11 23:04:50 +00:00
  • 730b3a1502 Add: Bruce Momjian 2003-08-11 22:39:48 +00:00
  • c9fa2871f6 Applied patch from Oliver Jowett to better handle invalid input for getArray (no longer throw an index out of range exception) Barry Lind 2003-08-11 21:33:50 +00:00
  • 1f96440d66 Applied patch from Oliver Jowett to clean up some aditional warning messages from ant. Barry Lind 2003-08-11 21:27:52 +00:00
  • 17108e6c4f Applied patch from Oliver Jewett to fix a deprecation in newer versions of ant Barry Lind 2003-08-11 21:25:01 +00:00
  • c82bfea125 Applied patch from Oliver Jewett to clean up the testing README file Barry Lind 2003-08-11 21:20:50 +00:00
  • 1ca4e700de Applied patch by Oliver Jowett to clean up some exception handling Barry Lind 2003-08-11 21:18:47 +00:00
  • d7c609f7c4 Applied patch from Oliver Jowett to improve a buffer sizing. Barry Lind 2003-08-11 21:12:00 +00:00
  • fcbf1f1fdd Applied patch from Kim Ho to fix a regression against a 7.4 server. The result of transaction isolation level changed from uppercase to lower case between 7.3 and 7.4. In testing, a regression was also fixed in this area when talking to a 7.2 server due to changes in how notice messages are processed in the current code. Barry Lind 2003-08-11 20:54:55 +00:00
  • 88381ade63 Code cleanup inspired by recent resname bug report (doesn't fix the bug yet, though). Avoid using nth() to fetch tlist entries; provide a common routine get_tle_by_resno() to search a tlist for a particular resno. This replaces a couple uses of nth() and a dozen hand-coded search loops. Also, replace a few uses of nth(length-1, list) with llast(). Tom Lane 2003-08-11 20:46:47 +00:00
  • cae912d05b Do not link in libwsock32 on non-win32 platforms. Improve grammar of thread-safety comments. Tom Lane 2003-08-11 18:07:38 +00:00
  • 7078441af0 Translation updates Peter Eisentraut 2003-08-11 15:19:58 +00:00
  • ffafacc1f6 Repair potential deadlock created by recent changes to recycle btree index pages: when _bt_getbuf asks the FSM for a free index page, it is possible (and, in some cases, even moderately likely) that the answer will be the same page that _bt_split is trying to split. _bt_getbuf already knew that the returned page might not be free, but it wasn't prepared for the possibility that even trying to lock the page could be problematic. Fix by doing a conditional rather than unconditional grab of the page lock. Tom Lane 2003-08-10 19:48:08 +00:00
  • 18c10877a9 Make various links point to specific places instead of entire parts (doubtless these are hangovers from the old separate-books days). Tom Lane 2003-08-10 01:20:34 +00:00
  • 0019532f47 Request verbose error message output in bug reports. Tom Lane 2003-08-10 01:19:18 +00:00
  • 5bfb0540b0 Update docs for 7.4 array features and polymorphic functions. This is Joe Conway's patch of 7-Aug plus further editorializing of my own. Tom Lane 2003-08-09 22:50:22 +00:00
  • 329a1b7270 I get the following warning when I compile src/bin/pg_id/pg_id.c: Bruce Momjian 2003-08-09 01:25:46 +00:00
  • cf3cc7576c This makes psql use the new pg_get_viewdef function. It also puts one extra line break in to improve formatting. Bruce Momjian 2003-08-09 01:21:54 +00:00
  • 46785776c4 Another pgindent run with updated typedefs. Bruce Momjian 2003-08-08 21:42:59 +00:00
  • 0e2b12bd96 pgindent fix for new typedefs. Bruce Momjian 2003-08-08 21:25:06 +00:00
  • 9e73ab4965 Add: Bruce Momjian 2003-08-08 20:31:26 +00:00
  • 3b2440ebec Remove simple_prompt from /contrib C files, now that it is in /port. Bruce Momjian 2003-08-08 20:20:49 +00:00
  • 635d00ecea Avoid malloc(0). Although standard mallocs seem not to object, some debugging malloc packages do. Tom Lane 2003-08-08 19:19:32 +00:00
  • 332c694085 Fix nasty little order-of-operations bug in _SPI_cursor_operation. Per report from Mendola Gaetano. Tom Lane 2003-08-08 19:18:21 +00:00
  • 4ae02fd03e Update: Bruce Momjian 2003-08-08 18:55:35 +00:00
  • 360162b172 Remove, no in /port. Bruce Momjian 2003-08-08 18:43:49 +00:00
  • b1504b6085 Update. Bruce Momjian 2003-08-08 18:36:34 +00:00
  • 8d74e178d2 Update items. Bruce Momjian 2003-08-08 17:17:17 +00:00
  • 6abde4d803 Update as done: Bruce Momjian 2003-08-08 17:13:02 +00:00
  • d58b01a516 Not needed anymore. Bruce Momjian 2003-08-08 17:05:11 +00:00
  • e4c38da4de Done: Bruce Momjian 2003-08-08 16:34:40 +00:00
  • 22bd88ba35 Remove: Bruce Momjian 2003-08-08 16:33:35 +00:00