summaryrefslogtreecommitdiff
path: root/src/backend/utils/adt
AgeCommit message (Collapse)Author
1999-06-02Changed "current." into "old." in rule string backparsingJan Wieck
Jan
1999-06-02The INET and CIDR types mistakenly compared 198.68.123.0/24 andBruce Momjian
198.68.123.0/27 the same when indexing them. D'Arcy
1999-05-31Generate a more specific error message when an operator usedTom Lane
in an index doesn't have a restriction selectivity estimator.
1999-05-26Make functions static or NOT_USED as appropriate.Bruce Momjian
1999-05-25Another pgindent run. Sorry folks.Bruce Momjian
1999-05-25Make 0x007f -> (unsigned)0x7f to make pgindent happy.Bruce Momjian
1999-05-25pgindent run over code.Bruce Momjian
1999-05-25Fixed bug in rules event qualification output.Jan Wieck
Jan
1999-05-25FIx for 0.0.0.0/0 output as 00/0.Bruce Momjian
1999-05-19Remove 4096 string limited key on block sizeBruce Momjian
1999-05-12Fixed small bug in ruleutils and added output of pg_views andJan Wieck
pg_rules to rules regression test. Jan
1999-05-12Replaced targetlist entry in GroupClause by reference numberJan Wieck
in Resdom and GroupClause so changing of resno's doesn't confuse the grouping any more. Jan
1999-05-12I 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-10Check for NUMERIC overflow a second time after roundingJan Wieck
Jan
1999-05-10Change error messages to oids come out as %u and not %d. Change has noBruce Momjian
real affect now.
1999-05-05I 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-04Use 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').
1999-05-03Correct declaration of array_map() so that it doesn't makeTom Lane
gcc quite so unhappy.
1999-05-03here are some patches for 6.5.0 which I already submitted but have neverBruce Momjian
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
1999-05-01Fix compile failures in dt.c --- line broken in middle ofTom Lane
an identifier :-(. Sloppy transmission of a patch, likely.
1999-04-29Bugfix (bug by me in 1.4) in backparsing INSERT ... SELECTJan Wieck
Jan
1999-04-26Fix from Yutaka Tanida <yutaka@marin.or.jp> for Cygwin32 support.Tatsuo Ishii
1999-04-20Portability patches for HPUX 11 and Unixware in configureTom Lane
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 ...
1999-04-15Fix max(int8) result by making sure int8larger() copies its resultThomas G. Lockhart
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.
1999-04-15Fix code to check legal dates *before* calling localtime() to get theThomas G. Lockhart
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.
1999-04-15Fix boolean assignment of return values to use "FALSE" rather than theThomas G. Lockhart
mis-copied "NULL", which happens to have the same binary value. Previously, gcc gave non-fatal warnings.
1999-04-06Version string was truncating the last character.Thomas G. Lockhart
Use memcpy() rather than StrNCpy() which had forced a string termination character at the end.
1999-03-28Fix bogus function signature for areajoinsel.Tom Lane
It still doesn't do anything, but at least now it does nothing correctly.
1999-03-22Cleanup of NULL in inet types.Bruce Momjian
1999-03-21This patch fixes the bug that made it impossible to grant permissions toBruce Momjian
a user such as "www-data". Oliver
1999-03-20cleanupBruce Momjian
1999-03-18cleanupsBruce Momjian
1999-03-15LIKE cleanup.Bruce Momjian
1999-03-15Fix brain death in !!= operator ... it's still pretty bogusTom Lane
but at least now it does what it's supposed to do ...
1999-03-15> > > This patches src/bin/psql/psql.c.Bruce Momjian
> > > > > > This patch is in responce to the following TODO list item: > > > * have psql \d on a view show the query > > > -Ryan
1999-03-14src/backend/utils/adt/numeric.c fails to compile due to a string havingBruce Momjian
an embedded new-line character. Billy G. Allie
1999-03-14Attempting to insert a value of 'now' into a datetime typeBruce Momjian
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
1999-03-14Here is a little syntax error found in a .y file... A dropped semi.Bruce Momjian
DwD -- Daryl W. Dunbar
1999-03-14We have tested the patches on three platforms:Bruce Momjian
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
1999-02-24Thank you for the advice. I concluded that current inet code has aBruce Momjian
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
1999-02-21From: Tatsuo Ishii <t-ishii@sra.co.jp>Marc G. Fournier
Ok. I made patches replacing all of "#if FALSE" or "#if 0" to "#ifdef NOT_USED" for current. I have tested these patches in that the postgres binaries are identical.
1999-02-15regprocin should accept '-' signifying InvalidOid, forTom Lane
symmetry with regprocout.
1999-02-13Change my-function-name-- to my_function_name, and optimizer renames.Bruce Momjian
1999-02-13Fix offset of one for date_part(timespan) when given arguments ofThomas G. Lockhart
decade, century, or millenium.
1999-02-13Change #if FALSE to #if NOT_USED to avoid port problems.Thomas G. Lockhart
Fix problem with date_part() for timespan (had an offset of one) when given decade, century, and millenium as arguments. Reported by Ricardo J.C.Coelho.
1999-02-13Add routines to convert between int8 and text/varchar types.Thomas G. Lockhart
Change #if FALSE to #if NOT_USED to avoid port problems. Fix up pg_indent weirdness with function argument declarations.
1999-02-05Fix for returning stack pointer from selectivity, from Bernard Frankpitt.Bruce Momjian
1999-02-03Cleanup of source files where 'return' or 'var =' is alone on a line.Bruce Momjian
1999-02-03Modify int8 to not depend on sscanf(), and fix configure's testTom Lane
for int8 support. configure now checks only snprintf() for int8 support, not sprintf and sscanf as it used to. The reason for doing this is that if we are supplying our own snprintf code (which does handle long long int), we now only need working long long support in the compiler not in the platform's C library. I have verified that int8 now passes regression test on HPUX 9, and I think it should work on SunOS 4.1.* and other older platforms if gcc is used.
1999-01-25Agg/Aggreg cleanup and datetime.sql patch.Bruce Momjian