summaryrefslogtreecommitdiff
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-05-14Fix bug in pg_dump and psql (to reproduce the bug, just try pg_dumpTatsuo Ishii
--nonexistingoption). per report from sugita@sra.co.jp on Thu, 09 May 2002 11:57:51 +0900 (JST) at pgsql-patches list. Illegal long options to pg_dump makes core on some systems, since it lacks the last null sentinel of struct option array. Attached is a patch made by Mr. Ishida Akio <iakio@pjam.jpweb.net>.
2002-05-05plpgsql_dstring_append was broken for long strings.Tom Lane
2002-05-01Change heap_get_latest_tid() so that a transaction canHiroshi Inoue
see changes made by the transaction itself.
2002-04-08A backport patch.Tatsuo Ishii
Fix PQescapeBytea/PQunescapeBytea so that they handle bytes > 0x7f. This is necessary for mulibyte character sequences. See "[HACKERS] PQescapeBytea is not multibyte aware" thread posted around 2002/04/05 for more details.
2002-04-02Fix CLOG truncation code to not do the Wrong Thing when there are alreadyTom Lane
wrapped-around databases. The unvacuumed databases might be fine, or they might not, but things will definitely not be fine if we remove the wrong CLOG segments. Per trouble report from Gary Wolfe, 1-Apr-2002.
2002-03-26Update release list.REL7_2_1Bruce Momjian
2002-03-26Update sgml version properly.Bruce Momjian
2002-03-25New wording:Bruce Momjian
Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom)
2002-03-25Add to HISTORY:Bruce Momjian
Allow CREATE TABLE AS ... SELECT in PL/PgSQL (Tom)
2002-03-25Re-allow CREATE AS (but not SELECT INTO) in EXECUTE.Tom Lane
2002-03-21Remove long-dead 'fix for SELECT NULL' to stop current coredump.Tom Lane
2002-03-19> > Users of contrib/tsearch needs after upgrading of module (compiling, ↵Bruce Momjian
installing) > > to perform sql command: > > update pg_amop set amopreqcheck = true where amopclaid = > > (select oid from pg_opclass where opcname = 'gist_txtidx_ops'); > > Oleg, sorry, I don't understand where this should appear. In the README > file, and if so, where? Is this something only for people upgrading > from 7.2? Sorry Bruce, I was unclear. I have attached patch to Readme.tsearch Also, It'd be worth to mention in Changes to point users of tsearch about importang upgrade notices. Oleg Bartunov
2002-03-19Improve wording of bug fix:Bruce Momjian
Ensure that sequence counters do not go backwards after a crash
2002-03-18Update for 7.2.1.Bruce Momjian
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-15Repair two problems with WAL logging of sequence nextvalI() ops, asTom Lane
per recent pghackers discussion: force a new WAL record at first nextval after a checkpoint, and ensure that xlog is flushed to disk if a nextval record is the only thing emitted by a transaction.
2002-03-13Update FAQ for 7.2.1.Bruce Momjian
2002-03-11Pleas apply it for 7.2.1 and current CVS.Bruce Momjian
Patch fixes using lc.lang instead of lc.lc_ctype. Teodor Sigaev
2002-03-09Guard against NULL strings in SET key=val constructs.Thomas G. Lockhart
Problem noted by Fernando Nasser.
2002-03-05Please, apply attached patch for contrib/tsearch to 7.2.1 and currentBruce Momjian
CVS. It fix english stemmer's problem with ending words like 'technology'. We have found one more bug in english stemmer. The bug is with 'irregular' english words like 'skies' -> 'sky'. Please, apply attached cumulative patch to 7.2.1 and current CVS instead previous one. Thank to Thomas T. Thai <tom@minnesota.com> for hard testing. This kind of bug has significance only for dump/reload database and viewing, but searching/indexing works right. Teodor Sigaev
2002-03-05Previous patch to mark UNION outputs with common typmod (if any) breaksTom Lane
three-or-more-way UNIONs, as per example from Josh Berkus. Cause is a fragile assumption that one tlist's entries will exactly match another. Restructure code to make that assumption a little less fragile.
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-03-04Update FAQ_Solaris with info about gcc 2.95.1 problems and how to workTom Lane
around 64-bit vsnprintf bug.
2002-02-27Back-patch fix for errors reported at transaction end.Tom Lane
2002-02-27Back-patch fix for followings:Tatsuo Ishii
Fix bug in COPY FROM when DELIMITER is not in ASCII range. See pgsql-bugs/pgsql-hackers discussion "COPY FROM is not 8bit clean" around 2002/02/26 for more details -- Tatsuo Ishii
2002-02-26Back-patch fix for command completion report handling. This isTom Lane
primarily needed so that INSERTing a row still reports the row's OID even when there are ON INSERT rules firing additional queries.
2002-02-25Tweak psql's \connect command to not downcase unquoted database and userTom Lane
names. This is a temporary measure to allow backwards compatibility with 7.2 and earlier pg_dump. 7.2.1 and later pg_dump will double-quote mixed case names in \connect. Once we feel that older dumps are not a problem anymore, we can revert this change and treat \connect arguments as normal SQL identifiers.
2002-02-25Fix for PAM error message display:Bruce Momjian
> and that the right fix is to make each of the subsequent calls be in > this same pattern, not to try to emulate their nonsensical style. Dominic J. Eidson
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-22We had a problem with to compile pgsql-7.2 under SW-8.0.Bruce Momjian
In the mailing lists I found no informations. See note for further informations. Add missing AuthBlockSig. regards Heiko
2002-02-22BACKPATCH:Bruce Momjian
Add Russian FAQ to 7.2.1. Why not?
2002-02-22BACKPATCH:Bruce Momjian
Please, apply attached patch of contrib/btree_gist to 7.2.1 and current cvs. The patch fixes memory leak during creation GiST index on timestamp column. Thank you. -- Teodor Sigaev teodor@stack.net
2002-02-19Avoid failures in cash_out and cash_words for INT_MIN.Tom Lane
Also, 'fourty' -> 'forty'.
2002-02-18Replace number-of-distinct-values estimator equation, per recentTom Lane
pghackers discussion.
2002-02-18Fix kanji-coversion key binding. This has been broken since 7.1Tatsuo Ishii
Per Yoshinori Ariie's report.
2002-02-17Fix SGML typo in previous patch.Bruce Momjian
2002-02-17I think it's important that it's actually documented that they can addBruce Momjian
primary keys after the fact! Also, we need to add regression tests for alter table / add primary key and alter table / drop constraint. These shouldn't be added until 7.3 tho methinks... Chris
2002-02-16Clarify params to ALTER TABLE to clearly show single parameters.Bruce Momjian
e.g. table contraint definition -> table_constraint_definition.
2002-02-15Remove warning about automatic inclusion of sqlca.Peter Eisentraut
2002-02-14Update FAQ.Bruce Momjian
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-13Point out that --adduser actually makes the new user a superuser. ThisTom Lane
was mentioned on the man page for the underlying CREATE USER command, but it should be explained here too.
2002-02-13Add DROP COLUMN status from Hiroshi.Bruce Momjian
2002-02-12Use RTLD_NOW, not RTLD_LAZY, as binding mode for dlopen() on all platforms.Tom Lane
This restores the Linux behavior to what it was in PG 7.0 and 7.1, and causes other platforms to agree. (Other well-tested platforms like HPUX were doing it this way already.) Per pghackers discussion over the past month or so.
2002-02-12Add warning not to use /usr/ucb/cc on Solaris.Tom Lane
2002-02-12Fix tutorial for references problem, from rainer.tammer@spg.schulergroup.comBruce Momjian
2002-02-12Clarify working in 'top x items using sequential scan' itemBruce Momjian
2002-02-12Modify COPY TO to emit carriage returns and newlines as backslash escapesTom Lane
(backslash-r, backslash-n) for protection against newline-conversion munging. In future we will also tweak COPY FROM, but this part of the change should be backwards-compatible. Per pghackers discussion. Also, update COPY reference page to describe the backslash conversions more completely and accurately.
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-31 17:15:34 +0000