Tom Lane [Wed, 7 Feb 2001 23:42:27 +0000 (23:42 +0000)]
Back-patch password leak fix for Vaschenko.
Tom Lane [Sun, 14 Jan 2001 03:16:12 +0000 (03:16 +0000)]
Back-patch fix for crash in GetRawDatabaseInfo(), just in case someone
else needs it.
Tom Lane [Thu, 4 Jan 2001 21:51:49 +0000 (21:51 +0000)]
Back-patch fix for 'btree: failed to add item to the page in _bt_sort (2)'
failure during index creation. This problem should be gone in current
sources, but I just thought I'd commit the 7.0.* patch in case anyone
else needs it.
Tatsuo Ishii [Sat, 9 Dec 2000 04:30:04 +0000 (04:30 +0000)]
Fix a bug in conversion from big5 to EUC_TW (CNS 11643-1992 Plane 3)
Thanks Chih-Chang Hsieh <cch@cc.kmu.edu.tw> for finding the bug.
Tatsuo Ishii [Fri, 17 Nov 2000 04:53:54 +0000 (04:53 +0000)]
Fix bugs in EUC_TW support. This fix includes patches contributed
by Chih-Chang Hsi. See "A Patch for MIC to EUC_TW code converting in
mb support" posting in pgsql-patches list dated 09 Nov 2000.
Tatsuo Ishii [Fri, 17 Nov 2000 04:25:29 +0000 (04:25 +0000)]
Recongizing PGCLIENTENCODING has been broken since 7.0.
Bruce Momjian [Sun, 12 Nov 2000 14:26:59 +0000 (14:26 +0000)]
Add new 7.0.3 item to all places.
Marc G. Fournier [Sun, 12 Nov 2000 07:31:36 +0000 (07:31 +0000)]
put a quick, short note in about Tom's last bug fix for the 'double portal
on abort' crash ... hopefully I'm sum'd up his explanation close enough? :)
Tom Lane [Fri, 10 Nov 2000 04:08:25 +0000 (04:08 +0000)]
Stopgap patch for problem with cursors using hash joins: an ABORT
would cause two attempts to delete the hashtable portal, one from
query shutdown and one from portalmem.c. Fix by making hash portals
be treated as 'special' portal names, so that CollectNamedPortals
will not think it should delete them. This code is in need of
complete rewrite (and is already largely rewritten in current
sources), but still need to put a finger in the dike for 7.0.*.
Bruce Momjian [Fri, 3 Nov 2000 04:17:55 +0000 (04:17 +0000)]
cleanup
Bruce Momjian [Fri, 3 Nov 2000 03:42:57 +0000 (03:42 +0000)]
Brand 7.0.3.
Jan Wieck [Thu, 2 Nov 2000 18:09:49 +0000 (18:09 +0000)]
Added pg_dumpaccounts utility script in contrib.
Derived from pg_dumpall it just dumps the pg_shadow and
pg_group contents.
Jan
Jan Wieck [Thu, 2 Nov 2000 17:33:41 +0000 (17:33 +0000)]
Revoked changes for pg_dumpaccounts
Script will go into the contrib directory.
Jan
Jan Wieck [Thu, 2 Nov 2000 16:54:21 +0000 (16:54 +0000)]
New dump utility script pg_dumpaccounts.
Dumps pg_shadow and pg_group (derived from pg_dumpall).
Jan
Tatsuo Ishii [Thu, 2 Nov 2000 05:11:42 +0000 (05:11 +0000)]
Fix for inserting/copying longer multibyte strings into bpchar data
types.
Tom Lane [Sun, 22 Oct 2000 20:33:22 +0000 (20:33 +0000)]
Back-patch fix for bogus clearing of BufferDirtiedByMe.
Tom Lane [Sun, 22 Oct 2000 19:19:42 +0000 (19:19 +0000)]
Fix to_char() to avoid coredump on NULL input. Not needed in current
sources due to fmgr rewrite, but 7.0.3 can use the patch...
Tom Lane [Thu, 19 Oct 2000 20:52:35 +0000 (20:52 +0000)]
Fix time_larger, time_smaller, timetz_larger, timetz_smaller to meet
nodeAgg.c's expectation that aggregate transition functions never return
pointers to their input values. This is fixed in a much better way in
current sources, but in 7.0.* it's gotta be done like this.
Tom Lane [Thu, 19 Oct 2000 18:39:03 +0000 (18:39 +0000)]
Back-patch fix for AM/PM boundary problem in to_char().
Fix from Karel Zak, 10/18/00.
Tom Lane [Thu, 19 Oct 2000 03:58:47 +0000 (03:58 +0000)]
Back-patch CommandCounterIncrement fix.
Tom Lane [Tue, 17 Oct 2000 01:39:56 +0000 (01:39 +0000)]
Patch VACUUM problem with moving chain of update tuples when source
and destination of a tuple lie on the same page.
Tom Lane [Fri, 6 Oct 2000 01:28:47 +0000 (01:28 +0000)]
Back-patch nodeMaterial to honor chgParam by recomputing its output.
Hiroshi Inoue [Wed, 4 Oct 2000 07:50:00 +0000 (07:50 +0000)]
avoid database-wide restart on write error
Tom Lane [Sat, 30 Sep 2000 18:47:07 +0000 (18:47 +0000)]
Back-patch fix for TRUNCATE failure on relations with indexes.
Tom Lane [Mon, 25 Sep 2000 04:34:10 +0000 (04:34 +0000)]
Back-patch fix to grab read lock on a buffer while it is written out.
Tom Lane [Sat, 23 Sep 2000 23:50:47 +0000 (23:50 +0000)]
Back-patch code to deduce implied equalities from transitivity of
mergejoin clauses, and add these equalities to the given WHERE clauses.
This is necessary to ensure that sort keys we think are equivalent
really are equivalent as soon as their rels have been joined. Without
this, 7.0 may create an incorrect mergejoin plan.
Tom Lane [Sat, 23 Sep 2000 23:41:05 +0000 (23:41 +0000)]
Back-patch fix for subselect in targetlist of Append node.
Tom Lane [Sat, 23 Sep 2000 23:36:17 +0000 (23:36 +0000)]
Back-patch fix to make pg_dump dump 'iscachable' flag for functions.
Tom Lane [Sat, 23 Sep 2000 23:31:24 +0000 (23:31 +0000)]
Back-patch fix that allows AllocateFile() to return errno=ENFILE/EMFILE
after we are no longer able to close any more VFDs. This is needed to
avoid postmaster crash under out-of-file-descriptors conditions.
Tom Lane [Sat, 23 Sep 2000 22:51:19 +0000 (22:51 +0000)]
Back-patch fix for '.' not in PATH at build time, per SL Baur.
Tom Lane [Sat, 23 Sep 2000 22:17:12 +0000 (22:17 +0000)]
Back-patch fix to include kernel errno message in all smgr elog messages.
Tom Lane [Sat, 23 Sep 2000 22:11:41 +0000 (22:11 +0000)]
Back-patch fix for 'Sorcerer's Apprentice' syndrome wherein md.c would
create a vast quantity of zero-length files if asked to access a block
number far beyond the actual end of a relation.
Tom Lane [Sat, 23 Sep 2000 21:32:55 +0000 (21:32 +0000)]
Back-patch fix for erroneous use of strcmp().
Tom Lane [Sat, 23 Sep 2000 21:27:05 +0000 (21:27 +0000)]
Back-patch fix for erroneous selectivity of not-equals.
Tom Lane [Sat, 23 Sep 2000 21:15:26 +0000 (21:15 +0000)]
Apply Jeroen van Vianen's patch for failure to check heap_openr failure
in RI triggers. This is fixed in another way in current sources, but
might as well apply this patch to REL7_0 branch so that 7.0.3 need not
suffer this crash.
Tom Lane [Sat, 23 Sep 2000 21:00:05 +0000 (21:00 +0000)]
Back-patch fix to copy sub-Query nodes before planning them. This
fixes problems with subselects appearing in contexts like COALESCE or
BETWEEN, where parser will make multiple links to same subexpression.
Tom Lane [Sat, 23 Sep 2000 19:30:04 +0000 (19:30 +0000)]
Back-patch fix to remove bogus use of int4out().
Tom Lane [Sat, 23 Sep 2000 19:17:06 +0000 (19:17 +0000)]
Back-patch fix for erroneous free() of getpwuid() result.
Hiroshi Inoue [Wed, 20 Sep 2000 07:20:27 +0000 (07:20 +0000)]
Cancel request while waiting for a lock should try to wake
up sleeping processes.
Tom Lane [Tue, 19 Sep 2000 21:01:04 +0000 (21:01 +0000)]
Back-patch fix to ensure that VACUUM always calls FlushRelationBuffers.
Tatsuo Ishii [Fri, 15 Sep 2000 12:08:56 +0000 (12:08 +0000)]
Allow PL/pgSQL accept non ascii identifiers
Tom Lane [Fri, 8 Sep 2000 02:11:33 +0000 (02:11 +0000)]
Back-patch fix for bogus plans involving non-mark/restorable plan
as inner plan of a mergejoin.
Tatsuo Ishii [Thu, 7 Sep 2000 04:53:32 +0000 (04:53 +0000)]
Fix psql crash. If MULTIBYTE is enabled, \l+ dumps core due to
SQL buffer in listAllDbs is just too small.
Tom Lane [Wed, 30 Aug 2000 21:19:32 +0000 (21:19 +0000)]
Back-patch fix to ensure we abort any open transaction at backend exit.
Marc G. Fournier [Mon, 28 Aug 2000 20:27:32 +0000 (20:27 +0000)]
oops, in v7.x its USE_SYSLOG, not ENABLE_SYSLOG
modify config.h.in so that it gets set by configure properly
Marc G. Fournier [Mon, 28 Aug 2000 20:04:39 +0000 (20:04 +0000)]
backpatch the --enable-syslog functionality to REL7_0 branch
Tom Lane [Thu, 27 Jul 2000 23:53:29 +0000 (23:53 +0000)]
Back-patch primary fix for planner recursion bug.
Tatsuo Ishii [Wed, 26 Jul 2000 13:09:30 +0000 (13:09 +0000)]
SELECT ... FOR UPDATE neglects duplicate key checking.
patches submitted by Hiroshi Inoue.
Tom Lane [Thu, 13 Jul 2000 05:52:18 +0000 (05:52 +0000)]
Backpatch backwards-index-scan fix.
Tom Lane [Fri, 7 Jul 2000 21:29:57 +0000 (21:29 +0000)]
Back-patch StrNCpy fix.
Tom Lane [Wed, 28 Jun 2000 06:13:01 +0000 (06:13 +0000)]
Back-patch COPY WITH OIDS leak fix.
Bruce Momjian [Sat, 24 Jun 2000 01:51:33 +0000 (01:51 +0000)]
Update FAQ.
Tom Lane [Thu, 15 Jun 2000 06:10:27 +0000 (06:10 +0000)]
Back-patch large-object fix.
Bruce Momjian [Thu, 15 Jun 2000 04:12:41 +0000 (04:12 +0000)]
Backpatch jdbc fixes into 7.0.X.
Thomas G. Lockhart [Wed, 14 Jun 2000 13:18:59 +0000 (13:18 +0000)]
Fix markup to allow doc building.
Bruce Momjian [Mon, 12 Jun 2000 22:37:07 +0000 (22:37 +0000)]
Brand 7.1 release. Also update jdbc version in release branch.
Bruce Momjian [Sat, 10 Jun 2000 02:05:55 +0000 (02:05 +0000)]
update developers faq
Bruce Momjian [Fri, 9 Jun 2000 16:35:54 +0000 (16:35 +0000)]
Update bsdi faq.
Bruce Momjian [Fri, 9 Jun 2000 12:20:59 +0000 (12:20 +0000)]
Update FAQ.
Tom Lane [Tue, 6 Jun 2000 17:45:05 +0000 (17:45 +0000)]
Backpatch SearchSysCacheTupleCopy fix for init_fcache.
Tom Lane [Tue, 6 Jun 2000 16:51:24 +0000 (16:51 +0000)]
Back-patch typeTypeName() fix into REL7_0.
Bruce Momjian [Mon, 5 Jun 2000 17:02:27 +0000 (17:02 +0000)]
Update install for upgraders.
Bruce Momjian [Mon, 5 Jun 2000 11:13:55 +0000 (11:13 +0000)]
Fix error message wording
Bruce Momjian [Mon, 5 Jun 2000 10:59:19 +0000 (10:59 +0000)]
Update for 7.0.2.
Bruce Momjian [Fri, 2 Jun 2000 16:34:42 +0000 (16:34 +0000)]
update
Bruce Momjian [Fri, 2 Jun 2000 02:28:13 +0000 (02:28 +0000)]
Update faq's.
Bruce Momjian [Fri, 2 Jun 2000 01:26:29 +0000 (01:26 +0000)]
Add fix to index length
Tom Lane [Thu, 1 Jun 2000 22:23:10 +0000 (22:23 +0000)]
Lexer defended us against overlength plain identifiers, but not against
overlength quoted identifiers. Death and destruction ensue...
Bruce Momjian [Thu, 1 Jun 2000 06:03:49 +0000 (06:03 +0000)]
Update 7.0.1 for Tatsuo
Bruce Momjian [Thu, 1 Jun 2000 05:58:56 +0000 (05:58 +0000)]
Mention pg_upgrade
Bruce Momjian [Thu, 1 Jun 2000 05:14:35 +0000 (05:14 +0000)]
Fixups for 7.0.1
Tom Lane [Wed, 31 May 2000 15:43:31 +0000 (15:43 +0000)]
Back-patch fix to recognize clause pairs involving Params
as being range queries.
Bruce Momjian [Tue, 30 May 2000 17:40:14 +0000 (17:40 +0000)]
Update pg_hba.conf with more examples
Bruce Momjian [Tue, 30 May 2000 17:18:43 +0000 (17:18 +0000)]
Update pg_hba.conf.sample with better examples and descriptions
Bruce Momjian [Tue, 30 May 2000 16:36:34 +0000 (16:36 +0000)]
Copy pg_ident.conf.sample into /lib directory. Rename USERAUTH to
AUTHTYPE in config file. Patch both branches.
Tom Lane [Mon, 29 May 2000 19:19:07 +0000 (19:19 +0000)]
Back-patch tz name length fixes into REL7_0.
Tom Lane [Sun, 28 May 2000 17:43:34 +0000 (17:43 +0000)]
array_map() needs to guard against a NULL input array. This problem
should go away in 7.1 with the new fmgr, but for 7.0.1 ...
Tom Lane [Sun, 28 May 2000 15:40:25 +0000 (15:40 +0000)]
fastpath neglected to pass a valid isNull flag to the function being
called. We hadn't noticed this because C-coded functions mostly don't
pay attention to isNull anyway ... but plpgsql functions sure do ...
This is fixed in another way for 7.1, but 7.0.1 needs this patch.
Tatsuo Ishii [Sun, 28 May 2000 04:57:06 +0000 (04:57 +0000)]
Make EUC_CN support more robust.
Tatsuo Ishii [Sun, 28 May 2000 04:28:55 +0000 (04:28 +0000)]
Change date of documents.
Bruce Momjian [Sun, 28 May 2000 02:02:07 +0000 (02:02 +0000)]
fix typo
Bruce Momjian [Sat, 27 May 2000 03:42:49 +0000 (03:42 +0000)]
Add README.kerbros
Bruce Momjian [Sat, 27 May 2000 01:32:01 +0000 (01:32 +0000)]
Improve pg_hba.conf examples
Tom Lane [Fri, 26 May 2000 17:19:15 +0000 (17:19 +0000)]
Reduce eqsel()'s fudge-factor for estimating the frequency of values
other than the most common value in a column. We had had 0.5, make it
0.1 to make it more likely that an indexscan will be chosen. Really
need better statistics instead, but this should stem the bleeding
meanwhile ...
Bruce Momjian [Fri, 26 May 2000 15:47:18 +0000 (15:47 +0000)]
Fix \h SELECT to not show SELECT INTO.
Tatsuo Ishii [Fri, 26 May 2000 12:17:48 +0000 (12:17 +0000)]
Fix too long syslog message problem
Tom Lane [Fri, 26 May 2000 03:56:40 +0000 (03:56 +0000)]
Generate a reasonable error message when an aggregate function is applied
to an undecorated relation name (cf. example from Ed Loehr, 5/25/00).
Bruce Momjian [Fri, 26 May 2000 03:15:18 +0000 (03:15 +0000)]
Spell fix
Bruce Momjian [Fri, 26 May 2000 02:07:15 +0000 (02:07 +0000)]
Fix initlocation syntax example for createdb
Tom Lane [Fri, 26 May 2000 01:38:08 +0000 (01:38 +0000)]
More paranoia about global variables containing references to long-
since-closed file descriptors...
Tom Lane [Fri, 26 May 2000 01:26:19 +0000 (01:26 +0000)]
After closing frontend socket, set MyProcPort->sock = -1 to ensure that
subsequent I/O attempts fail cleanly. I'm speculating about failure
scenarios in which we do pq_close, then something in a proc_exit routine
opens a file (re-using that kernel FD number), then something else
fails and tries to write an elog message to the frontend ... message
ends up in opened file, oops. No known examples of this but it seems
like a potential hole.
Tom Lane [Thu, 25 May 2000 23:30:20 +0000 (23:30 +0000)]
Add some elog(DEBUG)'s to help diagnose mdblindwrt failures.
Tom Lane [Thu, 25 May 2000 22:43:12 +0000 (22:43 +0000)]
Clean up sloppy coding of _outAExpr().
Tom Lane [Thu, 25 May 2000 22:42:19 +0000 (22:42 +0000)]
Modify raw parsetree representation returned by gram.y for SubLinks:
the oper field should be a valid Node structure so it can be dumped by
outfuncs.c without risk of coredump. (We had been using a raw pointer
to character string, which surely is NOT a valid Node.) This doesn't
cause any backwards compatibility problems for stored rules, since
raw unanalyzed parsetrees are never stored.
Tom Lane [Thu, 25 May 2000 21:30:20 +0000 (21:30 +0000)]
Do table renaming in a sane order: physical file rename must happen
*last*, after all updating of system catalogs. In old code, an error
detected during TypeRename left the relation hosed. Also, add a call
to flush the relation's relcache entry, rather than trusting to shared
cache invalidation to flush it for us.
Tom Lane [Thu, 25 May 2000 21:25:32 +0000 (21:25 +0000)]
heap_drop() should flush the relcache entry for the
relation being dropped.
Tom Lane [Thu, 25 May 2000 20:18:15 +0000 (20:18 +0000)]
Quote database name so that not-all-lowercase names are handled safely.
Bruce Momjian [Thu, 25 May 2000 19:09:55 +0000 (19:09 +0000)]
! * Users doing non-blocking connections need to handle the reset
! * themselves, they'll need to check the connection status if we
! * return an error.
Alfred Perlstein
Bruce Momjian [Thu, 25 May 2000 16:10:01 +0000 (16:10 +0000)]
Update TODO list.
Bruce Momjian [Thu, 25 May 2000 15:32:03 +0000 (15:32 +0000)]
Spell fix