OSDN Git Service
Bruce Momjian [Thu, 24 Jan 2002 22:20:18 +0000 (22:20 +0000)]
Another clarification.
Bruce Momjian [Thu, 24 Jan 2002 22:19:48 +0000 (22:19 +0000)]
Clarification on COPY failure options.
Tom Lane [Thu, 24 Jan 2002 21:40:44 +0000 (21:40 +0000)]
Tweak plperl.c to compile against threaded Perls, per report from
cturner@redhat.com.
Tom Lane [Thu, 24 Jan 2002 19:50:36 +0000 (19:50 +0000)]
Cope with gcc that outputs a multiline version string, per Trond.
Tom Lane [Thu, 24 Jan 2002 19:31:36 +0000 (19:31 +0000)]
pltcl's spi_execp didn't handle NULL arguments quite correctly.
It would try to call the input conversion routines for them anyway.
So, a valid input string for the datatype had to be supplied.
Tom Lane [Thu, 24 Jan 2002 18:28:15 +0000 (18:28 +0000)]
Fix documentation misstatement: OLD is not valid in ON SELECT.
Tom Lane [Thu, 24 Jan 2002 16:53:42 +0000 (16:53 +0000)]
Fix incorrect test for whether Perl code is returning undef. This
allows plperl routines to return NULL as intended.
Tom Lane [Thu, 24 Jan 2002 15:31:43 +0000 (15:31 +0000)]
Fix logic error in insert_fsm_page_entry: because compact_fsm_page_list
removes any empty chunks, the chunk previously added won't be there
anymore, so it's possible there is zero free space in the rel's page list
afterwards. Must loop back and rerun the part that adds a chunk to
the list.
Tom Lane [Wed, 23 Jan 2002 21:08:17 +0000 (21:08 +0000)]
Overhaul PL/Tcl documentation.
Bruce Momjian [Wed, 23 Jan 2002 19:22:08 +0000 (19:22 +0000)]
Add Goggle mention of previous discussion.
Tom Lane [Wed, 23 Jan 2002 18:48:39 +0000 (18:48 +0000)]
Remove long-obsolete version of pltcl documentation.
Tom Lane [Wed, 23 Jan 2002 18:45:41 +0000 (18:45 +0000)]
Clean up Red Hat Tcl RPM brain-damage in a more reliable way: fix the
value of TCL_SHLIB_LD in the shell script that creates Makefile.tcldefs,
rather than trying to persude gmake to do it.
Bruce Momjian [Wed, 23 Jan 2002 18:40:22 +0000 (18:40 +0000)]
Add new email;remove old entries.
Michael Meskes [Wed, 23 Jan 2002 16:34:06 +0000 (16:34 +0000)]
Added patch to temporarily disable locale for descriptors too (Christof)
Bruce Momjian [Wed, 23 Jan 2002 16:14:04 +0000 (16:14 +0000)]
Add:
> * Reorder postgresql.conf WAL items in order of importance
> * Remove wal_files postgresql.conf option because WAL files are now recycled
> * Find proper defaults for postgresql.conf WAL entries
> * Add checkpoint_min_warning postgresql.conf option to warn about checkpoints
> that are too frequent
Bruce Momjian [Tue, 22 Jan 2002 22:22:34 +0000 (22:22 +0000)]
Clarify URL:
< http://www1.distributed.net/source, in client/common/cpucheck.cpp
---
> from distributted.net, http://www1.distributed.net/source,
> in client/common/cpucheck.cpp
Bruce Momjian [Tue, 22 Jan 2002 22:15:07 +0000 (22:15 +0000)]
Document SMP detection code.
Bruce Momjian [Tue, 22 Jan 2002 21:55:06 +0000 (21:55 +0000)]
Re-group items.
Bruce Momjian [Tue, 22 Jan 2002 20:50:35 +0000 (20:50 +0000)]
Break PERFORMANCE up into subsections.
Bruce Momjian [Tue, 22 Jan 2002 20:40:27 +0000 (20:40 +0000)]
Add:
> * Add code to detect an SMP machine and handle spinlocks accordingly
Bruce Momjian [Tue, 22 Jan 2002 20:24:14 +0000 (20:24 +0000)]
Update FAQ.
Tom Lane [Tue, 22 Jan 2002 19:02:40 +0000 (19:02 +0000)]
libpq++/pgconnection.h must not include postgres_fe.h, else it fails to
compile in client apps that use the standard installed header set.
To allow removing that include, move DLLIMPORT definitions out of c.h
and into the appropriate port-specific header files.
PostgreSQL Daemon [Tue, 22 Jan 2002 17:55:30 +0000 (17:55 +0000)]
okay, sorry for delay all ... here is the tag for RC1 ...
Tom Lane [Mon, 21 Jan 2002 03:27:46 +0000 (03:27 +0000)]
Suppress bogus soname switch that RedHat RPMs put into tclConfig.sh.
Peter Eisentraut [Sun, 20 Jan 2002 22:19:57 +0000 (22:19 +0000)]
Spell-check and markup police
Tom Lane [Sun, 20 Jan 2002 05:45:18 +0000 (05:45 +0000)]
Mention that 'make distclean' is a good idea when changing configure
options. Document --with-pam and --enable-depend, do some minor
copy-editing.
Bruce Momjian [Sun, 20 Jan 2002 05:12:57 +0000 (05:12 +0000)]
Add IN/EXISTS file.
Bruce Momjian [Sun, 20 Jan 2002 04:56:14 +0000 (04:56 +0000)]
Add
> * Make IN/NOT IN have similar performance to EXISTS/NOT EXISTS [exists]
Peter Eisentraut [Fri, 18 Jan 2002 21:25:00 +0000 (21:25 +0000)]
Update from Kova'cs Zolta'n
Bruce Momjian [Fri, 18 Jan 2002 21:17:07 +0000 (21:17 +0000)]
Add missing literal endtag.
Tom Lane [Fri, 18 Jan 2002 20:56:17 +0000 (20:56 +0000)]
Add info about how to enable large-file support, so that pg_dump won't
choke at 2Gb of output. From Andrew Sullivan.
Bruce Momjian [Fri, 18 Jan 2002 20:46:37 +0000 (20:46 +0000)]
Add:
> * Use thread-safe crypt() in libpq, if available
Bruce Momjian [Fri, 18 Jan 2002 20:39:04 +0000 (20:39 +0000)]
Improve non-thread-safe mention of libpq's crypt.
Bruce Momjian [Fri, 18 Jan 2002 20:32:54 +0000 (20:32 +0000)]
Improve description of autocommit behavior in ecpg manual pages.
Bruce Momjian [Fri, 18 Jan 2002 19:17:05 +0000 (19:17 +0000)]
You might want to run pg_indent on pg_backup_db.c however ...
tom lane
Dave Cramer [Fri, 18 Jan 2002 17:21:51 +0000 (17:21 +0000)]
Fixes to getImportedKeys/getExportedKeys from Jason Davies
Previous versions did not correctly identify primary/foreign keys
Tom Lane [Fri, 18 Jan 2002 17:13:51 +0000 (17:13 +0000)]
Fix pg_restore to handle the 'set max oid' entry correctly in archives
dumped by pg_dump -o. Per bug report posted by Bruce; fix is from
Philip Warner, reviewed by Tom Lane.
Tom Lane [Fri, 18 Jan 2002 16:14:54 +0000 (16:14 +0000)]
Add missing 'else', per report from sugita@sra.co.jp.
Michael Meskes [Fri, 18 Jan 2002 15:51:00 +0000 (15:51 +0000)]
Accept subsequent commits. This should have been just a warning anyway. I
cannot see a reason why it should be an error.
Bruce Momjian [Fri, 18 Jan 2002 04:38:46 +0000 (04:38 +0000)]
Enable /contrib/pg_upgrade, mention little testing.
Tom Lane [Fri, 18 Jan 2002 01:05:43 +0000 (01:05 +0000)]
Explain privileges required for LOCK. Minor wordsmithing too.
Tom Lane [Fri, 18 Jan 2002 01:04:53 +0000 (01:04 +0000)]
Point out that superusers bypass privilege checking. Minor wordsmithing.
Tom Lane [Wed, 16 Jan 2002 23:51:56 +0000 (23:51 +0000)]
Fix misstatements added by Bruce.
Bruce Momjian [Wed, 16 Jan 2002 23:09:09 +0000 (23:09 +0000)]
Add more comments to tqual.c for visibility functions.
Tom Lane [Wed, 16 Jan 2002 20:29:02 +0000 (20:29 +0000)]
TOAST needs to do at least minimal time-qual checking in order not to
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.
Tom Lane [Wed, 16 Jan 2002 17:34:42 +0000 (17:34 +0000)]
Fix init_irels to close the pg_internal.init file before returning.
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.
Tom Lane [Tue, 15 Jan 2002 22:33:20 +0000 (22:33 +0000)]
If we fail to rename pg_internal.init into place, delete the useless
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.
Tom Lane [Tue, 15 Jan 2002 22:14:17 +0000 (22:14 +0000)]
Add more sanity-checking to PageAddItem and PageIndexTupleDelete,
to prevent spreading of corruption when page header pointers are bad.
Merge PageZero into PageInit, since it was never used separately, and
remove separate memset calls used at most other PageInit call points.
Remove IndexPageCleanup, which wasn't used at all.
Tom Lane [Tue, 15 Jan 2002 16:52:47 +0000 (16:52 +0000)]
Fix typo that caused equalTriggerDescs() to return false in cases where
the two trigger sets were logically equal, but not in the same order.
Caught by Holger Krug (hkrug@rationalizer.com).
Barry Lind [Tue, 15 Jan 2002 07:37:33 +0000 (07:37 +0000)]
Applied patch submitted by Ryouichi Matsuda (r-matuda@sra.co.jp) that fixed a problem with leading zeros being lost on fractional seconds when setting a timestamp value on a PreparedStatement.
Barry Lind [Tue, 15 Jan 2002 06:55:13 +0000 (06:55 +0000)]
Applied patch from Ryouichi Matsuda <r-matuda@sra.co.jp> where the jdbc
driver was not properly handling timestamptz datatype when using the
getObject() method on ResultSet. Fix adds this datatype to the object mappings.
Bruce Momjian [Tue, 15 Jan 2002 05:41:55 +0000 (05:41 +0000)]
Manual page improvements.
Bruce Momjian [Tue, 15 Jan 2002 05:10:57 +0000 (05:10 +0000)]
More cleanups.
Tom Lane [Tue, 15 Jan 2002 05:05:49 +0000 (05:05 +0000)]
pg_upgrade doesn't live here anymore. Remove dangling references.
Bruce Momjian [Tue, 15 Jan 2002 05:03:53 +0000 (05:03 +0000)]
Keep pg_upgrade as disabled.
Bruce Momjian [Tue, 15 Jan 2002 05:03:25 +0000 (05:03 +0000)]
More wording improvements.
Bruce Momjian [Tue, 15 Jan 2002 04:55:26 +0000 (04:55 +0000)]
More updates.
Bruce Momjian [Tue, 15 Jan 2002 04:52:33 +0000 (04:52 +0000)]
Remove old pg_upgrade script, from Tom.
Bruce Momjian [Tue, 15 Jan 2002 04:50:37 +0000 (04:50 +0000)]
More cleanups with ideas from Peter.
Bruce Momjian [Tue, 15 Jan 2002 04:05:24 +0000 (04:05 +0000)]
Add Peter's portability and option suggestions.
Bruce Momjian [Mon, 14 Jan 2002 22:54:44 +0000 (22:54 +0000)]
Update permissions?
Tom Lane [Mon, 14 Jan 2002 17:55:57 +0000 (17:55 +0000)]
Reduce severity of 'XLogFlush: request is not satisfied' error condition,
per my proposal of a couple days ago. This will eliminate the unable-
to-restart-database class of problem that we have seen reported half a
dozen times with 7.1.*.
Tom Lane [Mon, 14 Jan 2002 17:49:56 +0000 (17:49 +0000)]
Ensure that ecpg/test is cleaned by higher-level 'make clean'.
Bruce Momjian [Mon, 14 Jan 2002 17:45:43 +0000 (17:45 +0000)]
Add README file.
Bruce Momjian [Mon, 14 Jan 2002 17:42:42 +0000 (17:42 +0000)]
Doc improvements.
Bruce Momjian [Mon, 14 Jan 2002 17:32:36 +0000 (17:32 +0000)]
Add manual page to /contrib. SGML from docs.
Bruce Momjian [Mon, 14 Jan 2002 17:32:07 +0000 (17:32 +0000)]
Move pg_upgrade to /contrib. Still need to make Peter's portability
changes.
Bruce Momjian [Mon, 14 Jan 2002 15:34:41 +0000 (15:34 +0000)]
Small AIX fixes from Rick Flower.
PostgreSQL Daemon [Mon, 14 Jan 2002 13:15:28 +0000 (13:15 +0000)]
tag as beta 5 for *hopefully* a very very short beta cycle on this one?
Bruce Momjian [Sun, 13 Jan 2002 17:52:00 +0000 (17:52 +0000)]
Fix recreation of sequence files for 7.2 also because of XID change from
beta4 to beta5.
Michael Meskes [Sun, 13 Jan 2002 08:52:09 +0000 (08:52 +0000)]
- Fixed variable handling for struct members.
- Removed check for array input. An attribut might store the
complete array.
Bruce Momjian [Sun, 13 Jan 2002 05:36:42 +0000 (05:36 +0000)]
Now works for 7.1 databases.
Bruce Momjian [Sun, 13 Jan 2002 04:55:44 +0000 (04:55 +0000)]
Now tested on 7.2->7.2 migration; still disabled. Need 7.1 testing now.
Bruce Momjian [Sun, 13 Jan 2002 01:22:27 +0000 (01:22 +0000)]
Keep it disabled.
Bruce Momjian [Sun, 13 Jan 2002 01:13:59 +0000 (01:13 +0000)]
Wow, it actually worked for the regression database. More testing needed.
Tom Lane [Sat, 12 Jan 2002 18:09:04 +0000 (18:09 +0000)]
Bump catversion to ensure people apply recent timestamp and sequence
fixes.
Tom Lane [Sat, 12 Jan 2002 18:07:34 +0000 (18:07 +0000)]
Update horology expected results (this variant extrapolated by yours
truly; should be verified by someone with an appropriate system).
Tom Lane [Sat, 12 Jan 2002 18:06:53 +0000 (18:06 +0000)]
Update horology expected results (this variant verified on HPUX).
Thomas G. Lockhart [Sat, 12 Jan 2002 04:38:38 +0000 (04:38 +0000)]
Repair bugs in declarations of routines to add timestamptz and interval.
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.
Tom Lane [Fri, 11 Jan 2002 23:21:55 +0000 (23:21 +0000)]
Fix pg_dump to read-lock all tables to be dumped as soon as it's read
their names from pg_class. This considerably reduces the window wherein
someone could DROP or ALTER a table that pg_dump is intending to dump.
Not a perfect solution, but definitely an improvement. Per complaints
from Marc Fournier; patch by Brent Verner with some kibitzing by Tom Lane.
Tom Lane [Fri, 11 Jan 2002 21:27:13 +0000 (21:27 +0000)]
Code review for latest changes.
Bruce Momjian [Fri, 11 Jan 2002 20:48:47 +0000 (20:48 +0000)]
More man pages improvements; also needed to test sgml build.
Bruce Momjian [Fri, 11 Jan 2002 20:34:14 +0000 (20:34 +0000)]
Sync up.
Tom Lane [Fri, 11 Jan 2002 20:07:03 +0000 (20:07 +0000)]
VACUUM must make sure that a HEAP_MARKED_FOR_UPDATE tuple gets marked
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.
Tom Lane [Fri, 11 Jan 2002 18:16:04 +0000 (18:16 +0000)]
Fix sequence creation to set the t_xmin of a sequence's tuple to
FrozenTransactionId, not the XID of the creating transaction. Without
this it's possible for a reference to a long-gone CLOG record to occur,
per Christian Meunier's bug report of 10-Jan-02. Worse, the sequence
tuple would become invisible to SELECTs after 2 billion transactions.
Since the fix is applied during sequence creation it does not help
existing databases, unless you drop and recreate every sequence.
However, we intend to force initdb for 7.2RC1 anyway, to fix a pg_proc
error, so I see no need to do more for this problem.
Michael Meskes [Fri, 11 Jan 2002 14:43:11 +0000 (14:43 +0000)]
Added Christof's fixes.
Bruce Momjian [Fri, 11 Jan 2002 06:48:41 +0000 (06:48 +0000)]
More testing, more cleanups.
Bruce Momjian [Fri, 11 Jan 2002 06:33:01 +0000 (06:33 +0000)]
pg_resetxlog specifies log location in hex; more pg_upgrade testing
improvments.
Bruce Momjian [Fri, 11 Jan 2002 06:08:02 +0000 (06:08 +0000)]
More cleanups.
Hiroshi Inoue [Fri, 11 Jan 2002 06:01:47 +0000 (06:01 +0000)]
*** empty log message ***
Bruce Momjian [Fri, 11 Jan 2002 05:54:59 +0000 (05:54 +0000)]
More updates for int8 sequence restoration. Old dump file not required
anymore.
Bruce Momjian [Fri, 11 Jan 2002 04:39:19 +0000 (04:39 +0000)]
Handle int4-int8 sequence migration without full data dump.
Hiroshi Inoue [Fri, 11 Jan 2002 02:50:01 +0000 (02:50 +0000)]
Add a directory to save the changes until 7.3-tree is branched.
Bruce Momjian [Fri, 11 Jan 2002 00:27:42 +0000 (00:27 +0000)]
More improvements using pg_resetxlog. still disabled.
Bruce Momjian [Thu, 10 Jan 2002 23:46:13 +0000 (23:46 +0000)]
Have pg_resetxlog -n return zero exit status.
Bruce Momjian [Thu, 10 Jan 2002 23:41:49 +0000 (23:41 +0000)]
Update FAQ.
Bruce Momjian [Thu, 10 Jan 2002 23:40:58 +0000 (23:40 +0000)]
Remove 7.1beta WAL handling from /contrib/pg_resetxlog.
Bruce Momjian [Thu, 10 Jan 2002 23:35:20 +0000 (23:35 +0000)]
Update FAQ.
Bruce Momjian [Thu, 10 Jan 2002 23:35:19 +0000 (23:35 +0000)]
Update FAQ.
Bruce Momjian [Thu, 10 Jan 2002 23:34:14 +0000 (23:34 +0000)]
Update FAQ.