aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* After transforming a CASE expr with a default argument,Tom Lane1999-04-18
| | | | | | | | delete the default argument from the node. This prevents the executor from spitting up on the untransformed argument expression. Typical failure was: select (case f1 when 'val' then 'subst' else f1 end) from t1; ERROR: copyObject: don't know how to copy 704
* Update CREATE FUNCTION's on-line help in psql.Tom Lane1999-04-18
|
* Allow CREATE FUNCTION xyz AS '' LANGUAGE 'internal' toTom Lane1999-04-18
| | | | | | work the way it used to (ie, assume xyz is the name of the builtin function to call). Complain if an unknown builtin function name is referenced.
* Add res checking to libpq examples, from Dan Merillat.Bruce Momjian1999-04-17
|
* Add missing function prototypes to stifle gcc warnings.Tom Lane1999-04-16
|
* *** empty log message ***Michael Meskes1999-04-16
|
* Fix kill() call in elog() so that it gets its own pid by calling getpid().Tatsuo Ishii1999-04-16
| | | | | | | MyProcPid global variable is set to 0 when postgres starts as a command (not as a backend daemon). This leads issuing SIGQUIT to the process group, not the process itself. As a result, parent sh gets core dumped in the Wisconsin benchmark test.
* Overhaul Wisconsin Benchmark test suitTatsuo Ishii1999-04-16
| | | | | | | - change temp -> temp_bench ("temp" is now a reserved word) - fix bugs in queries - add -B 256 option to run the postgres command (without this, postgres seems to fail with hashjoin)
* Improve error messages when a connection is rejected.Tom Lane1999-04-16
|
* Fix max(int8) result by making sure int8larger() copies its resultThomas G. Lockhart1999-04-15
| | | | | | | rather than reusing the input storage. Also made the same fix to int8smaller(), though there wasn't a symptom, and went through and verified that other pass-by-reference data types do the same thing. Not an issue for the by-value types.
* Initialize reltuples = 1000, relpages = 10 in a newly createdTom Lane1999-04-15
| | | | | | | | | | relation, rather than zeroes. This prevents the optimizer from making foolish choices (ie, using nested-loop plans) on never-yet-vacuumed tables. This is a hack, of course. Keeping accurate track of these statistics would be a cleaner solution, but it's far from clear that it'd be worth the cost of doing so. In any case we're not going to do that for 6.5. In the meantime, this quick hack provides a useful performance improvement in the regression tests and in many real-world scenarios.
* Add ORDER BY clauses to some select-from-view operationsTom Lane1999-04-15
| | | | | | | | in rules regression test, in order to eliminate bogus test 'failures' that occur due to platform-dependent and join-implementation-dependent ordering of tuples. I'm not sure that I got all of the SELECTs that need ordering clauses --- we may need some more. But this takes care of the diffs between my platform and Jan's.
* psql did the wrong thing with COPY FROM STDIN inside a fileTom Lane1999-04-15
| | | | | | | sourced with \i (tried to read data from the terminal, rather than from the source file; this breaks pg_dump scripts read with \i). Also, \o file followed by COPY TO STDOUT wrote to terminal not designated file. All better now.
* Move some useful date/time test macros to here to allowThomas G. Lockhart1999-04-15
| | | | sharing across files.
* Declare hashint8().Thomas G. Lockhart1999-04-15
|
* Fix code to check legal dates *before* calling localtime() to get theThomas G. Lockhart1999-04-15
| | | | | | | | time zone. Previously, localtime() rotated a date with a day of month field which exceeded the actual range into the next months, masking the fact that a bad date had been specified. Regression tests pass.
* Fix boolean assignment of return values to use "FALSE" rather than theThomas G. Lockhart1999-04-15
| | | | | mis-copied "NULL", which happens to have the same binary value. Previously, gcc gave non-fatal warnings.
* Code modified to reject out of range day of month.Thomas G. Lockhart1999-04-15
| | | | | | | Previously, dates falling within Unix system time range were run through a call to localtime() to get the time zone, if it was not specified. This had the effect that dates with DOMs which were larger than would be valid for that month were "rotated" into the following months.
* Fix error message to match that returned by new regression test referenceThomas G. Lockhart1999-04-15
| | | | machine (linux-2.0.36 RH5.2 with RH5.2 patches).
* Correct documentation of CREATE OPERATOR.Tom Lane1999-04-15
|
* Correct psql's online help for CREATE OPERATOR, which didTom Lane1999-04-14
| | | | not match what the backend actually accepts.
* pg_dump was trying to use an incorrect (or, perhaps, only obsolete?)Tom Lane1999-04-14
| | | | | | syntax for CREATE OPERATOR with SORT parameters. Fixed. It is now actually possible to dump and reload a database containing fully specified user-definable operators ...
* *** empty log message ***Michael Meskes1999-04-14
|
* use new config.guess output for system specific expected files ..Marc G. Fournier1999-04-14
|
* use config.guess instead of uname -s to figure out system, so that we canMarc G. Fournier1999-04-14
| | | | | | include platform spcific changes ... thanks to Mark Hollomon <mhh@nortelnetworks.com> for the awk script used
* Fix adding columns to a temp table.Bruce Momjian1999-04-13
|
* Add ARM32 support by Andrew McMurryBruce Momjian1999-04-13
|
* array_in is defined in the system catalog as taking two arguments while itBruce Momjian1999-04-13
| | | | | | actually takes three. Please apply the following patch. Massimo
* There are some bugs about backward scanning usingBruce Momjian1999-04-13
| | | | | | | | | | | | | | | indexes. 1. Index Scan using plural indexids never scan backward as to the order of indexids. 2. The cursor using Index scan is not usable after moving past the end. This patch solves above bugs. Moreover the change of _bt_first() would be useful to extend ORDER BY patch by Jan Wieck for all descending order cases. Hiroshi Inoue
* *** empty log message ***Michael Meskes1999-04-13
|
* Fix HEAP_MOVED_IN handling in HeapTupleSatisfiesDirty().Vadim B. Mikheev1999-04-12
|
* Some comments...Vadim B. Mikheev1999-04-12
|
* Unique btree-s:Vadim B. Mikheev1999-04-12
| | | | | | | /* * Have to check is inserted heap tuple deleted one * (i.e. just moved to another place by vacuum)! */
* add mipsel-unknown-linux-gnu support. config.guess seems slightly changedTatsuo Ishii1999-04-12
| | | | since April 1?
* Implement UpdateCountPeter Mount1999-04-11
|
* Repair problems seen when CREATE OPERATOR mentions aTom Lane1999-04-11
| | | | | | | | not-yet-defined operator in commutator, negator, etc links. This is necessary in order to ensure that a pg_dump dump of user-defined operators can be reloaded. There may still be a bug lurking here, because it's provoking a 'Buffer Leak' notice message in one case. See my mail to pgsql-hackers.
* Fix another batch of bogosities in pg_operator table.Tom Lane1999-04-10
| | | | | These were bogus selectivity-estimator links, like a '>' operator pointing to intltsel when it should use intgtsel.
* Tweak create_operator regress test so it doesn't illustrateTom Lane1999-04-10
| | | | incorrect usage of commutator link.
* Fix CREATE OPERATOR ... LANGUAGE 'internal', which I broke whileTom Lane1999-04-09
| | | | making prosrc instead of proname be the link to the actual internal function.
* Fix some more hashjoin-related bugs in pg_operator. FixTom Lane1999-04-07
| | | | | | | hashjoin's hashFunc() so that it does the right thing with pass-by-value data types (the old code would always return 0 for int2 or char values, which would work but would slow things down a lot). Extend opr_sanity regress test to catch more kinds of errors.
* Unmark 'hashable' operators that can't really be used forTom Lane1999-04-07
| | | | hashjoins. Extend opr_sanity regress test to help detect similar mistakes.
* Version string was truncating the last character.Thomas G. Lockhart1999-04-06
| | | | | Use memcpy() rather than StrNCpy() which had forced a string termination character at the end.
* On reflection, filesize limit ought to be an exact powerTom Lane1999-04-06
| | | | of 2 to save a few cycles in md.c. So, make it 2^30 not 10^9.
* Reduce default file size limit to 1Gb, and move theTom Lane1999-04-05
| | | | configuration constant to config.h.
* Fix HEAP_MOVED_OFF handling in HeapTupleSatisfiesDirtyVadim B. Mikheev1999-04-05
| | | | (may be used while vacuuming unique btree-s).
* Fix potential overflow problems when relation size exceedsTom Lane1999-04-05
| | | | | 2gig. Fix failure to reliably put the smaller relation on the inside of a hashjoin.
* We use CFLAGS = -O2 on every other gcc platform, so why notTom Lane1999-04-04
| | | | hpux_gcc too?
* Use MAXALIGN value found by configure instead of aTom Lane1999-04-04
| | | | hardwired assumption.
* Give a better error message if an SQL-language function isTom Lane1999-04-03
| | | | | | called through fmgr. Someday we should try to actually execute the function, but that looks like it might be a major feature addition. Not something to try during beta phase.
* Fix bogus pg_amop entries for int8 hash, cidr btree,Tom Lane1999-04-03
| | | | polygon rtree, circle rtree indexes.