OSDN Git Service
Tatsuo Ishii [Fri, 23 Mar 2001 05:46:05 +0000 (05:46 +0000)]
Add checking for strtoul. SunOS4 does not have it.
Bruce Momjian [Fri, 23 Mar 2001 04:49:58 +0000 (04:49 +0000)]
Fix comments that were mis-wrapped, for Tom Lane.
Tom Lane [Fri, 23 Mar 2001 01:51:08 +0000 (01:51 +0000)]
Fix SPI example to reflect new-style calling convention for textout().
Philip Warner [Fri, 23 Mar 2001 01:27:12 +0000 (01:27 +0000)]
Fix checking of file operations in demo ('files') output format.
Tom Lane [Fri, 23 Mar 2001 00:36:38 +0000 (00:36 +0000)]
Fix problems with coredumps due to ^C when longjmp buffer isn't valid.
Now, we will only catch ^C at times when it is valid.
Tom Lane [Thu, 22 Mar 2001 17:41:47 +0000 (17:41 +0000)]
Fix Joubert's complaint that int8-sized numeric literals are mishandled
on Alpha (because parser mistakenly assumes that a nonoverflow result
from strtol means the value will fit into int4). A scan for other uses
of strtol and strtoul found a couple other places with the same mistake;
fix them too. The changes are all conditional on HAVE_LONG_INT_64 to
avoid complaints from compilers that think x != x is a silly test
(cf. pg_atoi).
Bruce Momjian [Thu, 22 Mar 2001 15:24:12 +0000 (15:24 +0000)]
Run pgindent on _int.c, for Tom Lane. I had skipped this file because
of a complex macro that pgindent complained about. Hand-adjusted macro
for pgindent run.
Marc G. Fournier [Thu, 22 Mar 2001 15:13:19 +0000 (15:13 +0000)]
geometry tests 'FAILED' from a precision standpoint, but differently then
what solaris-precision takes into account ... its possible that solaris-precision
is 'stale', but created a new one "just in case" ...
Bruce Momjian [Thu, 22 Mar 2001 06:16:21 +0000 (06:16 +0000)]
Remove dashes in comments that don't need them, rewrap with pgindent.
Bruce Momjian [Thu, 22 Mar 2001 04:01:46 +0000 (04:01 +0000)]
pgindent run. Make it all clean.
Peter Eisentraut [Wed, 21 Mar 2001 19:09:03 +0000 (19:09 +0000)]
correction
Hiroshi Inoue [Wed, 21 Mar 2001 16:26:17 +0000 (16:26 +0000)]
The attached patch fixes win32.mak which got broken by the Multibyte mod
:-(, and tidies it up a little as well.
Regards, Dave.
Bruce Momjian [Wed, 21 Mar 2001 15:46:11 +0000 (15:46 +0000)]
Update TODO list.
Vadim B. Mikheev [Wed, 21 Mar 2001 10:13:29 +0000 (10:13 +0000)]
Check bufHdr->cntxDirty and call StartBufferIO in BufferSync()
*before* acquiring shlock on buffer context. This way we should be
protected against conflicts with FlushRelationBuffers.
(Seems we never do excl lock and then StartBufferIO for the same
buffer, so there should be no deadlock here, - but we'd better
check this very soon).
Hiroshi Inoue [Wed, 21 Mar 2001 09:35:25 +0000 (09:35 +0000)]
a fix from Eiji Tokuya.
Bruce Momjian [Wed, 21 Mar 2001 04:39:28 +0000 (04:39 +0000)]
Add mmap info. Seems mmap may not be a good idea.
Bruce Momjian [Wed, 21 Mar 2001 04:30:26 +0000 (04:30 +0000)]
Update TODO list.
Marc G. Fournier [Tue, 20 Mar 2001 23:35:20 +0000 (23:35 +0000)]
well, here goes our first Release Candidate for 7.1 *cross fingers*
Bruce Momjian [Tue, 20 Mar 2001 22:31:54 +0000 (22:31 +0000)]
Fix 'ps' WAIT status display bug on setproctitle() platforms, cleared by
Tom Lane.
Bruce Momjian [Tue, 20 Mar 2001 22:15:43 +0000 (22:15 +0000)]
Update Japanese FAQ.
Bruce Momjian [Tue, 20 Mar 2001 22:04:59 +0000 (22:04 +0000)]
Update TODO list.
Tom Lane [Tue, 20 Mar 2001 20:54:41 +0000 (20:54 +0000)]
Recommend CREATE TABLE AS in preference to SELECT INTO. Remove the
(inadequate anyway) mention of SELECT INTO from the main SELECT ref page.
Point out that SELECT INTO means something else in plpgsql and ecpg.
Bruce Momjian [Tue, 20 Mar 2001 20:32:30 +0000 (20:32 +0000)]
Update TODO list.
Bruce Momjian [Tue, 20 Mar 2001 20:31:56 +0000 (20:31 +0000)]
Update TODO list.
Bruce Momjian [Tue, 20 Mar 2001 20:31:07 +0000 (20:31 +0000)]
Update TODO list.
Bruce Momjian [Tue, 20 Mar 2001 19:56:25 +0000 (19:56 +0000)]
Update TODO list.
Tom Lane [Tue, 20 Mar 2001 03:08:12 +0000 (03:08 +0000)]
Repair intarray's problems with TOASTed input, avoid scribbling on
source data, improve split algorithm for intbig_ops. Oleg Bartunov
with some kibitzing from Tom Lane.
Tom Lane [Tue, 20 Mar 2001 00:18:21 +0000 (00:18 +0000)]
Mention that parallel regress script needs to be run under ksh not sh
on HPUX.
Tom Lane [Tue, 20 Mar 2001 00:09:36 +0000 (00:09 +0000)]
Discuss LOCALE differences as a reason for regression test failure.
Tom Lane [Mon, 19 Mar 2001 22:29:39 +0000 (22:29 +0000)]
Tweak out-of-memory error messages to include the request size, so that
it's easier to tell whether a bug report is talking about progressive
memory exhaustion or a wacko requested chunk size.
Tom Lane [Mon, 19 Mar 2001 22:27:46 +0000 (22:27 +0000)]
Make regular-expression error messages a tad less obscure,
per gripe from Josh Berkus.
Bruce Momjian [Mon, 19 Mar 2001 21:57:09 +0000 (21:57 +0000)]
Update Peter Mount's email address in README.
Peter Eisentraut [Mon, 19 Mar 2001 16:20:52 +0000 (16:20 +0000)]
Add missing TO.
Peter Eisentraut [Mon, 19 Mar 2001 16:19:26 +0000 (16:19 +0000)]
Add note about saving large objects during upgrade.
Philip Warner [Mon, 19 Mar 2001 02:35:29 +0000 (02:35 +0000)]
- Added CVS headers to files
- Avoid forcing table name to lower case in FixupBlobXrefs
- Removed fmtId calls for all ArchiveEntry name fields. This fixes
quoting problems in trigger enable/disable code for mixed case
table names, and avoids commands like 'pg_restore -t '"TblA"'
Tom Lane [Sun, 18 Mar 2001 23:36:55 +0000 (23:36 +0000)]
Restore include-file updates, and fix some of the more glaring macro
sloppiness (insufficient parenthesization, etc).
It still fails regress test for me, however.
Tom Lane [Sun, 18 Mar 2001 23:35:18 +0000 (23:35 +0000)]
Restore Peter's makefile fixes.
Tom Lane [Sun, 18 Mar 2001 20:27:11 +0000 (20:27 +0000)]
Give postmaster enough time to update the pidfile before checking to
see if it's been updated. Skip the whole mess if we didn't see any
old pidfile.
Tom Lane [Sun, 18 Mar 2001 20:18:59 +0000 (20:18 +0000)]
Remove NEXTXID xlog record type to avoid three-way deadlock risk.
NEXTXID isn't really necessary, per previous discussion in pghackers,
but I mulishy insisted we should put it in anyway. Mea culpa.
Tom Lane [Sun, 18 Mar 2001 20:13:13 +0000 (20:13 +0000)]
When we add 'waiting' to the ps_status display, there should be a
space in front of it. Improve comments a little.
Tom Lane [Sun, 18 Mar 2001 18:32:02 +0000 (18:32 +0000)]
Considering the BeOS port didn't compile without IPC_STAT and shm_nattch,
I'm betting the QNX4 port does not either ...
Tom Lane [Sun, 18 Mar 2001 18:22:08 +0000 (18:22 +0000)]
Patches from Cyril Velter to make shared-memory-conflict-detection code
work in BeOS port.
Philip Warner [Sun, 18 Mar 2001 03:45:12 +0000 (03:45 +0000)]
Fixed but in _enableTriggersIfNecessary introduced by previous patches by me
which caused segfault in a data-only retore with BLOBs
Tom Lane [Sun, 18 Mar 2001 02:25:32 +0000 (02:25 +0000)]
Fix coredump due to writing one more byte than we'd allocated.
Tom Lane [Sun, 18 Mar 2001 00:30:27 +0000 (00:30 +0000)]
Make sure ControlFile logId/logSeg don't go backwards (barely possible given a
slow backend, if we update unconditionally as the code did before).
Bruce Momjian [Sat, 17 Mar 2001 21:59:42 +0000 (21:59 +0000)]
Update contrib intarray to Jan 25 version.
Tom Lane [Sat, 17 Mar 2001 20:54:13 +0000 (20:54 +0000)]
Rearrange XLogFileInit so that control-file spinlock is not held while filling
the new log file with zeroes, only while renaming it into place. This should
prevent problems with 'stuck spinlock' errors under heavy load.
Peter Eisentraut [Sat, 17 Mar 2001 18:15:36 +0000 (18:15 +0000)]
Reformat the "major changes" to 72 or so columns.
Peter Eisentraut [Sat, 17 Mar 2001 18:08:14 +0000 (18:08 +0000)]
Repair.
Peter Eisentraut [Sat, 17 Mar 2001 16:27:31 +0000 (16:27 +0000)]
Tuning for docbook2man.
Thomas G. Lockhart [Sat, 17 Mar 2001 01:53:22 +0000 (01:53 +0000)]
New updates from Roberto Mello sent privately today due to email troubles.
Peter Eisentraut [Fri, 16 Mar 2001 22:12:13 +0000 (22:12 +0000)]
Make note that version 1.1.8 doesn't work.
Marc G. Fournier [Fri, 16 Mar 2001 21:49:51 +0000 (21:49 +0000)]
Generated Changelog since last Beta ...
Marc G. Fournier [Fri, 16 Mar 2001 21:29:15 +0000 (21:29 +0000)]
upgrade version to beta6
Tom Lane [Fri, 16 Mar 2001 17:42:56 +0000 (17:42 +0000)]
Documentation update from Marko Kreen.
Michael Meskes [Fri, 16 Mar 2001 13:05:57 +0000 (13:05 +0000)]
Fixed bug in handling of pointers to structs.
Hiroshi Inoue [Fri, 16 Mar 2001 13:03:04 +0000 (13:03 +0000)]
Oops I forgot to add new files for multibyte support.
Sorry Eiji.
Tom Lane [Fri, 16 Mar 2001 05:44:33 +0000 (05:44 +0000)]
Support syncing WAL log to disk using either fsync(), fdatasync(),
O_SYNC, or O_DSYNC (as available on a given platform). Add GUC parameter
to control sync method.
Also, add defense to XLogWrite to prevent it from going nuts if passed
a target write position that's past the end of the buffers so far filled
by XLogInsert.
Tom Lane [Fri, 16 Mar 2001 05:08:39 +0000 (05:08 +0000)]
Resetting the XLOG can't include rewinding it to logical position zero,
because we need page LSNs stored in the main database to be less than
the current XLOG position. Hence, generate the new XLOG segment at last
old segment number plus one.
Hiroshi Inoue [Fri, 16 Mar 2001 01:17:23 +0000 (01:17 +0000)]
Add multibyte support.
Provide an extenisible scheme of encoding conversion.
As the first step, SJIS and BIG5 are supported.
From now on multibyte people would be happy to use
this psqlodbc driver.
Eiji Tokuya e-tokuya@mail.sankyo-unyu.co.jp
Tom Lane [Thu, 15 Mar 2001 20:01:32 +0000 (20:01 +0000)]
Update sample error messages to agree with current code.
D'Arcy J.M. Cain [Thu, 15 Mar 2001 11:56:05 +0000 (11:56 +0000)]
Fix parameter handling.
Fix a bug where cs.execute('select %d + %d', (1, 2)) would get interpreted
as cs.executemany('select %d + %d', (1, 2))
D'Arcy J.M. Cain [Thu, 15 Mar 2001 11:26:22 +0000 (11:26 +0000)]
Add WIN32 support.
Tom Lane [Thu, 15 Mar 2001 01:07:51 +0000 (01:07 +0000)]
Improve description of to_char templates.
Tom Lane [Wed, 14 Mar 2001 23:55:33 +0000 (23:55 +0000)]
Give a more reasonable error message for a bad attribute name applied
to a join or subselect alias ... cf. Oliver Elphick's complaint 13-Mar.
Peter Eisentraut [Wed, 14 Mar 2001 22:20:02 +0000 (22:20 +0000)]
Fix markup.
Tom Lane [Wed, 14 Mar 2001 21:50:32 +0000 (21:50 +0000)]
Reduce amount of memory used per tuple for after-event triggers. This
is still a memory leak, but a little less bad than it was.
Tom Lane [Wed, 14 Mar 2001 21:47:50 +0000 (21:47 +0000)]
COPY should handle after-insert triggers the same as execMain.c does.
I'm not sure that it's really necessary to save insert events when there
are only after update or delete triggers, but certainly it's wrong for
COPY to behave differently from an INSERT query.
Peter Eisentraut [Wed, 14 Mar 2001 21:16:57 +0000 (21:16 +0000)]
A much better version of this is now in backend/port/aix.
Peter Eisentraut [Wed, 14 Mar 2001 21:11:53 +0000 (21:11 +0000)]
It's "gmake dist" now.
Peter Eisentraut [Wed, 14 Mar 2001 21:07:16 +0000 (21:07 +0000)]
For some ungodly reason my etags doesn't have an --output option, but it
does have -o.
Peter Eisentraut [Wed, 14 Mar 2001 21:03:38 +0000 (21:03 +0000)]
We're past Postgres95 now, and I'm sure Jolly doesn't want to receive any
bug reports. ;-)
Peter Eisentraut [Wed, 14 Mar 2001 20:53:13 +0000 (20:53 +0000)]
We got automatic dependencies now.
Peter Eisentraut [Wed, 14 Mar 2001 20:47:24 +0000 (20:47 +0000)]
We're way past 6.3 ...
Peter Eisentraut [Wed, 14 Mar 2001 20:44:40 +0000 (20:44 +0000)]
Update. Things are now build through 'make'.
Tom Lane [Wed, 14 Mar 2001 20:23:04 +0000 (20:23 +0000)]
Use SEP_CHAR consistently in forming XLOG pathnames.
Tom Lane [Wed, 14 Mar 2001 20:12:10 +0000 (20:12 +0000)]
Remove obsolete PowerPC-specific hack for comparisons to DBL_MIN
(per recent discussion with Tatsuo). Hopefully the compilers with
that old bug are all long gone.
Tom Lane [Wed, 14 Mar 2001 19:35:12 +0000 (19:35 +0000)]
Move -Bsymbolic for HPUX to Makefile.hpux, per Peter E's recommendation.
Bruce Momjian [Wed, 14 Mar 2001 19:28:51 +0000 (19:28 +0000)]
Update TODO list.
Bruce Momjian [Wed, 14 Mar 2001 18:24:34 +0000 (18:24 +0000)]
'waiting' status display had extra space, removed.
Change the administrator to 'an' administrator.
Peter Eisentraut [Wed, 14 Mar 2001 18:00:09 +0000 (18:00 +0000)]
Try to run empty test program before running any real AC_TRY_RUN's, to
prevent disguised failures.
Tom Lane [Wed, 14 Mar 2001 17:58:46 +0000 (17:58 +0000)]
Don't go belly-up if fork() fails for a routine checkpoint subprocess.
Just try again later.
Tom Lane [Wed, 14 Mar 2001 16:50:37 +0000 (16:50 +0000)]
Fix numeric modulo operator for case of fractional right argument.
Bruce Momjian [Wed, 14 Mar 2001 15:14:35 +0000 (15:14 +0000)]
New shutdown wording:
This connection has been terminated by the administrator
Hiroshi Inoue [Wed, 14 Mar 2001 09:10:04 +0000 (09:10 +0000)]
Fix some memory leaks.
Hiroshi Inoue [Wed, 14 Mar 2001 08:40:57 +0000 (08:40 +0000)]
ifdef out reindex stuff in VACUUM for safety.
Tom Lane [Wed, 14 Mar 2001 00:57:43 +0000 (00:57 +0000)]
First cut at XLOG file reset utility.
Could do with more testing, but it works in the simple cases.
Peter Eisentraut [Tue, 13 Mar 2001 21:37:15 +0000 (21:37 +0000)]
Provide more useful error message if 'postgres -V' failed. Advertise
pg_ctl '-l' option.
Peter Eisentraut [Tue, 13 Mar 2001 20:52:04 +0000 (20:52 +0000)]
update
Peter Eisentraut [Tue, 13 Mar 2001 20:42:11 +0000 (20:42 +0000)]
update
Tom Lane [Tue, 13 Mar 2001 20:32:37 +0000 (20:32 +0000)]
Change xlog page-header format to include StartUpID. Use the SUI to
detect case that next page in log came from an older run than the prior
page. This avoids the necessity to re-zero the log after recovery from
a crash, which is good because we need not risk destroying valuable log
information.
This forces another initdb since yesterday :-(. Need to get that log
reset utility done...
Peter Eisentraut [Tue, 13 Mar 2001 19:28:02 +0000 (19:28 +0000)]
'test -e' isn't portable. Use 'test -f'.
Bruce Momjian [Tue, 13 Mar 2001 14:41:09 +0000 (14:41 +0000)]
Update FAQ.
Philip Warner [Tue, 13 Mar 2001 14:08:18 +0000 (14:08 +0000)]
Document changed features of pg_dump, including:
- Large Object dumps
- Compressed custom format
- Requirement to use template0 when creating DB
Philip Warner [Tue, 13 Mar 2001 13:18:44 +0000 (13:18 +0000)]
- Use subselect when enabling triggers,
- Use exact table names when enabling/disabling triggers
Hiroshi Inoue [Tue, 13 Mar 2001 09:03:24 +0000 (09:03 +0000)]
The attached file contains the registry settings required to install the
ODBC driver on Windows 9X/ME/NT/2K when using the later versions of the
driver that don't have the Installshield installation:
1) Install psqlodbc.dll in to C:\Windows\System or C:\Winnt\System32
2) Add the registry settings in the attached file using regedit.
A useful addition to src/interfaces/odbc perhaps?
Regards, Dave.
Tom Lane [Tue, 13 Mar 2001 01:17:40 +0000 (01:17 +0000)]
Update for new pg_control format.
Tom Lane [Tue, 13 Mar 2001 01:17:06 +0000 (01:17 +0000)]
XLOG (and related) changes:
* Store two past checkpoint locations, not just one, in pg_control.
On startup, we fall back to the older checkpoint if the newer one
is unreadable. Also, a physical copy of the newest checkpoint record
is kept in pg_control for possible use in disaster recovery (ie,
complete loss of pg_xlog). Also add a version number for pg_control
itself. Remove archdir from pg_control; it ought to be a GUC
parameter, not a special case (not that it's implemented yet anyway).
* Suppress successive checkpoint records when nothing has been entered
in the WAL log since the last one. This is not so much to avoid I/O
as to make it actually useful to keep track of the last two
checkpoints. If the things are right next to each other then there's
not a lot of redundancy gained...
* Change CRC scheme to a true 64-bit CRC, not a pair of 32-bit CRCs
on alternate bytes. Polynomial borrowed from ECMA DLT1 standard.
* Fix XLOG record length handling so that it will work at BLCKSZ = 32k.
* Change XID allocation to work more like OID allocation. (This is of
dubious necessity, but I think it's a good idea anyway.)
* Fix a number of minor bugs, such as off-by-one logic for XLOG file
wraparound at the 4 gig mark.
* Add documentation and clean up some coding infelicities; move file
format declarations out to include files where planned contrib
utilities can get at them.
* Checkpoint will now occur every CHECKPOINT_SEGMENTS log segments or
every CHECKPOINT_TIMEOUT seconds, whichever comes first. It is also
possible to force a checkpoint by sending SIGUSR1 to the postmaster
(undocumented feature...)
* Defend against kill -9 postmaster by storing shmem block's key and ID
in postmaster.pid lockfile, and checking at startup to ensure that no
processes are still connected to old shmem block (if it still exists).
* Switch backends to accept SIGQUIT rather than SIGUSR1 for emergency
stop, for symmetry with postmaster and xlog utilities. Clean up signal
handling in bootstrap.c so that xlog utilities launched by postmaster
will react to signals better.
* Standalone bootstrap now grabs lockfile in target directory, as added
insurance against running it in parallel with live postmaster.
Tom Lane [Mon, 12 Mar 2001 23:02:00 +0000 (23:02 +0000)]
Avoid O(N^2) behavior in deferredTriggerAddEvent() for large numbers of
tuples inserted/deleted/updated in a single transaction. On my machine,
this reduced the time to delete 80000 tuples in a foreign-key-referencing
table from ~15min to ~8sec.
Bruce Momjian [Sun, 11 Mar 2001 19:26:58 +0000 (19:26 +0000)]
Update TODO list.