hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-13 18:07:05 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • a95ac415f7 More comment cleanups. Bruce Momjian 2001-02-22 23:20:06 +00:00
  • 82fc51e0b3 More comment improvements. Bruce Momjian 2001-02-22 23:02:33 +00:00
  • 4f6c49fef0 Clean up index/btree comments/macros, as approved. Bruce Momjian 2001-02-22 21:48:49 +00:00
  • 660ca3e01c Change /*---- commants to /* where appropriate. pgindent will tighten up the comments later. Bruce Momjian 2001-02-22 18:39:20 +00:00
  • a69f81c202 Update flowchart xfig file. Bruce Momjian 2001-02-22 18:09:20 +00:00
  • d19eeb1b1f The attachement is the Chinese (GB) patch for PgAccess, don't know if it's correct to post here. It's simple to do the translation, And I've test in 7.0.2 & current CVS, seems pretty good. If anyone want this little thing, I'll very happy. use it is very simple, just gunzip it and copy to $PGDIR/share/pgaccess/lib/languages/ for current CVS version, and $PGDIR/pgaccess/lib/languages/ for 7.0* BTW: I havn't got the tools to translate it to BIG5 encoding, is there anybody to to it? Bruce Momjian 2001-02-22 15:33:14 +00:00
  • 50e3c60b95 Avoid 'FATAL: out of free buffers: time to abort !" error during WAL recovery. Recovery failure is always serious. Hiroshi Inoue 2001-02-22 08:59:40 +00:00
  • b200d0993d Adjust expected error message due to change of keyword case-folding. Tom Lane 2001-02-22 05:32:56 +00:00
  • a0fa71837a Add _REGEX_UTILS_H to avoid duplication. Tatsuo Ishii 2001-02-22 04:35:00 +00:00
  • 74b0a18b6b Update mutibyte doc Tatsuo Ishii 2001-02-22 04:30:16 +00:00
  • 3df0fce801 Fix the bug report [ODBC] select from a table having more than 32 fields: reported by Matteo Cavalleri. Great thanks to Tom for his accurate analysis. Hiroshi Inoue 2001-02-22 03:39:30 +00:00
  • e14a9deb93 Document timeofday(), mention start-of-transaction vs. current-time semantics, a few other small improvements. Tom Lane 2001-02-21 23:15:24 +00:00
  • 4dba6814a3 Correct bogus output formatting of timeofday() function. A number of microseconds < 100000 should be displayed as, eg, 13.000126, not 13.126. Tom Lane 2001-02-21 22:03:00 +00:00
  • 15903a1ed4 Comment improvements. Bruce Momjian 2001-02-21 19:07:04 +00:00
  • be92ad49e0 Change case-folding of keywords to conform to SQL99 and fix misbehavior in Turkish locale. Keywords are now checked under pure ASCII case-folding rules ('A'-'Z'->'a'-'z' and nothing else). However, once a word is determined not to be a keyword, it will be case-folded under the current locale, same as before. See pghackers discussion 20-Feb-01. Tom Lane 2001-02-21 18:53:47 +00:00
  • 496373e2e4 Fix markup. (A <keyword> isn't what it is in SQL.) Add jungle of more markup. ;-) Peter Eisentraut 2001-02-21 17:50:38 +00:00
  • fa877ed8ee Safe guard in case of imporper data is provided to elog() in multi-byte build. Tatsuo Ishii 2001-02-21 06:05:23 +00:00
  • 62e48272c2 new regression data for 7.1 Tatsuo Ishii 2001-02-21 06:03:25 +00:00
  • ad7424e391 change destroydb -> dropdb Tatsuo Ishii 2001-02-21 06:02:04 +00:00
  • 3a65e4fca6 Add more details. Peter Eisentraut 2001-02-20 22:27:56 +00:00
  • 824648afae Turn on section numbering. Peter Eisentraut 2001-02-20 22:27:26 +00:00
  • 5ba0f855d1 Clean out any old versions of no-longer-installed header files that may be lurking in the install target directory. But don't zap up-to-date headers (so install-all-headers before regular install will work). Per suggestion from Larry Rosenman. Tom Lane 2001-02-20 20:37:13 +00:00
  • 17137d6c5b Remove unportable #warning directive. Tom Lane 2001-02-20 19:39:24 +00:00
  • cb6edf9d56 Make sure -L and -I's for our source tree are always before system include or library directories on the command line. Peter Eisentraut 2001-02-20 19:20:30 +00:00
  • c4a9023d52 Remove obsolete claim that it doesn't work to use gcc with HP's C++ compiler or g++ with HP's C compiler. Tom Lane 2001-02-20 19:06:16 +00:00
  • d1864e388a Select optimization by default for HP's C compiler. Tom Lane 2001-02-20 19:04:04 +00:00
  • 2bf32fef2b Update TODO list. Bruce Momjian 2001-02-20 17:35:09 +00:00
  • 40bddcc7b6 Update TODO list. Bruce Momjian 2001-02-20 17:25:42 +00:00
  • 60ea34b046 Changes: Bruce Momjian 2001-02-20 15:34:14 +00:00
  • d18c1d1f51 Truncate incoming username and database name to NAMEDATALEN-1 characters so that we don't reject overlength names unnecessarily. Tom Lane 2001-02-20 01:34:40 +00:00
  • 72fa2426fd Update HPUX FAQ. Bruce Momjian 2001-02-20 01:33:07 +00:00
  • f35252de28 Fix pg_passwd's failure to cope with usernames > 8 chars. Tom Lane 2001-02-20 01:16:49 +00:00
  • a24b04de88 Remove inclusion of <varargs.h> on SunOS; this does not work since we use the ANSI varargs style (<stdarg.h>) not the old style. Tatsuo had reported this change was necessary back in the 7.0 beta cycle (4/13/00) but for some reason, making the edit never got done. Tom Lane 2001-02-20 00:28:07 +00:00
  • 2884073848 Document --enable-cassert. Tom Lane 2001-02-19 22:25:43 +00:00
  • eda82e791c Update TODO list. Bruce Momjian 2001-02-19 21:52:57 +00:00
  • cdf220f848 Update TODO list. Bruce Momjian 2001-02-19 20:46:14 +00:00
  • 414f94f262 Change plpgsql's GET DIAGNOSTICS statement to use SQL99-compatible syntax. Fix the RESULT_OID case, which never worked. Add documentation. Tom Lane 2001-02-19 19:49:53 +00:00
  • 66858ebc67 Update TODO list. Bruce Momjian 2001-02-19 19:06:47 +00:00
  • e4ecfdd790 Update TODO list. Bruce Momjian 2001-02-19 16:55:08 +00:00
  • da62249868 Update TODO list. Bruce Momjian 2001-02-19 15:23:08 +00:00
  • 826dc14d8f Synced gram.y and preproc.y. Michael Meskes 2001-02-19 07:30:20 +00:00
  • 87117f5d9e Fix nasty bug in configure. STRTOL='strtoul.o' --> STRTOUL='strtoul.o' Tatsuo Ishii 2001-02-19 05:16:40 +00:00
  • a276392e52 Update example of partially constraining join order to use a subselect in FROM instead of an auxiliary view. We didn't have subselect-in-FROM when I wrote this originally... Tom Lane 2001-02-19 00:24:30 +00:00
  • fa0cd643d2 AND/OR truth table needs another row IMHO. Tom Lane 2001-02-19 00:01:18 +00:00
  • da84545d61 Add copyright mentions, per Tom Lane. Bruce Momjian 2001-02-18 18:34:02 +00:00
  • 215b90d3d7 Allow extract() to accept the same field selectors as date_part(), not just the ones specified by SQL. Peter Eisentraut 2001-02-18 18:06:10 +00:00
  • c3b00e7e29 Add --template option to createdb script to allow access to WITH TEMPLATE option of CREATE DATABASE. In pg_regress, create regression database from template0 to ensure that any installation-local cruft in template1 will not mess up the tests. Tom Lane 2001-02-18 17:53:55 +00:00
  • 48d03278a2 Enhance documentation of date/time functions. Add extract, current_date, current_time, current_timestamp. Add more examples. Remove age(), because it doesn't work like it is documented, and no one could explain it to me. Peter Eisentraut 2001-02-18 17:17:17 +00:00
  • b9c7d371ed Make <lineannotation> italic. Fix syntax error in print style. Peter Eisentraut 2001-02-18 17:15:03 +00:00
  • df8186b282 Add note that partial indices are not currently supported. Tom Lane 2001-02-18 06:07:37 +00:00
  • c3151c29de Update description of fsync option for 7.1. Tom Lane 2001-02-18 05:30:12 +00:00
  • 57e0847180 Change default commit_delay to zero, update documentation. Tom Lane 2001-02-18 04:50:43 +00:00
  • 33cc5d8a4d Change s_lock to not use any zero-delay select() calls; these are just a waste of cycles on single-CPU machines, and of dubious utility on multi-CPU machines too. Tweak s_lock_stuck so that caller can specify timeout interval, and increase interval before declaring stuck spinlock for buffer locks and XLOG locks. On systems that have fdatasync(), use that rather than fsync() to sync WAL log writes. Ensure that WAL file is entirely allocated during XLogFileInit. Tom Lane 2001-02-18 04:39:42 +00:00
  • 58c4ab9d62 Remove bogus set_ps_display call --- changing displayed status here is either wrong or unnecessary in most cases, and on systems where setting status takes a kernel call, the overhead of setting status three times per command rather than two is annoying. Tom Lane 2001-02-18 04:28:31 +00:00
  • 81ff09eeb5 Catch some stray references to .htm files. Tom Lane 2001-02-17 16:52:53 +00:00
  • ec22e3127d No more .htm files, so don't try to add them to the doc tarballs. Tom Lane 2001-02-17 16:47:57 +00:00
  • b5f8c90c15 Update TODO list. Bruce Momjian 2001-02-17 14:35:48 +00:00
  • 2bc2738fc4 Fix a bug in psql. unescape() does not work for multi-byte encodings. Tatsuo Ishii 2001-02-17 10:03:33 +00:00
  • 4571439297 Fix README in Japanese to sync with README.pgbench updated by Tom. (thanks!) Tatsuo Ishii 2001-02-17 06:50:03 +00:00
  • 81357b3c02 Seems a bad idea to assume that select(2) doesn't touch the input masks if it returns EINTR. Tom Lane 2001-02-17 03:37:22 +00:00
  • b634118af9 Add current seek position to FDDEBUG output for FileRead, FileWrite, FileSeek. Tom Lane 2001-02-17 01:00:04 +00:00
  • 6249971b41 Just noticed that use of 'volatile' in HPPA S_UNLOCK() was causing gcc to generate unnecessarily stupid code. Tweak macro to describe a series of store-constant ops, not store/load/store/load/store/load/store. Tom Lane 2001-02-16 23:50:40 +00:00
  • 810c0b85d2 Update README's install instructions to agree with current reality. Tom Lane 2001-02-16 21:41:53 +00:00
  • 64a1b6263d Update bsdi shared memory stuff. Bruce Momjian 2001-02-16 19:43:52 +00:00
  • 88c55990ce Update BSDI FAQ. Bruce Momjian 2001-02-16 19:27:19 +00:00
  • 1ad93b7e45 Defend against starting a non-MULTIBYTE-enabled backend in a database with encoding other than SQL_ASCII. Per recent discussion in pghackers. Tom Lane 2001-02-16 18:50:40 +00:00
  • cdbd27cb23 Some more updates... Peter Mount 2001-02-16 16:45:01 +00:00
  • 016f0eed24 Update BSDI SGML. Bruce Momjian 2001-02-16 16:10:06 +00:00
  • eb90c16dd7 ichar() has been renamed to chr(), so fix translation table. Tom Lane 2001-02-16 03:49:40 +00:00
  • a2dafc6416 Fix bugs in pltcl's new return_null command: it was liable to go belly up if the return datatype's input converter was at all strict, because the converter would get called on junk data when returning NULL. Also ensure that it gives an error rather than coredumping if someone tries to use it in a trigger function. Tom Lane 2001-02-16 03:26:40 +00:00
  • 60d1d671a8 Fix erroneous sort request in pltcl selftest. Tom Lane 2001-02-16 03:22:41 +00:00
  • 13cc7eb3e2 Clean up two rather nasty bugs in operator selection code. Tom Lane 2001-02-16 03:16:58 +00:00
  • b24b2a5be0 Add casting for numeric/float4/float8 type value automatically to compensate the lack of automatic conversion functionality of PostgreSQL server. For example if there's a numeric type binding 1.2567 --> 1.2567::numeric. I hope this change would enable the use of numeric type in MS-Access etc. Hiroshi Inoue 2001-02-16 03:10:09 +00:00
  • f65ebaddb4 Update bsdi faq. Bruce Momjian 2001-02-16 00:46:21 +00:00
  • d50f3cb9eb Update bsdi faq. Bruce Momjian 2001-02-16 00:17:57 +00:00
  • b29f68f611 Take OUTER JOIN semantics into account when estimating the size of join relations. It's not very bright, but at least it now knows that A LEFT JOIN B must produce at least as many rows as are in A ... Tom Lane 2001-02-16 00:03:08 +00:00
  • ca71c66190 Update FAQ. Bruce Momjian 2001-02-15 22:21:23 +00:00
  • bb1095c66d Update FAQ. Bruce Momjian 2001-02-15 22:15:10 +00:00
  • 6da3b76a94 Add some notes about memory management of RI plans. Tom Lane 2001-02-15 21:57:43 +00:00
  • db3ac67d8f Update comments about memory management. Tom Lane 2001-02-15 21:47:08 +00:00
  • 5c2abb960d Update notes about memory context scheme. Tom Lane 2001-02-15 21:38:26 +00:00
  • bf0078d257 Update obsolete wording of error message. Tom Lane 2001-02-15 21:11:17 +00:00
  • 059e361481 Although we can't support out-of-line TOAST storage in indexes (yet), compressed storage works perfectly well. Might as well have a coherent strategy for applying it, rather than the haphazard store-what-you-get approach that was in the code before. The strategy I've set up here is to attempt compression of any compressible index value exceeding BLCKSZ/16, or about 500 bytes by default. Tom Lane 2001-02-15 20:57:01 +00:00
  • 5341cddba8 Further polishing of documentation about new fmgr call convention. Tom Lane 2001-02-15 19:03:35 +00:00
  • 39b9c9f221 Reduce default selectivity estimates for geometric operators; it seems the old ones were not small enough to ensure r-tree and gist indexes would get picked when available. These numbers are totally bogus anyway, but in the absence of any real estimation technique, we'd like to select indexes when available ... Tom Lane 2001-02-15 17:55:17 +00:00
  • 83b4ab53ad Update a couple of obsolete comments. Tom Lane 2001-02-15 17:46:40 +00:00
  • bdacacdfb6 Update TODO list. Bruce Momjian 2001-02-15 16:21:38 +00:00
  • ee2532c4cb Update TODO list. Bruce Momjian 2001-02-15 16:03:46 +00:00
  • 4c2b0f1d73 Update for Tatsuo. Bruce Momjian 2001-02-15 13:31:44 +00:00
  • 462c13215a 1) Change transaction boundary in autocommit off mode per recent discussion in pgsql-odbc. Now SELECT is a boundary but VACUUM isn't. 2) Put back the error handling behavior. When elog(ERROR) was detected the driver automatically issue "ABORT" if a transaction is in progress. 3) Driver version is 7.01.0003(Dave already set it but it was put back). Hiroshi Inoue 2001-02-15 05:32:00 +00:00
  • 21deb42897 Clarify meaning of GEQO_THRESHOLD parameter. Tom Lane 2001-02-15 04:28:50 +00:00
  • 52cacf46b4 Improve documentation of JOIN syntax. Explain NATURAL as an alternative to ON and USING for specifying the join condition, not as an independent kind of join semantics. Tom Lane 2001-02-15 04:10:54 +00:00
  • 5c90733558 Unicode <-> SJIS new mapping tables (based on CP932.TXT) contributed by Eiji Tokuya" <e-tokuya@Mail.Sankyo-Unyu.co.jp> Tatsuo Ishii 2001-02-15 01:56:29 +00:00
  • de434c2d5f Arrange for ORDER BY an expression on a UNION/INTERSECT/EXCEPT result, such as SELECT f1 FROM foo UNION SELECT ... ORDER BY upper(f1) to draw 'ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of the result columns' rather than the uninformative 'f1 not found' we were producing before. Eventually this should actually work, but that looks much too hard to try to implement in late beta... Tom Lane 2001-02-15 01:10:28 +00:00
  • c7d2ce7bc6 Repair problems with duplicate index names generated when CREATE TABLE specifies redundant UNIQUE conditions. Tom Lane 2001-02-14 23:32:38 +00:00
  • 4a66f9dd54 Change scoping of table and join refnames to conform to SQL92: a JOIN clause with an alias is a <subquery> and therefore hides table references appearing within it, according to the spec. This is the same as the preliminary patch I posted to pgsql-patches yesterday, plus some really grotty code in ruleutils.c to reverse-list a query tree with the correct alias name depending on context. I'd rather not have done that, but unless we want to force another initdb for 7.1, there's no other way for now. Tom Lane 2001-02-14 21:35:07 +00:00
  • d42d31e78e Alter documentation of boolean type, add example. Someone figured that it wasn't clear that the "boolean type" was actually called "boolean". Add tip about "casting" booleans using CASE. Peter Eisentraut 2001-02-14 19:37:26 +00:00
  • 41b4628916 Format <structname>, <structfield>, and <type> mono-spaced. Peter Eisentraut 2001-02-14 19:35:14 +00:00
  • bb7b71826d Web Feb 14 17:29:00 GMT 2001 peter@retep.org.uk - Fixed bug in LargeObject & BlobOutputStream where the stream's output was not flushed when either the stream or the blob were closed. - Fixed PreparedStatement.setBinaryStream() where it ignored the length Peter Mount 2001-02-14 17:45:17 +00:00
  • c1abe85529 Update TODO list. Bruce Momjian 2001-02-14 15:12:37 +00:00