Age | Commit message (Collapse) | Author | |
---|---|---|---|
1999-08-21 | Major revision of sort-node handling: push knowledge of query | Tom Lane | |
sort order down into planner, instead of handling it only at the very top level of the planner. This fixes many things. An explicit sort is now avoided if there is a cheaper alternative (typically an indexscan) not only for ORDER BY, but also for the internal sort of GROUP BY. It works even when there is no other reason (such as a WHERE condition) to consider the indexscan. It works for indexes on functions. It works for indexes on functions, backwards. It's just so cool... CAUTION: I have changed the representation of SortClause nodes, therefore THIS UPDATE BREAKS STORED RULES. You will need to initdb. | |||
1999-08-21 | Cleanups for int8: guard against null inputs in comparison | Tom Lane | |
operators (and some other places), fix rangechecks in int8 to int4 conversion (same problem we recently figured out in pg_atoi). | |||
1999-08-21 | Ooops ... I had left some test coding in selfuncs.c that | Tom Lane | |
failed on 'field < textconstant' ... | |||
1999-08-09 | Store -1 in attdisbursion to signal 'no duplicates in column'. | Tom Lane | |
Centralize att_disbursion readout logic. | |||
1999-08-02 | Further selectivity-estimation work. Speed up eqsel() | Tom Lane | |
(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. | |||
1999-08-01 | First step in fixing selectivity-estimation code. eqsel and | Tom Lane | |
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. | |||
1999-07-22 | Alpha spinlock fix from Uncle George <gatgul@voicenet.com> | Bruce Momjian | |
1999-07-20 | Use -ieee alpha flag for gcc and egcs only. | Bruce Momjian | |
1999-07-20 | Re-add Makefile. | Bruce Momjian | |
1999-07-20 | Move -ieee to adt Makefile, and add CPU Makefile variable. | Bruce Momjian | |
1999-07-19 | Install new alignment code to use MAXALIGN rather than DOUBLEALIGN where | Bruce Momjian | |
approproate. | |||
1999-07-17 | Move some system includes into c.h, and remove duplicates. | Bruce Momjian | |
1999-07-17 | Fix for multi-byte includes. | Bruce Momjian | |
1999-07-16 | Final cleanup | Bruce Momjian | |
1999-07-16 | Final cleanup. | Bruce Momjian | |
1999-07-16 | Update #include cleanups | Bruce Momjian | |
1999-07-15 | Change #include's to use <> and "" as appropriate. | Bruce Momjian | |
1999-07-15 | Remove unused #includes in *.c files. | Bruce Momjian | |
1999-07-15 | Remove un-needed #include's from *.c files. | Bruce Momjian | |
1999-07-15 | Clean up #include in /include directory. Add scripts for checking includes. | Bruce Momjian | |
1999-07-14 | Cleanup of /include #include's, for 6.6 only. | Bruce Momjian | |
1999-07-13 | More cpu cleanups, only for 6.6. | Bruce Momjian | |
1999-07-10 | cleanup of long long int atoi test. | Bruce Momjian | |
1999-07-09 | Re-apply range check patch after fixing LIMIT_H test and defines. | Bruce Momjian | |
1999-07-09 | Another place that HAVE_LIMITS_H was misspelled. | Tom Lane | |
1999-07-09 | Fix for ACL length problem on different platforms. | Bruce Momjian | |
1999-07-09 | Backup pg_atoi patch for long checking. Caused initdb problems. | Bruce Momjian | |
1999-07-08 | > In both datetime_trunc() and timespan_trunc() in dt.c, | Bruce Momjian | |
> the DTK_MICROSEC case is just like the DTK_MILLISEC case. > I think this is wrong and it ought to look like > fsec = rint(fsec * 1000000) / 1000000; > no? Tom Lane. | |||
1999-07-08 | pg_atoi() does range check on int4 data only if | Bruce Momjian | |
"HAS_LONG_LONG" is defined based on the assumption that strtol() would return ERANGE if a platform does not support 64-bit integers. In current PostgreSQL 6.5 (and 6.4.2) distribution, "HAS_LONG_LONG" is defined only if platform is "alpha". (See include/port/alpha.h) I think the int4 range check should apply to linux_alpha as well. (I have not tested yet but I guess this might be applicable to newer Linux/i386 distributions which includes new GCC which implements long int as 64-bit int.) | |||
1999-07-04 | Clarify maximum tuple and max attribute lengths. | Bruce Momjian | |
1999-07-03 | Fix to prevent too large tuple from being created. | Bruce Momjian | |
1999-06-19 | Temporarily disable error checks for missing selectivity | Tom Lane | |
functions, in order to work around oversight in 6.5 release: rtree index functions haven't got any. Mea culpa ... | |||
1999-06-07 | Repair recently-introduced error in makeIndexable for LIKE: | Tom Lane | |
a non-leading % would be put into the >=/<= patterns. Also, repair longstanding confusion about whether %% means a literal %%. The SQL92 doesn't say any such thing, and textlike() knows that, but gram.y didn't. | |||
1999-06-02 | Changed "current." into "old." in rule string backparsing | Jan Wieck | |
Jan | |||
1999-06-02 | The INET and CIDR types mistakenly compared 198.68.123.0/24 and | Bruce Momjian | |
198.68.123.0/27 the same when indexing them. D'Arcy | |||
1999-05-31 | Generate a more specific error message when an operator used | Tom Lane | |
in an index doesn't have a restriction selectivity estimator. | |||
1999-05-26 | Make functions static or NOT_USED as appropriate. | Bruce Momjian | |
1999-05-25 | Another pgindent run. Sorry folks. | Bruce Momjian | |
1999-05-25 | Make 0x007f -> (unsigned)0x7f to make pgindent happy. | Bruce Momjian | |
1999-05-25 | pgindent run over code. | Bruce Momjian | |
1999-05-25 | Fixed bug in rules event qualification output. | Jan Wieck | |
Jan | |||
1999-05-25 | FIx for 0.0.0.0/0 output as 00/0. | Bruce Momjian | |
1999-05-19 | Remove 4096 string limited key on block size | Bruce Momjian | |
1999-05-12 | Fixed small bug in ruleutils and added output of pg_views and | Jan Wieck | |
pg_rules to rules regression test. Jan | |||
1999-05-12 | Replaced targetlist entry in GroupClause by reference number | Jan Wieck | |
in Resdom and GroupClause so changing of resno's doesn't confuse the grouping any more. Jan | |||
1999-05-12 | I am sorry, I misinterpreted the still failing trigger regression test. | Bruce Momjian | |
The offending code has been removed, the action is now always dependent :-) I suggest the following patch, to finally make trigger regression happy again: <<refint1.patch>> After that you can remove the following from TODO: Remove ERROR: check_primary_key: even number of arguments should be specified Trigger regression test fails Andreas | |||
1999-05-10 | Check for NUMERIC overflow a second time after rounding | Jan Wieck | |
Jan | |||
1999-05-10 | Change error messages to oids come out as %u and not %d. Change has no | Bruce Momjian | |
real affect now. | |||
1999-05-05 | I have two patches for 6.5.0: | Bruce Momjian | |
arrayfuncs.patch fixes a small bug in my previous patches for arrays array-regress.patch adds _bpchar and _varchar to regression tests -- Massimo Dal Zotto | |||
1999-05-04 | Use sprintf() to convert float8 to a string during conversion to numeric. | Thomas G. Lockhart | |
Original code used float8out(), but the resulting exponential notation was not handled (e.g. '3E9' was decoded as '3'). |