summaryrefslogtreecommitdiff
path: root/src/backend/utils
AgeCommit message (Collapse)Author
2002-05-14Remove unnecessary pfree's in geometric operators. At least one of theseTom Lane
is actively dangerous, per bug report from Ewald Geschwinde 14-May-02, and several of the rest look suspicious to me. Since there is no longer any significant value in retail pfree's in these functions, just get rid of all of them for safety's sake.
2002-03-17Backpatch array I/O code and documentation fixes, also array sliceTom Lane
lower subscript bounds change.
2002-03-15Repair bad calculation in timetz_izone() which gave erroneous results.Thomas G. Lockhart
Will be patched separately but equivalently in HEAD for 7.3.
2002-03-05A backport patch:Tatsuo Ishii
Fix bug in extract/date_part for milliseconds/miscroseconds and timestamp/timestamptz combo. Now extract/date_part returns seconds*1000 or 1000000 + fraction part as the manual stats. regression test are also fixed. See the thread in pgsql-hackers: Subject: Re: [HACKERS] timestamp_part() bug? Date: Sat, 02 Mar 2002 11:29:53 +0900
2002-02-25Add a large number of time zones to the lookup table.Thomas G. Lockhart
Fix a few apparently-wrong TZ vs DTZ declarations. Same patch as added to HEAD.
2002-02-19Avoid failures in cash_out and cash_words for INT_MIN.Tom Lane
Also, 'fourty' -> 'forty'.
2002-02-14Ensure that a cursor is scanned under the same scanCommandId it wasTom Lane
originally created with, so that the set of visible tuples does not change as a result of other activity. This essentially makes PG cursors INSENSITIVE per the SQL92 definition. See bug report of 13-Feb-02.
2002-02-08Move sys/types.h to top, for hiroyuki hanai/ FreeBSD.Bruce Momjian
2002-01-16Fix misstatements added by Bruce.Tom Lane
2002-01-16Add more comments to tqual.c for visibility functions.Bruce Momjian
2002-01-16TOAST needs to do at least minimal time-qual checking in order not toTom Lane
mess up after an aborted VACUUM FULL, per today's pghackers discussion. Add a suitable HeapTupleSatisfiesToast routine. Remove useless special- case test in HeapTupleSatisfiesVisibility macro for xmax = BootstrapTransactionId; perhaps that was needed at one time, but it's a waste of cycles now, not to mention actively wrong for SnapshotAny. Along the way, add some much-needed comments to tqual.c, and simplify toast_fetch_datum, which no longer needs to assume it may see chunks out-of-order.
2002-01-16Fix init_irels to close the pg_internal.init file before returning.Tom Lane
This saves one open file descriptor per backend, and avoids an annoying NOTICE on Cygwin (which has trouble deleting open files). Bug appears to date back to original coding of init_irels, circa 1992.
2002-01-15If we fail to rename pg_internal.init into place, delete the uselessTom Lane
temporary file. This seems to be a known failure mode under Cygwin, so we might as well expend the extra line of code to be tidy.
2002-01-12Repair bugs in declarations of routines to add timestamptz and interval.Thomas G. Lockhart
Thanks to Bruce for spotting it and Tom Lane for diagnosing it. Since horology test output is changing anyway, add some date/time input tests to horology.sql. Some of these should move to the tests for the individual data types, and we perhaps should add an entire new test for "timezone" to allow manipulating the current time zone without risking damage to the results of other tests.
2002-01-11VACUUM must make sure that a HEAP_MARKED_FOR_UPDATE tuple gets markedTom Lane
as either HEAP_XMAX_COMMITTED or HEAP_XMAX_INVALID once the updating transaction is gone. Otherwise some other transaction may come along and try to test the commit status of t_xmax later --- which could be after VACUUM has recycled the CLOG status for that xact. Bug introduced in post-beta4 bug fix.
2002-01-09Fix use of 'char' to hold result of getc, per bug report forwarded byTom Lane
Oliver Elphick. A few other minor cleanups while at it.
2002-01-08Fix lpad() and rpad() to produce correct results in variable-lengthTom Lane
multibyte encodings.
2002-01-06Add CHECK_FOR_INTERRUPTS() in various strategic spots, per commentsTom Lane
from Hiroshi.
2002-01-04Have to_date() call timestamptz_date() per Karel's email instructions.Thomas G. Lockhart
Fixes time zone problems introduced by Thomas' implementation of TIMESTAMP WITHOUT TIME ZONE which caused the behavior of the previously appropriate routine, timestamp_date(), to change for the worse in this context.
2002-01-04Replace #ifdef, #endif with # requires comment.Bruce Momjian
2002-01-03Guard against roundoff errors in new selectivity-estimation code,Tom Lane
per bug report from Laurette Cisneros.
2002-01-02Fix to_timestamp/to_date so that zero year input for Y, YY, or YYYTom Lane
formats will be taken as 2000, not year zero. Per bug report from Aasmund Midttun Godal. Fix from Karel Zak.
2002-01-01Rename TIME token to ISOTIME to eliminate conflict with gram.y parserThomas G. Lockhart
token. Seems to be isolated to datetime.c and datetime.h.
2001-12-30Make sure that all <ctype.h> routines are called with unsigned charTom Lane
values; it's not portable to call them with signed chars. I recall doing this for the last release, but a few more uncasted calls have snuck in.
2001-12-29Fix newly introduced datetime.c compile failure; not enough parens.Bruce Momjian
2001-12-29Check a bit more carefully for preceeding ISO field tagsThomas G. Lockhart
when decoding date fields.
2001-12-29Rework the date/time parsing to tighten up some cases and to enable otherThomas G. Lockhart
cases which should have worked but did not. Now supports julian day (J2452271), ISO time labels (T040506) and various combinations of spaces and run-togethers of dates, times, and time zones. All regression tests pass, and I have more tests to add after the 7.2 release (don't want to require changes to the ancillary horology result files until after then).
2001-12-21Use MemSet() rather than a loop to do blank-padding on PS_USE_CLOBBER_ARGVTom Lane
machines. I have just been observing some scenarios where set_ps_display accounts for more than 10% of the backend CPU, and this loop has to be the reason.
2001-12-21Add full name of the month of July to the lookup table.Thomas G. Lockhart
Thanks to Greg Sabino Mullane <greg@turnstep.com> for finding the problem.
2001-12-19Make sure that all variants of HeapTupleSatisfies will do the right thingTom Lane
if presented with a tuple in process of being moved by VACUUM. Per bug report from Brian Hirt.
2001-12-17Move geqo enable into proper section.Bruce Momjian
2001-12-11Repair roundoff-error problem for stddev/variance results near zero,Tom Lane
per complaint from Kemin Zhou. Fix lack of precision in numeric stddev/variance.
2001-12-10Repair case-conversion error in to_date's handling of roman numerals.Tom Lane
From Manuel Sugawara, approved by Karel Zak.
2001-12-05Fix for usage of spirntf in more portable way.Tatsuo Ishii
2001-11-29Fix array_out's failure to backslash backslashes, per bug# 524. Also,Tom Lane
remove brain-dead rule that double quotes are needed if and only if the datatype is pass-by-reference; neither direction of the implication holds water. Instead, examine the actual data string to see if it contains any characters that force us to quote it. Add some documentation about quoting of array values, which was previously explained nowhere AFAICT.
2001-11-26Change display of FieldSelect nodes from arg.field to field(arg),Tom Lane
per bug report from Stefan Hadjistoytchev. There are some cases where the dot notation works, but there are more where it doesn't. Eventually ought to consider fixing the parser to allow cases like func().field, but for now this is the simplest patch.
2001-11-26Repair problem with listing rules that have a WHERE condition andTom Lane
have an INSERT...SELECT as the first or only action. Per bug report from Sergio Pili.
2001-11-24Tweak int8in to accept -9223372036854775808, per recent discussion inTom Lane
pgsql-patches.
2001-11-21Spell 'precedes', 'preceding' correctly in various places.Tom Lane
2001-11-21Tweak interval_avg support to avoid coredump with Alpha/Tru64 compiler.Tom Lane
Per report from Bernd Tegge.
2001-11-21Add a few new time zones, and list every time zone mentioned in myThomas G. Lockhart
Linux box's time zone database. Do not allow 'current' as a date/time input value.
2001-11-21Repair swapped sign for time minus time routine (time_mi_time()).Thomas G. Lockhart
Problem reported by Manuel Sugawara (masm@fciencias.unam.mx).
2001-11-20Simplify pg_convert() in that it calls pg_convert2 using new fmgr interface.Tatsuo Ishii
2001-11-19Tweak format_type so that we get good behavior for both column typeTom Lane
display (with a typemod) and function arg/result type display (without a typemod).
2001-11-19Fix arg coerect match text type, per Tom.Bruce Momjian
2001-11-19Make text octet_length() return non-compressed length to be consistentBruce Momjian
with other data types, per disucssion. Encoding issue still open.
2001-11-19Grammatical and spelling fixes.Tom Lane
2001-11-19Fix nasty bugs in pg_convert() and pg_convert2().Tatsuo Ishii
o they sometimes returns a result garbage string appended. o they do not work if client encoding is different from server encoding
2001-11-18Optimization for bpcharlen, textlen, varcharlen in case of single byteTatsuo Ishii
encodings.
2001-11-17Fix performance problems in TOAST compressor. The management ofTom Lane
search lists was broken in such a way that only the most recent instance of a given hash code would ever be searched, thus possibly missing longer matches further back. Fixing this gave 5 to 10% compression improvement on some text test cases. Additional small tweaks to improve speed of inner loops a little bit. There is no compatibility issue created by this change, since the compressed data format and decompression algorithm don't change.
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-31 22:31:53 +0000