12026 Commits

Author SHA1 Message Date
4526d2183f Brand 7.2.3. REL7_2_3 2002-10-01 03:34:29 +00:00
9227bc5e5b Update HISTORY/release.sgml for 7.2.3. 2002-10-01 03:24:17 +00:00
407517f039 Back-patch fixes to work around broken mktime() in recent glibc releases. 2002-09-30 20:57:11 +00:00
96464fa37c Back-patch fix for bad SIGUSR2 interrupt handling during backend shutdown. 2002-09-30 20:47:22 +00:00
c6ec2a8ba5 Back-patch fix for correct TAS operation on multi-CPU PPC machines. 2002-09-30 20:24:53 +00:00
c9e3806e57 Back-patch fix for 'can't wait without a PROC structure' failures:
remove separate ShutdownBufferPoolAccess exit callback, and do the
work in ProcKill instead, before we delete MyProc.
2002-09-30 20:18:59 +00:00
c80d09f123 Back-patch fix to ensure a checkpoint occurs before truncating CLOG,
even if no recent WAL activity has occurred.
2002-09-30 19:55:08 +00:00
a829ad1570 Back-patch fix to not change pg_database.datvacuumxid or truncate CLOG
when an unprivileged user runs VACUUM.
2002-09-30 19:45:57 +00:00
826692788d Back-patch fix for failure to dump views containing FULL JOIN USING.
The bug is not present in CVS tip due to cleanup of JOIN handling,
but 7.2.* is broken.
2002-09-20 21:37:07 +00:00
30ab8da488 Update HISTORY with Neil's changes. REL7_2_2 2002-08-23 02:33:06 +00:00
17e543ee97 Stamp the 7.2.2 release. 2002-08-22 23:26:26 +00:00
5a2c7c3e10 Fix regression-test breakage from (unnecessary) rewrite of show_datestyle. Grumble. 2002-08-22 22:17:22 +00:00
8c905b0aa9 Back-patch fix to make partial indexes usable on relations other than
the first one listed in a query.  Per request from Oleg.
2002-08-22 16:20:38 +00:00
cd9f392cd0 Apply Neil Conway's security patches to 7.2.X. 2002-08-22 05:27:41 +00:00
76fc795e5c Fix bug in pg_convert() per report from MaC.Yui.
It pfree() wrong pointer.
2002-08-19 04:58:26 +00:00
7e49585cad Back-patch 7.3 fix to fully parenthesize UNION/EXCEPT/INTERSECT queries
in ruleutils output.  The previous partial parenthesization was a hack
to get around grammar restrictions that have since been fixed; and as
Sam O'Connor pointed out, there were cases where it didn't work.
2002-06-15 18:38:10 +00:00
a67387b6b4 Please apply attached patch to contrib/intarray (7.2, 7.3).
Fixed bug with '=' operator for gist__int_ops and
     define '=' operator for gist__intbig_ops opclass.
     Now '=' operator is consistent with standard 'array' type.

     Thanks Achilleus Mantzios for bug report and suggestion.

Oleg Bartunov
2002-06-07 21:53:09 +00:00
b81737bfa8 Repair incorrect dumping of user-defined aggregate with null initcond.
(Already fixed in current, but need a patch for 7.2.2.)
2002-05-28 15:40:36 +00:00
efe861c855 Fix a bug with building rtree_gist indexes.
Patch from Teodor Sigaev.
2002-05-28 15:25:03 +00:00
5b792153fc Repair error with not adjusting active scans properly after gistSplit.
Patch from Teodor Sigaev.
2002-05-28 15:22:44 +00:00
63448825fb Make RelationForgetRelation error out if the relcache entry has nonzero
reference count.  This avoids leaving dangling pointers around, as in
recent bug report against sequences (bug# 671).
2002-05-22 17:29:45 +00:00
ce362bf8be Repair OPEN cursor(args), which I broke on 11/29/01 with a change to
be smarter about parentheses in read_sql_construct().  Sigh.
2002-05-21 18:50:18 +00:00
490b12d53e Remove unnecessary pfree's in geometric operators. At least one of these
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-14 18:16:54 +00:00
964f1fa734 Fix bug in pg_dump and psql (to reproduce the bug, just try pg_dump
--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-14 02:08:22 +00:00
77c4ba63b8 plpgsql_dstring_append was broken for long strings. 2002-05-05 17:38:28 +00:00
ffd1a5d853 Change heap_get_latest_tid() so that a transaction can
see changes made by the transaction itself.
2002-05-01 01:27:31 +00:00
891ce19bcc A backport patch.
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-08 06:21:31 +00:00
af997458eb Fix CLOG truncation code to not do the Wrong Thing when there are already
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-04-02 05:12:00 +00:00
9de8b7b9f2 Update release list. REL7_2_1 2002-03-26 05:34:37 +00:00
70cde084ee Update sgml version properly. 2002-03-26 05:33:47 +00:00
22b32cb511 New wording:
Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom)
2002-03-25 21:24:46 +00:00
ff71f2aee6 Add to HISTORY:
Allow CREATE TABLE AS ... SELECT in PL/PgSQL (Tom)
2002-03-25 20:58:40 +00:00
df739a0200 Re-allow CREATE AS (but not SELECT INTO) in EXECUTE. 2002-03-25 07:41:21 +00:00
b2d05d58eb Remove long-dead 'fix for SELECT NULL' to stop current coredump. 2002-03-21 06:21:14 +00:00
94a4677a75 > > Users of contrib/tsearch needs after upgrading of module (compiling, 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-19 14:16:32 +00:00
873a986cf8 Improve wording of bug fix:
Ensure that sequence counters do not go backwards after a crash
2002-03-19 00:12:41 +00:00
0d3abc019b Update for 7.2.1. 2002-03-18 23:04:11 +00:00
bbc1fb07c6 Backpatch array I/O code and documentation fixes, also array slice
lower subscript bounds change.
2002-03-17 20:05:59 +00:00
efec53adb3 Repair bad calculation in timetz_izone() which gave erroneous results.
Will be patched separately but equivalently in HEAD for 7.3.
2002-03-15 23:37:48 +00:00
94a41d1326 Repair two problems with WAL logging of sequence nextvalI() ops, as
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-15 19:20:47 +00:00
44d7f153ae Update FAQ for 7.2.1. 2002-03-13 20:53:15 +00:00
aaf52da649 Pleas apply it for 7.2.1 and current CVS.
Patch fixes using lc.lang instead of lc.lc_ctype.

Teodor Sigaev
2002-03-11 16:55:18 +00:00
07ee72fc67 Guard against NULL strings in SET key=val constructs.
Problem noted by Fernando Nasser.
2002-03-09 17:41:04 +00:00
38b4088518 Please, apply attached patch for contrib/tsearch to 7.2.1 and current
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-05 06:10:49 +00:00
68d813795a Previous patch to mark UNION outputs with common typmod (if any) breaks
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-05 05:13:36 +00:00
06b3be1e48 A backport patch:
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-05 03:45:44 +00:00
ee93155748 Update FAQ_Solaris with info about gcc 2.95.1 problems and how to work
around 64-bit vsnprintf bug.
2002-03-04 17:47:24 +00:00
b233e5903a Back-patch fix for errors reported at transaction end. 2002-02-27 23:17:01 +00:00
567f9d054f Back-patch fix for followings:
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-27 01:47:31 +00:00
75c07d5b4d Back-patch fix for command completion report handling. This is
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-26 23:48:47 +00:00