hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-11 04:37:32 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • d24ef0d08f Make EXPLAIN results for Append, Group, Agg, Unique nodes more plausible. Group and Unique use an arbitrary assumption that there will be about 10% as many groups as input tuples --- perhaps someday we can refine this. Tom Lane 2000-02-03 06:12:19 +00:00
  • 40055db1eb Repair relation refcount leakage caused by SELECT FOR UPDATE. Tom Lane 2000-02-03 00:02:58 +00:00
  • 31a8996ba4 Inconsistency in CREATE CONSTRAINT TRIGGER with the actions performed by analyse.c when creating table constraints. Jan Wieck 2000-02-02 20:54:17 +00:00
  • 83fd594a3d Add short chapter in developer's guide on formatting source code. Thomas G. Lockhart 2000-02-02 16:25:04 +00:00
  • 6454ae37a5 Add information on QNX port from Andreas Kardos. Thomas G. Lockhart 2000-02-02 16:24:19 +00:00
  • 215935daa3 Remove extraneous end tag. Code now compiles cleanly. Thomas G. Lockhart 2000-02-02 16:23:37 +00:00
  • acaa064fa8 Add info on debian package installation of sgml toolkits. Thomas G. Lockhart 2000-02-02 16:22:45 +00:00
  • fd54baa945 Add detailed information on Australian time zones. Thomas G. Lockhart 2000-02-02 16:21:06 +00:00
  • 911fc20c41 Update with current summary information on pgadmin. From pgadmin author on 99-12-24. Thomas G. Lockhart 2000-02-02 16:19:54 +00:00
  • 2ea31fabe7 *** empty log message *** Peter Eisentraut 2000-02-02 13:20:15 +00:00
  • c823143f8a Fixed bug in NO ACTION trigger proc entries. Jan Wieck 2000-01-31 14:02:27 +00:00
  • a152ebeec6 Fix problems seen in parallel regress tests when SI buffer overruns (causing syscache and relcache flushes). Relcache entry rebuild now preserves original tupledesc, rewrite rules, and triggers if possible, so that pointers to these things remain valid --- if these things change while relcache entry has positive refcount, we elog(ERROR) to avoid later crash. Arrange for xact-local rels to be rebuilt when an SI inval message is seen for them, so that they are updated by CommandCounterIncrement the same as regular rels. (This is useful because of Hiroshi's recent changes to process our own SI messages at CommandCounterIncrement time.) This allows simplification of some routines that previously hacked around the lack of an automatic update. catcache now keeps its own copy of tupledesc for its relation, rather than depending on the relcache's copy; this avoids needing to reinitialize catcache during a cache flush, which saves some cycles and eliminates nasty circularity problems that occur if a cache flush happens while trying to initialize a catcache. Eliminate a number of permanent memory leaks that used to happen during catcache or relcache flush; not least of which was that catcache never freed any cached tuples! (Rule parsetree storage is still leaked, however; will fix that separately.) Nothing done yet about code that uses tuples retrieved by SearchSysCache for longer than is safe. Tom Lane 2000-01-31 04:35:57 +00:00
  • ca0f1435ec Hmm, equalfuncs didn't know about SortClause or GroupClause nodes... Tom Lane 2000-01-31 01:21:39 +00:00
  • 44035918bb Added numeric and int8 types. Bug fix for LongVarBinary -- begin transaction Byron Nikolaidis 2000-01-30 21:14:25 +00:00
  • 3a1218dced Delete unused and long-dead header file. Tom Lane 2000-01-29 21:13:23 +00:00
  • 04103e00f1 Modify uses of RelationFlushRelation and RelationCacheInvalidate so that we *always* rebuild, rather than deleting, an invalidated relcache entry that has positive refcount. Otherwise an SI cache overrun leads to dangling Relation pointers all over the place! Tom Lane 2000-01-29 19:51:59 +00:00
  • 98c6e81e94 Update TODO list. Bruce Momjian 2000-01-29 17:25:46 +00:00
  • 2b84cbb60f A few minor psql enhancements Initdb help correction Changed end/abort to commit/rollback and changed related notices Commented out way old printing functions in libpq Fixed a typo in alter table / alter column Peter Eisentraut 2000-01-29 16:58:54 +00:00
  • 7e7416bd4e Update copyright file. Bruce Momjian 2000-01-29 08:53:10 +00:00
  • c5b02a7a26 Attached is a uuencoded tarball that contains 3 new files and two patches for the plperl subdir. Bruce Momjian 2000-01-29 01:58:50 +00:00
  • 1380921e65 Patch from Hiroshi for overflow btree comparison. Bruce Momjian 2000-01-28 17:23:47 +00:00
  • 3f6ff32972 Update TODO list. Bruce Momjian 2000-01-28 04:47:49 +00:00
  • a85b67d05b Update TODO list. Bruce Momjian 2000-01-28 03:46:06 +00:00
  • 552bd9645c Update TODO list. Bruce Momjian 2000-01-28 03:40:34 +00:00
  • 003dd965d2 Apply the heuristic proposed by Taral (see pgsql-general archives for 2-Oct-98 or TODO.detail/cnfify) to decide whether we want to reduce WHERE clause to CNF form, DNF form, or neither. This is a HUGE win. The heuristic conditions could probably still use a little tweaking to make sure we don't pick CNF when DNF would be better, or vice versa, but the risk of exponential explosion in cnfify() is gone. I was able to run ten-thousand-AND-subclause queries through the planner in a reasonable amount of time. Tom Lane 2000-01-28 03:22:36 +00:00
  • b53955f38a *** empty log message *** Michael Meskes 2000-01-27 19:01:35 +00:00
  • dd979f66be Redesign DISTINCT ON as discussed in pgsql-sql 1/25/00: syntax is now SELECT DISTINCT ON (expr [, expr ...]) targetlist ... and there is a check to make sure that the user didn't specify an ORDER BY that's incompatible with the DISTINCT operation. Reimplement nodeUnique and nodeGroup to use the proper datatype-specific equality function for each column being compared --- they used to do bitwise comparisons or convert the data to text strings and strcmp(). (To add insult to injury, they'd look up the conversion functions once for each tuple...) Parse/plan representation of DISTINCT is now a list of SortClause nodes. initdb forced by querytree change... Tom Lane 2000-01-27 18:11:50 +00:00
  • 3f0074e403 fix for compile. Bruce Momjian 2000-01-27 05:33:51 +00:00
  • 91250f3854 Remove duplicate extern declaration. Tom Lane 2000-01-26 23:48:05 +00:00
  • 2d5dd7557b Update files. Bruce Momjian 2000-01-26 16:10:01 +00:00
  • 02d83c4475 Add include for float.h. Bruce Momjian 2000-01-26 06:33:49 +00:00
  • 5c25d60244 Add: Bruce Momjian 2000-01-26 05:58:53 +00:00
  • b866d2e2d7 as attache of this mail is patch (to the main tree) with to_char's family functions. Contain: Bruce Momjian 2000-01-25 23:53:56 +00:00
  • 90aaad06cf Remove obsolete references to 8K query limit. Tom Lane 2000-01-25 07:04:04 +00:00
  • 6f843e8dd8 Fix pg_euccn_mblen() so that it always returns 2 if data is not ascii. (EUC_CN does have only code set 0 and 1) Tatsuo Ishii 2000-01-25 02:12:27 +00:00
  • a39c6ab4cb Forgot that expr assumes regexp is anchored-left; therefore need .* in front of any platform name pattern that's not supposed to match beginning at the start of the machine type name... Tom Lane 2000-01-25 01:59:27 +00:00
  • 306ada82c2 Removed alter table drop column. Peter Eisentraut 2000-01-24 23:40:35 +00:00
  • ca5771dc27 Update TODO list. Bruce Momjian 2000-01-24 22:27:59 +00:00
  • bdb41ad0e7 Made abstime/reltime use int4 instead of time_t (TODO item) Made type equivalency apply to aggregates (TODO item) Fixed parsing bug in psql Reverted some stupid options changes I made to pg_dump Peter Eisentraut 2000-01-24 19:34:19 +00:00
  • 0dbffa704a First cut at making useful selectivity estimates for range queries (ie, WHERE x > lowbound AND x < highbound). It's not very bright yet but it does something useful. Also, rename intltsel/intgtsel to scalarltsel/scalargtsel to reflect usage better. Extend convert_to_scalar to do something a little bit useful with string data types. Still need to make it do something with date/time datatypes, but I'll wait for Thomas's datetime unification dust to settle first. Eventually the routine ought not have any type-specific knowledge at all; it ought to be calling a type-dependent routine found via a pg_type column; but that's a task for another day. Tom Lane 2000-01-24 07:16:52 +00:00
  • 8bcac56086 Update for index change. Semes it didn't work the first time. Bruce Momjian 2000-01-24 03:08:27 +00:00
  • da5aba105f Remove Ops parameter from STATRELID cache lookup, for Tom Lane and optimizer. Bruce Momjian 2000-01-24 02:12:58 +00:00
  • 4d564c5b12 Update TODO list. Bruce Momjian 2000-01-23 17:30:18 +00:00
  • b2ff7d08ad Change format of postmaster.opts.default. Executable file name (postmaster) no more included in the file. Tatsuo Ishii 2000-01-23 08:20:24 +00:00
  • 2605ceb704 Fix error messages for the lack of multi-byte support. Since --with-mb has been removed from configure, previous messages were not appropriate. Tatsuo Ishii 2000-01-23 08:16:37 +00:00
  • cfe717714c char_length()/octet_length for char() type now returns length of the charcter including trailing blanks. Tatsuo Ishii 2000-01-23 08:13:34 +00:00
  • 27fee810ff Replace SearchSysCacheGetAttribute with SysCacheGetAttr, which fetches an attribute of a tuple previously fetched with SearchSysCacheTuple. This avoids a lot of redundant cache lookups, particularly in selfuncs.c. Also, remove SearchSysCacheStruct, which was unused and grotty. Tom Lane 2000-01-23 03:43:24 +00:00
  • 1161077e97 Update TODO list. Bruce Momjian 2000-01-23 03:28:54 +00:00
  • 0daf852b32 Update TODO list. Bruce Momjian 2000-01-23 03:19:05 +00:00
  • 8449df8a67 First cut at unifying regular selectivity estimation with indexscan selectivity estimation wasn't right. This is better... Tom Lane 2000-01-23 02:07:00 +00:00
  • 49581f9848 updated install file updated date/time types doc fixed small psql bug removed libpq code that lower-cased db names make notice when long identifier is truncated Peter Eisentraut 2000-01-23 01:27:39 +00:00
  • 978d2385a8 Update regress tests for change of pg_am/pg_amop. Tom Lane 2000-01-22 23:51:20 +00:00
  • 71ed7eb494 Revise handling of index-type-specific indexscan cost estimation, per pghackers discussion of 5-Jan-2000. The amopselect and amopnpages estimators are gone, and in their place is a per-AM amcostestimate procedure (linked to from pg_am, not pg_amop). Tom Lane 2000-01-22 23:50:30 +00:00
  • 78845177bb findoidjoins was suffering from bit rot (pginterface no longer in expected location). Tom Lane 2000-01-22 23:05:14 +00:00
  • fa5400c0a4 added ALTER TABLE DROP COLUMN, early version Peter Eisentraut 2000-01-22 14:20:56 +00:00
  • 3f51bdafdc Update TODO list. Bruce Momjian 2000-01-22 04:29:46 +00:00
  • 5c33b3c658 Change a few routines into macros to improve speed of COPY IN inner loop. Tom Lane 2000-01-22 03:52:04 +00:00
  • d32cd1bb25 Forgot to handle column length defaults in ALTER TABLE ADD COLUMN. Tom Lane 2000-01-22 01:22:48 +00:00
  • 7cc0d6ae9d Fix tab-complete so it works with old versions of readline that don't have the rl_completion_append_character variable. The tab completion behavior doesn't seem to be quite perfect in that situation, but it's better than failing to build at all... Tom Lane 2000-01-21 23:32:36 +00:00
  • e33f550bc0 Fix handleCopyIn's response to EOF seen mid-line, that is, input file does not end with a newline. I don't think this explains the recent complaints, since this bug existed in 6.5 (and probably long before). But might as well fix it now that I see it. Tom Lane 2000-01-21 04:21:12 +00:00
  • 5b7bc48391 Update TODO list. Bruce Momjian 2000-01-21 03:55:22 +00:00
  • de56d999cd Simplify match patterns a little. Tom Lane 2000-01-21 01:48:02 +00:00
  • 68ba9835cb Bruce, you forgot to rename these files... Tom Lane 2000-01-21 01:39:54 +00:00
  • 901aaf34bd Update TODO list. Bruce Momjian 2000-01-21 00:45:29 +00:00
  • 481a7439fb plperl Makefile cleanup. Doesn't work on BSDI yet. Bruce Momjian 2000-01-20 23:00:40 +00:00
  • 22e7c06506 Update plperl makefile. Bruce Momjian 2000-01-20 22:31:23 +00:00
  • e3415aa834 Rename 7.0.0 to 7.0 to be consistent with prior release numbering. Bruce Momjian 2000-01-20 22:21:30 +00:00
  • 7f99680c6d Update install file for 7.0 to match new SGML version. Bruce Momjian 2000-01-20 22:17:39 +00:00
  • 13f8875017 Added new pg_id to fix initdb problems New INSTALL file Fixed a copyright notice Peter Eisentraut 2000-01-20 21:51:09 +00:00
  • a959e3f7c0 Cleanup vacuum names. Bruce Momjian 2000-01-20 20:01:25 +00:00
  • e6ed9f2c75 Fix typo in \z. Bruce Momjian 2000-01-20 15:29:20 +00:00
  • 8792af75f6 I have noticed that the geometry test's output for hppa1 and hppa2 are in fact the same, so I suggest they could be the same file say geometry-positive-zeros.out, as the main difference seems to be not printing eg. (0,-0). In src/test/regress/expected, I propose Bruce Momjian 2000-01-20 15:21:23 +00:00
  • e474dd182a Bruce, Bruce Momjian 2000-01-20 15:13:19 +00:00
  • 8cfb8c68ea Clean up longstanding warnings. I think the remaining 'defined but not used' warnings would go away if the scanner didn't use YY_REJECT. Tom Lane 2000-01-20 05:44:34 +00:00
  • 3888c62d5d Clean up longstanding gcc warnings by adding missing extern declarations. Tom Lane 2000-01-20 05:34:32 +00:00
  • 1c15186747 Clean up longstanding gcc warnings by adding missing extern declarations. Tom Lane 2000-01-20 05:26:54 +00:00
  • b6fdd14765 ecpg shouldn't depend on parser/gramparse.h. Also, eliminate some compiler warnings caused by lack of extern declarations in extern.h. I believe the remaining gcc warnings here would go away if the ecpg grammar could be tweaked so it doesn't use REJECT ... Tom Lane 2000-01-20 05:23:26 +00:00
  • c02f1ead48 Well, I finally solved the linking problem that kept me from making perl secure. Bruce Momjian 2000-01-20 05:08:58 +00:00
  • d242b64ba2 Tweak includes to avoid compiler warning on HPUX. Tom Lane 2000-01-20 04:11:52 +00:00
  • 7476e3718b Assign a typmod of -1 to unadorned CHAR and NUMERIC type specs. This allows casts without specific length requirements to continue to work as they did before; that is, x::char will not truncate the value of x, whereas x::char(1) will. Likewise for NUMERIC precision/scale. The column length defaults of char(1) and numeric(30,6) are now inserted in analyze.c's processing of CREATE TABLE. Tom Lane 2000-01-20 02:24:50 +00:00
  • 08195a43f3 Fix bugs in NUMERIC ceil() and floor() functions. ceil(0) returned 1, and both would insert random junk digits if given an input that was an exact multiple of 10. Tom Lane 2000-01-20 02:21:44 +00:00
  • 6d1efd76fb Fix handling of NULL constraint conditions: per SQL92 spec, a NULL result from a constraint condition does not violate the constraint (cf. discussion on pghackers 12/9/99). Implemented by adding a parameter to ExecQual, specifying whether to return TRUE or FALSE when the qual result is really NULL in three-valued boolean logic. Currently, ExecRelCheck is the only caller that asks for TRUE, but if we find any other places that have the wrong response to NULL, it'll be easy to fix them. Tom Lane 2000-01-19 23:55:03 +00:00
  • 08fb7375e3 Update vacuum comments. Bruce Momjian 2000-01-19 22:23:00 +00:00
  • 2317e714c8 Update pg_dumpall. Bruce Momjian 2000-01-19 20:10:27 +00:00
  • 65e0051843 another round of user interface cleanups removed pg_id fixed a few bugs in the scripts Peter Eisentraut 2000-01-19 20:08:36 +00:00
  • ea1f6e00e6 autoconf Bruce Momjian 2000-01-19 17:27:04 +00:00
  • 0679a2c30e Fix >& csh-ism Bruce Momjian 2000-01-19 17:18:12 +00:00
  • 560e196bdd The latest source does not compile on Solaris 7 due to a missing include from a modified file. Bruce Momjian 2000-01-19 14:01:25 +00:00
  • 533d516629 Removed MBFLAGS from makefiles since it's now done in include/config.h. Peter Eisentraut 2000-01-19 02:59:03 +00:00
  • d4aab2c000 Revert back Makefile.global Add check for --with-mb. It is now obsoleted. Tatsuo Ishii 2000-01-19 01:42:12 +00:00
  • 8ff9f85bd5 Fix for multibyte support. Since some function declarations moved to miscadmin.h, we have to include it now. Tatsuo Ishii 2000-01-19 01:33:16 +00:00
  • f565cf41ab another set of cleanups Peter Eisentraut 2000-01-18 23:30:24 +00:00
  • 80c5fea99d Since this patch is not big I send it here instead. I do not have the complete source checked out so I cannot commit it myself. Bruce Momjian 2000-01-18 19:08:13 +00:00
  • 0cb6bc70ce Hi! Bruce Momjian 2000-01-18 19:05:31 +00:00
  • 2eebcddeaa Bruce, Bruce Momjian 2000-01-18 18:09:02 +00:00
  • 6c25ea2342 Fix minor comple error Tatsuo Ishii 2000-01-18 13:46:10 +00:00
  • 716fb90bf6 Fix minor comping errors Tatsuo Ishii 2000-01-18 13:44:48 +00:00
  • c80ba6a1b5 *** empty log message *** Michael Meskes 2000-01-18 13:03:49 +00:00
  • 4cd086ce43 Fix quoting bugs and incorrect trigger argument printout. Tom Lane 2000-01-18 07:29:58 +00:00
  • e1cce4d5ea This corrects an error in current gram.y for ALTER TABLE ... ADD CONSTRAINT Bruce Momjian 2000-01-18 06:12:03 +00:00