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

Commit Graph

  • ecef2caae9 Clean up routines in setrefs.c by replacing individual tree walking logic with expression_tree_walker/mutator calls. Tom Lane 1999-08-09 00:56:05 +00:00
  • 6bc601b648 Create a standardized expression_tree_mutator support routine to go along with expression_tree_walker. (_walker is not suitable for routines that need to alter the tree structure significantly.) Other minor cleanups in clauses.c. Tom Lane 1999-08-09 00:51:26 +00:00
  • f0b651ac6b replace #Include . Bruce Momjian 1999-08-09 00:08:52 +00:00
  • 70c5c63d56 Someone back-patched a regression test change without back-patching the expected file (or running the test, evidently...) Tom Lane 1999-08-08 21:39:34 +00:00
  • c6100c9e95 Back-patch BTScan abort fix into REL6_5. Tom Lane 1999-08-08 20:24:12 +00:00
  • 4488b69b4c Fix nbtree's failure to clear BTScans list during xact abort. Also, move responsibility for calling vc_abort into main xact.c list of things-to-call-at-abort. What in the world was it doing down inside of TransactionIdAbort()? Tom Lane 1999-08-08 20:12:52 +00:00
  • e947d39eea Back-patch fix for busted ELF test in configure. Tom Lane 1999-08-08 17:55:19 +00:00
  • fb491a5854 For a unique-key attribute (no duplicate values), vacuum analyze was recording a disbursion of 0, not the correct value 1/numberOfRows. Tom Lane 1999-08-08 17:13:10 +00:00
  • a76ad509fe Remove old man pages. All info is in new man pages or other docs. Thomas G. Lockhart 1999-08-08 15:21:50 +00:00
  • d0a1919852 Use sgml/Makefile to generate man sections, so just "make man" there. Thomas G. Lockhart 1999-08-08 15:10:21 +00:00
  • 7af929cd79 Switch from old man pages to new ones generated from sgml. Thomas G. Lockhart 1999-08-08 15:09:04 +00:00
  • 13d1a3c06d Remove emacs properties block from end of file. Thomas G. Lockhart 1999-08-08 15:05:22 +00:00
  • c9ff1a5a75 Update references to char2 type by using char(2). Thanks to Garr Updegraff <garru@uci.edu> for the tip. Thomas G. Lockhart 1999-08-08 04:21:33 +00:00
  • f11bdb9db5 Allow nsgmls to validate input by defining the document type. Use refentry.sgml as a generic header for man pages through nsgmls. Thomas G. Lockhart 1999-08-08 04:18:29 +00:00
  • 4cddd482c1 Fix so BSD yacc works on file. Bruce Momjian 1999-08-07 04:25:02 +00:00
  • c879556780 Fix markup to allow clean man pages. Add new pages for programming languages and tcl shells. Thomas G. Lockhart 1999-08-06 13:50:31 +00:00
  • 6b07527721 Fix cross-reference markup so that only the *title* of the Operators chapter is included, not the chapter itself. Thanks to Evelyn Mitchell <efm@tummy.com> for pointing it out. Thomas G. Lockhart 1999-08-06 13:48:38 +00:00
  • 777a4f71f0 Remove explicit references to ref/ path in file names; use vpath instead. Fix rules for man pages to ensure double-pass to get cross references. Add a few new man pages. Thomas G. Lockhart 1999-08-06 13:46:17 +00:00
  • 4f1766f1ea Try to clarify characteristics of the SERIAL type. Fix source indenting, which does not affect output. Note: still need docs on NUMERIC and DECIMAL (and let's not talk about regression tests :() Thomas G. Lockhart 1999-08-06 13:43:42 +00:00
  • e1fad50a5d Revise generation of hashjoin paths: generate one path per hashjoinable clause, not one path for a randomly-chosen element of each set of clauses with the same join operator. That is, if you wrote SELECT ... WHERE t1.f1 = t2.f2 and t1.f3 = t2.f4, and both '=' ops were the same opcode (say, all four fields are int4), then the system would either consider hashing on f1=f2 or on f3=f4, but it would *not* consider both possibilities. Boo hiss. Also, revise estimation of hashjoin costs to include a penalty when the inner join var has a high disbursion --- ie, the most common value is pretty common. This tends to lead to badly skewed hash bucket occupancy and way more comparisons than you'd expect on average. I imagine that the cost calculation still needs tweaking, but at least it generates a more reasonable plan than before on George Young's example. Tom Lane 1999-08-06 04:00:17 +00:00
  • b7883d7e3a parse_coerce fix allows early simplification of one constant-coercion expression in the rules test. Tom Lane 1999-08-05 02:35:29 +00:00
  • fd19a350ea Revise parse_coerce() to handle coercion of int and float constants, not only string constants, at parse time. Get rid of parser_typecast2(), which is bogus and redundant... Tom Lane 1999-08-05 02:33:54 +00:00
  • 5a76a94e41 Update TODO list. Bruce Momjian 1999-08-05 01:53:35 +00:00
  • b15a7c9fbe Fix ELF test so it doesn't spit up on all non-ELF systems... use Autoconf-approved method of testing for predefined symbols, and move it down to where we know what compiler to run and how to run it. Tom Lane 1999-08-03 00:09:32 +00:00
  • b0984e6995 Add a VACUUM command in hopes of making pg_upgrade usable again in MVCC environment. I do not trust this until Vadim says it's OK... Tom Lane 1999-08-02 22:34:53 +00:00
  • 2dca8973fe Final round before bed...more tomorrow... Marc G. Fournier 1999-08-02 06:27:09 +00:00
  • 10ace1fac8 Another mass of them... just #include file changes and/or DOUBLEALIGN->MAXALIGN Marc G. Fournier 1999-08-02 05:57:07 +00:00
  • 9a8aeb23a1 Another 'mega-commit' of back-patches ... Marc G. Fournier 1999-08-02 05:25:27 +00:00
  • b2a2be4c5a *** empty log message *** Michael Meskes 1999-08-02 04:59:18 +00:00
  • 8624ff7612 Further selectivity-estimation work. Speed up eqsel() (it should just call the given operator, not look up an = operator). Fix intltsel() so that all numeric data types are converted to double before trying to estimate where the given comparison value is in the known range of column values. intltsel() still needs work, or replacement, for non-numeric data types ... but for nonintegral numeric types it should now be delivering reasonable estimates. Tom Lane 1999-08-02 02:05:41 +00:00
  • d35eebe748 back out last... Marc G. Fournier 1999-08-02 01:42:57 +00:00
  • 557ff53044 testing somethign... Marc G. Fournier 1999-08-02 01:40:30 +00:00
  • 62d146bdcd Make sure D'Arcy's elf/configure changes get into -stable: Marc G. Fournier 1999-08-02 01:33:33 +00:00
  • 9032d3f205 autoconf Bruce Momjian 1999-08-01 16:36:57 +00:00
  • b2a0a4e8f5 I didn't see any further discussion so here is, I hope, a clean fix to configure.in to determine if a system is ELF or not. Note that some of the tests earlier may be redundant but I took the safest route. Bruce Momjian 1999-08-01 16:30:05 +00:00
  • aa1bbed7da Update NT readme. Bruce Momjian 1999-08-01 14:48:50 +00:00
  • 44878506d8 First step in fixing selectivity-estimation code. eqsel and neqsel now behave as per my suggestions in pghackers a few days ago. selectivity for < > <= >= should work OK for integral types as well, but still need work for nonintegral types. Since these routines have never actually executed before :-(, this may result in some significant changes in the optimizer's choices of execution plans. Let me know if you see any serious misbehavior. CAUTION: THESE CHANGES REQUIRE INITDB. pg_statistic table has changed. Tom Lane 1999-08-01 04:54:25 +00:00
  • f851c6b07d Add another ORDER BY to rules test; got tired of it 'failing' every time I tweak the optimizer... Tom Lane 1999-08-01 04:41:32 +00:00
  • 970ef45c41 Re-enable pg_upgrade, after adding checks that the source and target databases are of versions it knows about. Tom Lane 1999-07-31 22:06:44 +00:00
  • d7f2c5580d Add some more verbiage to man page's directions for pg_upgrade. Tom Lane 1999-07-31 22:05:48 +00:00
  • cf835f97fc Add comments for attdisbursion field --- NO code change. Tom Lane 1999-07-31 19:07:25 +00:00
  • 30da344cb1 Update comments about clause selectivity estimation. Tom Lane 1999-07-30 22:34:19 +00:00
  • ff753a7775 final one before weekend starts...more at end of weekend Marc G. Fournier 1999-07-30 19:36:33 +00:00
  • 33831f5805 config.h.in was so re-org'd, tested and committing seperately... Marc G. Fournier 1999-07-30 19:13:44 +00:00
  • d90a0d770c Another batch ... Marc G. Fournier 1999-07-30 18:52:56 +00:00
  • 7d30c90ecc More include merges from -current, following a clean compile... Marc G. Fournier 1999-07-30 18:27:02 +00:00
  • 44763a2b23 Make usecatupd disabled for normal users, and allow normal users to update temp tables with this setting. Bruce Momjian 1999-07-30 18:09:49 +00:00
  • 2c49183c80 Carefully merge in Bruce's include file changes ... commit'd only after a clean compile ... Marc G. Fournier 1999-07-30 17:07:23 +00:00
  • 710add2942 remove "define NO_UNISTD_H" Marc G. Fournier 1999-07-30 04:26:51 +00:00
  • 759bee9746 spelling corrections ... Marc G. Fournier 1999-07-30 04:23:23 +00:00
  • 74a1d19c4a Minor back-ports from v6.6 for the compile/configuration... Marc G. Fournier 1999-07-30 04:13:44 +00:00
  • 04578a9180 Further cleanups of indexqual processing: simplify control logic in indxpath.c, avoid generation of redundant indexscan paths for the same relation and index. Tom Lane 1999-07-30 04:07:25 +00:00
  • 037cac7ca6 There is one section that changed, concernign startup...the rest is just changes for v6.5->v6.5.1, so relatively harmless Marc G. Fournier 1999-07-30 04:04:53 +00:00
  • 63b70d3546 v6.6's HISTORY file should reflect changes that went into all previous releases, including v6.5.1 ... Marc G. Fournier 1999-07-30 03:58:20 +00:00
  • f08baacfa5 just testing a script... Marc G. Fournier 1999-07-30 03:45:57 +00:00
  • fca190e102 Remove extra #endif Bruce Momjian 1999-07-30 03:45:44 +00:00
  • 5fb84df9b1 Nothing changed, just testing cvslog ... Marc G. Fournier 1999-07-30 03:42:59 +00:00
  • 8eb81bb89d there should be no reasons why configure can't/isn't maintained across versions... Marc G. Fournier 1999-07-30 03:30:57 +00:00
  • e11ab1b461 Bring down template changes from -CURRENT Marc G. Fournier 1999-07-30 03:26:29 +00:00
  • dafc0194e2 Its a stable release, not development... Marc G. Fournier 1999-07-30 03:22:40 +00:00
  • d41754cea2 Fix description of psql flags -t and -q. Bruce Momjian 1999-07-30 00:59:50 +00:00
  • 7d572886d6 Fix coredump seen when doing mergejoin between indexed tables, for example in the regression test database, try select * from tenk1 t1, tenk1 t2 where t1.unique1 = t2.unique2; 6.5 has this same bug ... Tom Lane 1999-07-30 00:56:17 +00:00
  • 161be69544 Update comments for create_indexscan_node(). Tom Lane 1999-07-30 00:44:23 +00:00
  • 12c51d9c6e Remove comment after optimization flag. Bruce Momjian 1999-07-29 15:39:05 +00:00
  • 125d46c125 Back-patch fixes for CASE in WHERE join clauses. Tom Lane 1999-07-29 03:34:11 +00:00
  • ecbfafbe0e Add support for Case exprs to fix_indxqual_references, so that Case works in WHERE join clauses. Temporary patch --- this routine is one of many that ought to be changed to use centralized expression-tree- walking logic. Tom Lane 1999-07-29 02:48:05 +00:00
  • 6b157f376a Add equal() funcs for Case nodes ... amazing we had not detected this omission before. Miscellaneous other cleanups. Tom Lane 1999-07-29 02:45:36 +00:00
  • a06fd1f316 Update TODO list. Bruce Momjian 1999-07-28 17:52:31 +00:00
  • 8bc25734a1 Update TODO list. Bruce Momjian 1999-07-28 17:51:41 +00:00
  • 9682e8081b Allow a_expr not just AexprConst in the right-hand list of IN and NOT IN operators. Rewrite grotty implementation of IN-list parsing ... look Ma, no global variable ... Tom Lane 1999-07-28 17:39:38 +00:00
  • bb68f6eaa6 Update TODO list. Bruce Momjian 1999-07-28 00:09:49 +00:00
  • b62fdc13f0 Correct bug in best_innerjoin(): it should check all the rels that the inner path needs to join to, but it was only checking for the first one. Failure could only have been observed with an OR-clause that mentions 3 or more tables, and then only if the bogus path was actually selected as cheapest ... Tom Lane 1999-07-27 06:23:12 +00:00
  • 2f30d5a34a My recent optimizer changes caused a different plan to be picked for one of the complex joins in rules test ... leading to a different output ordering ... Tom Lane 1999-07-27 03:53:54 +00:00
  • 9e7e29e6c9 First cut at doing LIKE/regex indexing optimization in optimizer rather than parser. This has many advantages, such as not getting fooled by chance uses of operator names ~ and ~~ (the operators are identified by OID now), and not creating useless comparison operations in contexts where the comparisons will not actually be used as indexquals. The new code also recognizes exact-match LIKE and regex patterns, and produces an = indexqual instead of >= and <=. Tom Lane 1999-07-27 03:51:11 +00:00
  • 434df3fb7a Update TODO list. Bruce Momjian 1999-07-26 20:12:33 +00:00
  • 32a505e897 Update TODO list. Bruce Momjian 1999-07-26 15:28:32 +00:00
  • 49ed4dd779 Further work on planning of indexscans. Cleaned up interfaces to index_selectivity so that it can be handed an indexqual clause list rather than a bunch of assorted derivative data. Tom Lane 1999-07-25 23:07:26 +00:00
  • 8ae29a1d40 Remove 'restrictinfojoinid' field from RestrictInfo nodes. The only place it was being used was as temporary storage in indxpath.c, and the logic was wrong: the same restrictinfo node could get chosen to carry the info for two different joins. Right fix is to return a second list of unjoined-relids parallel to the list of clause groups. Tom Lane 1999-07-25 17:53:27 +00:00
  • ac4913a0dd Clean up messy clause-selectivity code in clausesel.c; repair bug identified by Hiroshi (incorrect cost attributed to OR clauses after multiple passes through set_rest_selec()). I think the code was trying to allow selectivities of OR subclauses to be passed in from outside, but noplace was actually passing any useful data, and set_rest_selec() was passing wrong data. Tom Lane 1999-07-24 23:21:14 +00:00
  • 348bdbce79 Minor code beautification, extensive improvement of comments. This file was full of obsolete and just plain wrong commentary... Tom Lane 1999-07-23 03:34:49 +00:00
  • baac6f981e Exit cleanups I made yesterday caused pq_close() to be invoked during exit from a standalone backend, leading to core dump. This is the cause of the recently reported initdb-time crash :-(. Sorry folks... Tom Lane 1999-07-23 03:00:10 +00:00
  • 66f66343f6 Alpha spinlock fix from Uncle George <gatgul@voicenet.com> Bruce Momjian 1999-07-22 18:30:08 +00:00
  • f2f43efbe1 Complete merge of all old man page information. lisp.sgml is a placeholder for Eric Marsden's upcoming contribution. catalogs.sgml is not yet marked up or integrated. It should perhaps become an appendix. Thomas G. Lockhart 1999-07-22 15:11:05 +00:00
  • a27512e634 Complete merge of all old man page information. ecpg reference page still needs formatting. Thomas G. Lockhart 1999-07-22 15:09:15 +00:00
  • 2aa64f79f5 Plug several holes in backend's ability to cope with unexpected loss of connection to frontend. Tom Lane 1999-07-22 02:40:07 +00:00
  • 991b82ee13 Update TODO list. Bruce Momjian 1999-07-20 23:05:50 +00:00
  • a2b619a1f0 Update TODO list. Bruce Momjian 1999-07-20 21:43:18 +00:00
  • 7746a2db36 Update TODO list. Bruce Momjian 1999-07-20 17:24:36 +00:00
  • f96babac12 While I was running some tests in psql, trying to figure out how to change the query string to handle any length, I discovered that under certain conditions, psql will core dump when handling long strings. Thus, the patch. It was caused by a buffer overrun, probably not noticeable in a lot of cases, but pretty noticeable in mine. Bruce Momjian 1999-07-20 17:20:43 +00:00
  • a2bb39c738 Update TODO list. Bruce Momjian 1999-07-20 17:16:25 +00:00
  • c175de56dc Reverse out cache changes that are not ready yet. Bruce Momjian 1999-07-20 17:14:08 +00:00
  • 7944d501f4 Use -ieee alpha flag for gcc and egcs only. Bruce Momjian 1999-07-20 16:48:58 +00:00
  • 41b60ba7ad autoconf Bruce Momjian 1999-07-20 02:45:44 +00:00
  • 93fbd46ba5 Re-add Makefile. Bruce Momjian 1999-07-20 02:44:09 +00:00
  • e740c9b1d1 Move -ieee to adt Makefile, and add CPU Makefile variable. Bruce Momjian 1999-07-20 02:42:20 +00:00
  • 2908bd535f Complain about INSERT ... SELECT ... ORDER BY, which we do not support, but which the grammar was accepting. Also, fix several bugs having to do with failure to copy fields up from a subselect to a select or insert node. Tom Lane 1999-07-20 00:18:01 +00:00
  • d6ce220f04 psql fix. Bruce Momjian 1999-07-19 21:06:19 +00:00
  • e2f32054f4 linux/sparc cleanup Bruce Momjian 1999-07-19 18:19:40 +00:00
  • b653d1e263 Fix for linux/sparc. Bruce Momjian 1999-07-19 18:07:36 +00:00
  • 50644a2202 Cleanup of patch just applied. Bruce Momjian 1999-07-19 16:49:17 +00:00