summaryrefslogtreecommitdiff
path: root/src/backend/utils
Commit message (Collapse)AuthorAgeFilesLines
* Check for NUMERIC overflow a second time after roundingJan Wieck1999-05-101-1/+14
| | | | Jan
* Fix initdb problem introduced by recent patch.Bruce Momjian1999-05-101-2/+2
|
* Change error messages to oids come out as %u and not %d. Change has noBruce Momjian1999-05-1013-58/+57
| | | | real affect now.
* Fix some miscellaneous places that were using raw open() orTom Lane1999-05-091-4/+4
| | | | fopen(), instead of going through fd.c ... naughty naughty.
* Update hash and join routines to use fd.c's new temp-fileTom Lane1999-05-091-158/+54
| | | | code, instead of not-very-bulletproof stuff they had before.
* I have two patches for 6.5.0:Bruce Momjian1999-05-051-2/+8
| | | | | | | | | | 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
* Use sprintf() to convert float8 to a string during conversion to numeric.Thomas G. Lockhart1999-05-041-5/+4
| | | | | Original code used float8out(), but the resulting exponential notation was not handled (e.g. '3E9' was decoded as '3').
* Correct declaration of array_map() so that it doesn't makeTom Lane1999-05-031-2/+2
| | | | gcc quite so unhappy.
* here are some patches for 6.5.0 which I already submitted but have neverBruce Momjian1999-05-033-15/+192
| | | | | | | | | | | | | | | | | | | | | | | | | | | | been applied. The patches are in the .tar.gz attachment at the end: varchar-array.patch this patch adds support for arrays of bpchar() and varchar(), which where always missing from postgres. These datatypes can be used to replace the _char4, _char8, etc., which were dropped some time ago. block-size.patch this patch fixes many errors in the parser and other program which happen with very large query statements (> 8K) when using a page size larger than 8192. This patch is needed if you want to submit queries larger than 8K. Postgres supports tuples up to 32K but you can't insert them because you can't submit queries larger than 8K. My patch fixes this problem. The patch also replaces all the occurrences of `8192' and `1<<13' in the sources with the proper constants defined in include files. You should now never find 8192 hardwired in C code, just to make code clearer. -- Massimo Dal Zotto
* Arrange for VACUUM to delete the init file that relcache.c usesTom Lane1999-05-011-17/+18
| | | | | | to save a little bit of backend startup time. This way, the first backend started after a VACUUM will rebuild the init file with up-to-date statistics for the critical system indexes.
* Fix compile failures in dt.c --- line broken in middle ofTom Lane1999-05-011-9/+7
| | | | an identifier :-(. Sloppy transmission of a patch, likely.
* Bugfix (bug by me in 1.4) in backparsing INSERT ... SELECTJan Wieck1999-04-291-2/+2
| | | | Jan
* Fix from Yutaka Tanida <yutaka@marin.or.jp> for Cygwin32 support.Tatsuo Ishii1999-04-263-6/+35
|
* Still had a few MULTIBYTE problems when client encoding wasTom Lane1999-04-251-3/+3
| | | | different from database's ...
* Correct potential infinite loop in pg_utf2wchar_with_len;Tom Lane1999-04-251-1/+6
| | | | | | it failed to cover the case where high bits of char are 100 or 101. Not sure if fix is right, but it agrees with pg_utf_mblen ... and it doesn't lock up ...
* ifdef out some unused routines to suppress gcc warnings.Tom Lane1999-04-251-1/+3
|
* Revise backend libpq interfaces so that messages to the frontendTom Lane1999-04-251-5/+14
| | | | | | can be generated in a buffer and then sent to the frontend in a single libpq call. This solves problems with NOTICE and ERROR messages generated in the middle of a data message or COPY OUT operation.
* Change elog(ERROR) to get back to main loop via a plain sigsetjmp,Tom Lane1999-04-201-15/+4
| | | | | | instead of doing a kill(self, SIGQUIT) and expecting the signal handler to do it. Also, clean up inconsistent definitions of the sigjmp buffer in the several files that already referenced it.
* Portability patches for HPUX 11 and Unixware in configureTom Lane1999-04-201-7/+2
| | | | | | and related files. Also remove float.c's gratuitous redeclaration of isinf() ... looks like there are more decls in there that ought to be in config.h, but I'll leave well enough alone for now ...
* Fix kill() call in elog() so that it gets its own pid by calling getpid().Tatsuo Ishii1999-04-161-2/+6
| | | | | | | 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.
* Fix max(int8) result by making sure int8larger() copies its resultThomas G. Lockhart1999-04-151-19/+2
| | | | | | | 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.
* Fix code to check legal dates *before* calling localtime() to get theThomas G. Lockhart1999-04-152-123/+43
| | | | | | | | 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-151-5/+5
| | | | | mis-copied "NULL", which happens to have the same binary value. Previously, gcc gave non-fatal warnings.
* Fix HEAP_MOVED_IN handling in HeapTupleSatisfiesDirty().Vadim B. Mikheev1999-04-121-7/+12
|
* Fix CREATE OPERATOR ... LANGUAGE 'internal', which I broke whileTom Lane1999-04-092-33/+38
| | | | making prosrc instead of proname be the link to the actual internal function.
* Version string was truncating the last character.Thomas G. Lockhart1999-04-061-2/+2
| | | | | Use memcpy() rather than StrNCpy() which had forced a string termination character at the end.
* Fix HEAP_MOVED_OFF handling in HeapTupleSatisfiesDirtyVadim B. Mikheev1999-04-051-1/+9
| | | | (may be used while vacuuming unique btree-s).
* Give a better error message if an SQL-language function isTom Lane1999-04-031-29/+69
| | | | | | 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.
* Modify fmgr so that internal name (compiler name) of a built-inTom Lane1999-03-292-32/+37
| | | | | | | | | | function is found in prosrc field of pg_proc, not proname. This allows multiple aliases of a built-in to all be implemented as direct builtins, without needing a level of indirection through an SQL function. Replace existing SQL alias functions with builtin entries accordingly. Save a few K by not storing string names of builtin functions in fmgr's internal table (if you really want 'em, get 'em from pg_proc...). Update opr_sanity with a few more cross-checks.
* 1. Vacuum is updated for MVCC.Vadim B. Mikheev1999-03-281-41/+95
| | | | | | | 2. Much faster btree tuples deletion in the case when first on page index tuple is deleted (no movement to the left page(s)). 3. Remember blkno of new root page in BTPageOpaque of left/right siblings when root page is splitted.
* Fix bogus function signature for areajoinsel.Tom Lane1999-03-281-13/+13
| | | | It still doesn't do anything, but at least now it does nothing correctly.
* Add KOI8/WIN/ALT supportTatsuo Ishii1999-03-242-37/+296
|
* These small utilities are for generating internal tables fromTatsuo Ishii1999-03-243-0/+198
| | | | rcode encoding tables.
* Hi,Bruce Momjian1999-03-221-2/+2
| | | | | | | | | | I have solved some problems with dynamic loading on NT. It is possible to run succesfully both trigger and plpgsql regression tests. The patch is in the included file "diff". Dan
* Cleanup of NULL in inet types.Bruce Momjian1999-03-222-71/+81
|
* This patch fixes the bug that made it impossible to grant permissions toBruce Momjian1999-03-211-10/+29
| | | | | | a user such as "www-data". Oliver
* cleanupBruce Momjian1999-03-201-2/+2
|
* cleanupsBruce Momjian1999-03-181-2/+1
|
* Add new postgres -O option to allow system table structure changes.Bruce Momjian1999-03-171-2/+3
|
* Fix snprintf with strings, and nextval('"Aa"');Bruce Momjian1999-03-161-1/+1
|
* LIKE cleanup.Bruce Momjian1999-03-151-12/+26
|
* Fix brain death in !!= operator ... it's still pretty bogusTom Lane1999-03-151-23/+30
| | | | but at least now it does what it's supposed to do ...
* > > > This patches src/bin/psql/psql.c.Bruce Momjian1999-03-151-9/+9
| | | | | | | > > > > > > This patch is in responce to the following TODO list item: > > > * have psql \d on a view show the query > > > -Ryan
* src/backend/utils/adt/numeric.c fails to compile due to a string havingBruce Momjian1999-03-141-3/+3
| | | | | | | | an embedded new-line character. Billy G. Allie
* Attempting to insert a value of 'now' into a datetime typeBruce Momjian1999-03-141-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | results in a bogus datetime value under AlphaLinux. (Note that the link to submit a port-specific bug on your website is broken) -Test Case: ---------- testdb=> create table dttest (dt datetime); testdb=> insert into dttest values ('now'); -------------------------------------------------------------------------- Solution: --------- The basic problem is the typedefs of AbsoluteTime and RelativeTime, which are both 'int32'. These types appear to be used synonymously with the 'time_t' type, which on AlphaLinux is typedef'd as a 'long int', which is 64-bits (not 32). The solution included here fixes the datetime type (it now passes the regression test), but does not pass the absolute and relative time regression tests. Presumably, a more thorough investigation of how these types are used is warranted. The included patch is from the v6.3.2 source, but can be applied to the v6.4.2 source. Please note that there is also a RedHat-specific patch distributed with the PostgreSQL source package from RedHat that was applied first. Rich Edwards
* Here is a little syntax error found in a .y file... A dropped semi.Bruce Momjian1999-03-141-9/+1
| | | | | | DwD -- Daryl W. Dunbar
* We have tested the patches on three platforms:Bruce Momjian1999-03-141-2/+2
| | | | | | | | | | | | | NetBSD/macppc LinuxPPC FreeBSD 2.2.6-RELEASE All of them seem happy with the regression test. Note that, however, compiling with optimization enabled on NetBSD/macppc causes an initdb failure (other two platforms are ok). After checking the asm code, we are suspecting that might be a compiler(egcs) bug. Tatsuo Ishii
* Modify mcxt.h so that it doesn't pull in half of creation.Tom Lane1999-03-071-1/+2
|
* A few further tweaks to shared memory space estimation.Tom Lane1999-03-061-9/+17
| | | | | This change brings the default size of the main shmem block back under 1MB, which is a fairly popular value for the kernel's SHMMAX parameter.
* Thank you for the advice. I concluded that current inet code has aBruce Momjian1999-02-241-2/+7
| | | | | | | | portability problem. Included patches should be applied to both current and 6.4 tree. I have tested on LinuxPPC, FreeBSD and Solaris 2.6. Now the inet regression tests on these platforms are all happy. --- Tatsuo Ishii
View Lorry Controller Status