OSDN Git Service
Bruce Momjian [Fri, 24 Dec 2004 18:37:26 +0000 (18:37 +0000)]
Back out Win32 changes until Tom is done.
Bruce Momjian [Fri, 24 Dec 2004 18:32:50 +0000 (18:32 +0000)]
Adjust documention for Win32 installation options.
Bruce Momjian [Fri, 24 Dec 2004 18:11:16 +0000 (18:11 +0000)]
Update docs for Win32 installation, per Tom.
Bruce Momjian [Fri, 24 Dec 2004 17:19:23 +0000 (17:19 +0000)]
Updates from Ian Barwick.
Update FAQ with new URL's for site.
Bruce Momjian [Fri, 24 Dec 2004 17:13:51 +0000 (17:13 +0000)]
Update FAQ.
Tom Lane [Fri, 24 Dec 2004 16:55:43 +0000 (16:55 +0000)]
Remove 'optimization' to skip resolve_symlinks() when the found
executable file isn't itself a symlink. We still need to run the
algorithm so that any directory symlinks in the path to the
executable are replaced by a true path. Noticed this on seeing
pg_config give me a completely wrong answer for --pkglibdir when
I called it through a symlink to the installation bindir.
Bruce Momjian [Fri, 24 Dec 2004 16:02:36 +0000 (16:02 +0000)]
Update FAQ with new URL's for site.
Tom Lane [Fri, 24 Dec 2004 15:42:05 +0000 (15:42 +0000)]
Switch order of WHERE clauses in tab completion queries, as suggested
by Rod Taylor. The foo_is_visible() functions are relatively slow and
so it pays to check them after checking the name pattern match.
Tom Lane [Thu, 23 Dec 2004 23:07:38 +0000 (23:07 +0000)]
More minor updates and copy-editing.
Tom Lane [Thu, 23 Dec 2004 22:42:15 +0000 (22:42 +0000)]
Avoid memory leakage during VACUUM FULL when an index expression or
index predicate uses temporary memory for evaluation. Per example
from Jean-Gerard Pailloncy.
Bruce Momjian [Thu, 23 Dec 2004 13:19:17 +0000 (13:19 +0000)]
Add missing ecpg prototype for newly added functions.
Michael Meskes [Thu, 23 Dec 2004 10:46:10 +0000 (10:46 +0000)]
Added PGTYPEStimestamp_add_interval written by Dave Cramer.
Fixed parsing of defines to make sure they used more than once.
Tom Lane [Thu, 23 Dec 2004 05:37:40 +0000 (05:37 +0000)]
A small pass of docs review and copy-editing.
Tom Lane [Thu, 23 Dec 2004 03:49:40 +0000 (03:49 +0000)]
Use float8-small-is-zero for netbsd on m68k, per Rémi Zara.
Tom Lane [Thu, 23 Dec 2004 00:03:24 +0000 (00:03 +0000)]
Remove extra parenthesis.
Tom Lane [Wed, 22 Dec 2004 18:45:49 +0000 (18:45 +0000)]
Awhile back I added some code to StartupCLOG() to forcibly zero out
the remainder of the current clog page during system startup. While
this was a good idea, it turns out the code fails if nextXid is
exactly at a page boundary, because we won't have created the "current"
clog page yet in that case. Since the page will be correctly zeroed
when we execute the first transaction on it, the solution is just to
do nothing when exactly at a page boundary. Per trouble report from
Dave Hartwig.
Bruce Momjian [Wed, 22 Dec 2004 02:17:15 +0000 (02:17 +0000)]
Add mention that pg_ctl will return an accurate exit code when waiting
for startup or shutdown. We have always done this but it wasn't documented.
Tom Lane [Tue, 21 Dec 2004 18:47:42 +0000 (18:47 +0000)]
Add '-Wl,' prefix to linker switches consistently. Remove shlib_symbolic
macros, which aren't used anywhere and haven't been for some time.
Tom Lane [Tue, 21 Dec 2004 18:33:36 +0000 (18:33 +0000)]
exec_eval_simple_expr() needs to do CommandCounterIncrement() not just
GetTransactionSnapshot() to ensure ActiveSnapshot advances properly.
Sigh. Extend regression test so it reveals this error too.
Bruce Momjian [Tue, 21 Dec 2004 17:58:30 +0000 (17:58 +0000)]
Add error checking for starting a win32 service using pg_ctl.
Bruce Momjian [Tue, 21 Dec 2004 17:38:01 +0000 (17:38 +0000)]
Return proper error exit code on pg_ctl -w start failure.
Peter Eisentraut [Tue, 21 Dec 2004 11:14:18 +0000 (11:14 +0000)]
Translation update
PostgreSQL Daemon [Tue, 21 Dec 2004 02:53:33 +0000 (02:53 +0000)]
tag files for rc2
Tom Lane [Tue, 21 Dec 2004 02:14:41 +0000 (02:14 +0000)]
Patch to make libpq.rc be a built-for-distribution file was a few
bricks shy of a load.
Bruce Momjian [Tue, 21 Dec 2004 01:23:54 +0000 (01:23 +0000)]
Add:
> * Allow the PITR process to be debugged and data examined
Bruce Momjian [Tue, 21 Dec 2004 01:21:50 +0000 (01:21 +0000)]
Add:
> * Allow a warm standby system to also allow read-only queries
Bruce Momjian [Tue, 21 Dec 2004 01:02:28 +0000 (01:02 +0000)]
I was recently surprised to find that EXTRACT's day of the week
numbering is different than TO_CHAR's ditto. EXTRACT starts at 0==Sunday
while TO_CHAR starts at 1==Sunday.
A suggestion for two documentation notes is attached as a patch to
current CVS HEAD.
Troels Arvin
Bruce Momjian [Mon, 20 Dec 2004 21:00:48 +0000 (21:00 +0000)]
Mention libpq.rc.in is now the file to update for releases.
Tom Lane [Mon, 20 Dec 2004 19:17:56 +0000 (19:17 +0000)]
Ensure that 'disabling statistics collector' is logged in all failure
paths of pgstat_init. Responds to confusion exhibited by Christoph Haller.
Tom Lane [Mon, 20 Dec 2004 19:00:37 +0000 (19:00 +0000)]
Add support for Latin9 encoding in to_ascii(). Jaime Casanova
Tom Lane [Mon, 20 Dec 2004 18:15:07 +0000 (18:15 +0000)]
Mark the TimeZone parameter as GUC_REPORT, so that JDBC can find out
when it changes. Per request from Kris Jurka.
Tom Lane [Mon, 20 Dec 2004 17:40:59 +0000 (17:40 +0000)]
In pipe_read_line Windows code, loop to ensure we get a whole line
from the child process; fixes observed problems when the returned
version number is '8.0.0' rather than '8.0.0rc1'. Magnus Hagander
Tom Lane [Mon, 20 Dec 2004 17:13:41 +0000 (17:13 +0000)]
Remove direct inclusions of <com_err.h> as well as configure test for
its presence. This amounts to desupporting Kerberos 5 releases 1.0.*,
which is small loss, and simplifies use of our Kerberos code on platforms
with Red-Hat-style include file layouts. Per gripe from John Gray and
followup discussion.
Tom Lane [Mon, 20 Dec 2004 01:42:11 +0000 (01:42 +0000)]
Adjust pg_resetxlog to handle 8.0 WAL file names properly.
Tom Lane [Sun, 19 Dec 2004 22:10:41 +0000 (22:10 +0000)]
Fix broken markup.
Tom Lane [Sun, 19 Dec 2004 20:20:27 +0000 (20:20 +0000)]
plpgsql's exec_eval_simple_expr() now has to take responsibility for
advancing ActiveSnapshot when we are inside a volatile function.
Per example from Gaetano Mendola. Add a regression test to catch
similar problems in future.
Tom Lane [Sun, 19 Dec 2004 19:39:47 +0000 (19:39 +0000)]
Prevent evaluation of backticks while discarding unwanted arguments
after an unknown or failed psql backslash command, and also while
discarding "extra" arguments of a putatively valid backslash command.
In the case of an unknown/failed command, make sure we discard the
whole rest of the line, rather than trying to resume at the next
backslash. Per discussion with Thomer Gil.
Bruce Momjian [Sun, 19 Dec 2004 04:36:27 +0000 (04:36 +0000)]
Add:
> * Allow psql \pset boolean variables to set to fixed values, rather than toggle
Bruce Momjian [Sun, 19 Dec 2004 04:09:48 +0000 (04:09 +0000)]
Mention why unixware doesn't handle threading in 8.0.
Bruce Momjian [Sun, 19 Dec 2004 04:06:23 +0000 (04:06 +0000)]
Test for POSIX.1c 2-arg sigwait() and fail on single-arg version.
Bruce Momjian [Sun, 19 Dec 2004 02:16:31 +0000 (02:16 +0000)]
Add Win32 version stamps that increment each day for proper SYSTEM32
DLL pginstaller installs.
Bruce Momjian [Sat, 18 Dec 2004 22:12:52 +0000 (22:12 +0000)]
Allow NetBSD, m64k to compile the ASM spinlock code.
R?mi Zara
Tom Lane [Sat, 18 Dec 2004 18:36:33 +0000 (18:36 +0000)]
Add note warning that OS X updates usually overwrite /etc/rc.
Bruce Momjian [Sat, 18 Dec 2004 04:21:43 +0000 (04:21 +0000)]
Changes the doc's to reflect what the user will find as default.
Robert Treat
Bruce Momjian [Sat, 18 Dec 2004 04:18:21 +0000 (04:18 +0000)]
Many thanks to Joachim Wieland for a big list of corrections / updates.
Ian Barwick
Bruce Momjian [Sat, 18 Dec 2004 04:13:20 +0000 (04:13 +0000)]
Update from Ian Barwick
Tom Lane [Fri, 17 Dec 2004 20:59:58 +0000 (20:59 +0000)]
Make array_cat more paranoid about checking datatypes in empty arrays.
Tom Lane [Fri, 17 Dec 2004 20:58:26 +0000 (20:58 +0000)]
array_map failed to insert correct result type in an empty array.
Per example from Florian Pflug.
Tom Lane [Fri, 17 Dec 2004 04:50:32 +0000 (04:50 +0000)]
Minor copy-editing in tutorial.
Tom Lane [Fri, 17 Dec 2004 03:52:49 +0000 (03:52 +0000)]
In a PGXS build, expect to find the postgres executable already installed,
rather than in $(top_builddir)/src/backend/postgres. Sean Chittenden
Neil Conway [Fri, 17 Dec 2004 03:51:36 +0000 (03:51 +0000)]
Allow 'ELSEIF' as an alternative to 'ELSIF' in PL/PgSQL. There have been
several reports of users being confused when they attempt to use ELSEIF
and run into trouble due to PL/PgSQL's lax parser. The parser will be
improved for 8.1, but we can fix most of the problem by allowing ELSEIF
for now.
Tom Lane [Fri, 17 Dec 2004 02:14:48 +0000 (02:14 +0000)]
Hook up the plpython result-object nrows and status methods correctly.
Adjust documentation to match current reality.
Tom Lane [Fri, 17 Dec 2004 00:10:36 +0000 (00:10 +0000)]
Fix is-it-time-for-a-checkpoint logic so that checkpoint_segments can
usefully be larger than 255. Per gripe from Simon Riggs.
Bruce Momjian [Fri, 17 Dec 2004 00:04:30 +0000 (00:04 +0000)]
Add Win32:
> o Disallow encodings like UTF8 which which PostgreSQL supports
> but the operating system does not (already disallowed by
> pginstaller)
Bruce Momjian [Thu, 16 Dec 2004 22:11:06 +0000 (22:11 +0000)]
Update release changes list to mention pg_config.h.win32.
Bruce Momjian [Thu, 16 Dec 2004 22:05:07 +0000 (22:05 +0000)]
Update version for Win32-client include file.
Tom Lane [Thu, 16 Dec 2004 20:41:01 +0000 (20:41 +0000)]
Cause configure --with-tcl to check for presence of <tcl.h>, as per
gripe from John Gray. Also fix thinko in pltcl Makefile: if a special
Tcl include directory is specified, that ought to be searched first.
Bruce Momjian [Thu, 16 Dec 2004 18:13:07 +0000 (18:13 +0000)]
Allow --enable-thread-safety with --disable-shared libraries by passing
PTHREAD_LIBS to all libpq-usage builds.
Bruce Momjian [Thu, 16 Dec 2004 17:48:29 +0000 (17:48 +0000)]
Allow AIX to use --enable-thread-safety by passing PTHREAD_LIBS to
binary compiles, and adjust configure tests for AIX.
Peter Eisentraut [Thu, 16 Dec 2004 11:31:55 +0000 (11:31 +0000)]
Translation updates
Peter Eisentraut [Thu, 16 Dec 2004 11:23:16 +0000 (11:23 +0000)]
Add port report
Bruce Momjian [Thu, 16 Dec 2004 01:08:23 +0000 (01:08 +0000)]
Add French IRC channel.
Bruce Momjian [Thu, 16 Dec 2004 00:01:33 +0000 (00:01 +0000)]
Add Spanish IRC channel to FAQ.
Tom Lane [Wed, 15 Dec 2004 21:13:34 +0000 (21:13 +0000)]
Fix another place broken by new List implementation :-(. Per example
from goranpop@nspoint.net. I think this escaped notice because in
simple cases the list is NIL on entry.
Tom Lane [Wed, 15 Dec 2004 20:15:17 +0000 (20:15 +0000)]
Disallow SETOF in the input of parseTypeString(). Formerly it was
silently ignored, allowing one to write bizarre things like
DECLARE x setof int;
in plpgsql. This has misled at least one novice into thinking that
plpgsql variables could be sets ...
Tom Lane [Wed, 15 Dec 2004 19:16:39 +0000 (19:16 +0000)]
Calculation of keys_are_unique flag was wrong for cases involving
redundant cross-datatype comparisons. Per example from Merlin Moncure.
Peter Eisentraut [Wed, 15 Dec 2004 17:50:20 +0000 (17:50 +0000)]
New translations
Peter Eisentraut [Wed, 15 Dec 2004 17:39:54 +0000 (17:39 +0000)]
Translation updates
Peter Eisentraut [Wed, 15 Dec 2004 17:14:11 +0000 (17:14 +0000)]
Translation update
Bruce Momjian [Wed, 15 Dec 2004 03:11:26 +0000 (03:11 +0000)]
Update IRC mention.
Tom Lane [Tue, 14 Dec 2004 22:50:23 +0000 (22:50 +0000)]
In 'make installcheck' for contrib/, insert 'sleep 1' between subdirectory
checks, to ensure the previous test backend has time to quit out of the
regression database. Also, allow all the checks to be run even if one
of them fails. Per suggestions from Andrew Dunstan to improve the
usefulness of buildfarm testing.
Tom Lane [Tue, 14 Dec 2004 22:16:32 +0000 (22:16 +0000)]
Cope with circularities involving a view's ON SELECT rule. I originally
thought there couldn't be any, but the folly of this was exposed by an
example from andrew@supernews.com 5-Dec-2004. The patch applies the
identical logic already used for table constraints and defaults to ON
SELECT rules, so I have reasonable confidence in it even though it might
look like complicated logic.
Tom Lane [Tue, 14 Dec 2004 21:35:20 +0000 (21:35 +0000)]
Fix pg_dump to ensure that a comment on a table CHECK constraint cannot
be emitted too soon. The previous code got this right in the case where
the CHECK was emitted as a separate ALTER TABLE command, but not in the
case where the CHECK is emitted right in CREATE TABLE. Per report from
Slawomir Sudnik.
Note: this code is pretty ugly; it'd perhaps be better to treat comments
as independently sortable dump objects. That'd be much too invasive a
change for RC time though.
Bruce Momjian [Tue, 14 Dec 2004 14:53:53 +0000 (14:53 +0000)]
Update aix cc_r wording.
Bruce Momjian [Tue, 14 Dec 2004 12:58:29 +0000 (12:58 +0000)]
Mention aix cc_r is not supported, and why
Peter Eisentraut [Tue, 14 Dec 2004 11:11:20 +0000 (11:11 +0000)]
Fix typo
Peter Eisentraut [Tue, 14 Dec 2004 10:24:27 +0000 (10:24 +0000)]
Add port reports
Neil Conway [Tue, 14 Dec 2004 01:59:41 +0000 (01:59 +0000)]
Prevent pg_resetxlog from being run as root. If this is allowed, some
root-owned files will be written to the data directory, leaving it in an
unusable state.
Peter Eisentraut [Tue, 14 Dec 2004 00:36:12 +0000 (00:36 +0000)]
Add more port reports.
Peter Eisentraut [Mon, 13 Dec 2004 22:54:20 +0000 (22:54 +0000)]
New translation
Peter Eisentraut [Mon, 13 Dec 2004 21:49:10 +0000 (21:49 +0000)]
Translation updates
Bruce Momjian [Mon, 13 Dec 2004 18:40:30 +0000 (18:40 +0000)]
Remove:
< o Allow the shared memory address to be configured via GUC
Peter Eisentraut [Mon, 13 Dec 2004 18:05:10 +0000 (18:05 +0000)]
Spell checker run
Bruce Momjian [Mon, 13 Dec 2004 18:00:51 +0000 (18:00 +0000)]
Done:
< o Remove per-backend parameter file and move into shared memory
Add for Win32:
> o Allow the shared memory address to be configured via GUC
Bruce Momjian [Mon, 13 Dec 2004 17:28:54 +0000 (17:28 +0000)]
Clearify which version numbers are bumped for major and minor releases.
Peter Eisentraut [Mon, 13 Dec 2004 16:30:53 +0000 (16:30 +0000)]
New translations
Peter Eisentraut [Mon, 13 Dec 2004 16:28:23 +0000 (16:28 +0000)]
Translation updates
Bruce Momjian [Mon, 13 Dec 2004 14:21:32 +0000 (14:21 +0000)]
Add:
>
> * Allow the size of the buffer cache used by temporary objects to be
> specified as a GUC variable
>
> Larger local buffer cache sizes requires more efficient handling of
> local cache lookups.
Bruce Momjian [Mon, 13 Dec 2004 03:37:09 +0000 (03:37 +0000)]
Update FAQ.
Euler Taveira de Oliveira
Tom Lane [Mon, 13 Dec 2004 00:33:06 +0000 (00:33 +0000)]
Avoid generating excess (and illegal) parentheses around an aliased JOIN
in prettyprint mode. Andreas Pflug
Neil Conway [Sun, 12 Dec 2004 22:49:50 +0000 (22:49 +0000)]
Add regression tests for the fix committed by Tom for casting between
the row types of parent/child tables.
Tom Lane [Sun, 12 Dec 2004 20:17:06 +0000 (20:17 +0000)]
PREPARE and EXPLAIN need to copy the source query just like we recently
had to do in DECLARE CURSOR. AFAICS these are all the places affected.
PREPARE case per example from Michael Fuhr, EXPLAIN case located by
grepping for planner calls ...
Peter Eisentraut [Sun, 12 Dec 2004 18:26:29 +0000 (18:26 +0000)]
Add missing newlines at end of error messages.
Peter Eisentraut [Sun, 12 Dec 2004 18:09:18 +0000 (18:09 +0000)]
Translation updates
Peter Eisentraut [Sun, 12 Dec 2004 15:34:15 +0000 (15:34 +0000)]
Fix problems with certain shells (e.g., FreeBSD, Cygwin) clearing the
exit status in multiline traps.
Tom Lane [Sun, 12 Dec 2004 05:07:50 +0000 (05:07 +0000)]
Upgrade formrdesc() so that it can correctly initialize the tupledesc
(rd_att) field of a nailed-in-cache relcache entry. This fixes the bug
reported by Alvaro 8-Dec-2004; I believe it probably also explains
Grant Finnemore's report of 10-Sep-2004.
In an unrelated change in the same file, put back 7.4's response to
failure to rename() the relcache init file, ie, unlink the useless
temp file. I did not put back the warning message, since there might
actually be some reason not to have that.
Tom Lane [Sat, 11 Dec 2004 23:26:51 +0000 (23:26 +0000)]
Instead of supposing (wrongly, in the general case) that the rowtype
of an inheritance child table is binary-compatible with the rowtype of
its parent, invent an expression node type that does the conversion
correctly. Fixes the new bug exhibited by Kris Shannon as well as a
lot of old bugs that would only show up when using multiple inheritance
or after altering the parent table.
Peter Eisentraut [Sat, 11 Dec 2004 20:54:14 +0000 (20:54 +0000)]
Added port reports
Peter Eisentraut [Sat, 11 Dec 2004 20:19:24 +0000 (20:19 +0000)]
Translation updates
Peter Eisentraut [Sat, 11 Dec 2004 20:10:14 +0000 (20:10 +0000)]
Translation updates