Tom Lane [Thu, 6 Jan 2005 21:20:44 +0000 (21:20 +0000)]
Spell APPDATA as %APPDATA%, per recommendation from Magnus.
Tom Lane [Thu, 6 Jan 2005 21:00:24 +0000 (21:00 +0000)]
Don't list port twice in SUBDIRS. Caught by Honda Shigehiro.
Tom Lane [Thu, 6 Jan 2005 20:56:50 +0000 (20:56 +0000)]
Revert -Wl, change to Makefile.osf, as the allegedly more standard
syntax apparently does not work for all toolchains on that platform.
Per Honda Shigehiro.
Tom Lane [Thu, 6 Jan 2005 20:53:34 +0000 (20:53 +0000)]
Adjust examples to avoid using keywords as identifiers, per Honda Shigehiro.
Tom Lane [Thu, 6 Jan 2005 20:06:58 +0000 (20:06 +0000)]
Instead of a bare recv() to read the server's response to an SSL
request packet, use pqReadData(). This has the same effect since
conn->ssl isn't set yet and we aren't expecting more than one byte.
The advantage is that we will correctly detect loss-of-connection
instead of going into an infinite loop. Per report from Hannu Krosing.
Tom Lane [Thu, 6 Jan 2005 18:29:11 +0000 (18:29 +0000)]
Adjust lookup of client-side profile files (.pgpass and so on) as per
discussion on pgsql-hackers-win32 list. Documentation still needs to
be tweaked --- I'm not sure how to refer to the APPDATA folder in
user documentation.
Dennis Bjorklund [Thu, 6 Jan 2005 12:23:33 +0000 (12:23 +0000)]
Translation updates
Dennis Bjorklund [Thu, 6 Jan 2005 12:14:36 +0000 (12:14 +0000)]
Translation updates
Dennis Bjorklund [Thu, 6 Jan 2005 11:44:12 +0000 (11:44 +0000)]
Translation updates
Peter Eisentraut [Thu, 6 Jan 2005 10:12:22 +0000 (10:12 +0000)]
Update to supported platforms list
Peter Eisentraut [Thu, 6 Jan 2005 09:07:17 +0000 (09:07 +0000)]
Translation updates
Peter Eisentraut [Thu, 6 Jan 2005 08:46:07 +0000 (08:46 +0000)]
Translation updates
Tom Lane [Thu, 6 Jan 2005 01:49:24 +0000 (01:49 +0000)]
More minor updates and copy-editing.
Tom Lane [Thu, 6 Jan 2005 01:00:12 +0000 (01:00 +0000)]
Make the various places that determine the user's "home directory"
consistent. On Unix we now always consult getpwuid(); $HOME isn't used
at all. On Windows the code currently consults $USERPROFILE, or $HOME
if that's not defined, but I expect this will change as soon as the win32
hackers come to a consensus. Nothing done yet about changing the file
names used underneath $USERPROFILE.
Tom Lane [Thu, 6 Jan 2005 00:11:56 +0000 (00:11 +0000)]
Keep translations in step with synopses.
Tom Lane [Thu, 6 Jan 2005 00:11:14 +0000 (00:11 +0000)]
Re-readjust synopses for CREATE/ALTER USER.
Tom Lane [Wed, 5 Jan 2005 23:42:03 +0000 (23:42 +0000)]
More minor updates and copy-editing.
Bruce Momjian [Wed, 5 Jan 2005 22:37:28 +0000 (22:37 +0000)]
Update URL's to point to new site main location.
Bruce Momjian [Wed, 5 Jan 2005 18:03:19 +0000 (18:03 +0000)]
Fix example, change table name from 'array' to 'array_int'.
Bruce Momjian [Wed, 5 Jan 2005 17:52:28 +0000 (17:52 +0000)]
Update date stamp.
Bruce Momjian [Wed, 5 Jan 2005 17:42:09 +0000 (17:42 +0000)]
Update URLs.
Peter Eisentraut [Wed, 5 Jan 2005 14:22:39 +0000 (14:22 +0000)]
Revert cosmetic synopsis changes that break psql translations.
Tom Lane [Tue, 4 Jan 2005 23:18:25 +0000 (23:18 +0000)]
Clean up code in libpq that obtains user's home directory: make a single
subroutine that can hide platform dependencies. The WIN32 path is still
a stub, but I await a fix from one of the win32 hackers.
Also clean up unnecessary #ifdef WIN32 ugliness in a couple of places.
Tom Lane [Tue, 4 Jan 2005 22:27:46 +0000 (22:27 +0000)]
Make pg_dump --oids work when default_with_oids = off. Per report from
Michael Fuhr.
Peter Eisentraut [Tue, 4 Jan 2005 21:03:30 +0000 (21:03 +0000)]
Add some post-processing to the man page generation to fix up external/
dangling cross-references.
Peter Eisentraut [Tue, 4 Jan 2005 19:42:01 +0000 (19:42 +0000)]
Translation update
Bruce Momjian [Tue, 4 Jan 2005 14:25:16 +0000 (14:25 +0000)]
Remove duplicate novell mention.
Tom Lane [Tue, 4 Jan 2005 08:59:45 +0000 (08:59 +0000)]
Fix subsection ordering (DISTINCT should be described before LIMIT).
Peter Eisentraut [Tue, 4 Jan 2005 07:06:01 +0000 (07:06 +0000)]
Fix typo
Bruce Momjian [Tue, 4 Jan 2005 05:35:45 +0000 (05:35 +0000)]
Update wording:
< * Allow building with directories containing spaces
> * Allow building in directories containing spaces
< There are two capabilities here, first the ability to build from a
< source directory that contains spaces, and second the ability to install
< into a directory that contains spaces. The first is probably not
< possible because 'gmake' and other compiler tools do not fully support
< spaces in path names. The second is possible with proper quoting in
< the makefiles. Because PostgreSQL supports relocatable installs, it
< is possible to install into a directory that doesn't contain spaces and
< then copy the install to a directory with spaces.
> This is probably not possible because 'gmake' and other compiler tools
> do not fully support quoting of paths with spaces.
>
> * Allow installing to directories containing spaces
>
> This is possible if proper quoting is added to the makefiles for the
> install targets. Because PostgreSQL supports relocatable installs, it
> is already possible to install into a directory that doesn't contain
> spaces and then copy the install to a directory with spaces.
Bruce Momjian [Tue, 4 Jan 2005 05:13:39 +0000 (05:13 +0000)]
Update item for install with spaces:
> There are two capabilities here, first the ability to build from a
> source directory that contains spaces, and second the ability to install
> into a directory that contains spaces. The first is probably not
> possible because 'gmake' and other compiler tools do not fully support
> spaces in path names. The second is possible with proper quoting in
> the makefiles. Because PostgreSQL supports relocatable installs, it
> is possible to install into a directory that doesn't contain spaces and
> then copy the install to a directory with spaces.
Tom Lane [Tue, 4 Jan 2005 03:58:16 +0000 (03:58 +0000)]
More minor updates and copy-editing.
Bruce Momjian [Tue, 4 Jan 2005 03:47:03 +0000 (03:47 +0000)]
Update of Russian FAQ.
Viktor Vislobokov
Bruce Momjian [Tue, 4 Jan 2005 03:44:50 +0000 (03:44 +0000)]
HTML cleanup.
Bruce Momjian [Tue, 4 Jan 2005 03:43:28 +0000 (03:43 +0000)]
Add OS/2 port mention.
Tom Lane [Tue, 4 Jan 2005 00:39:53 +0000 (00:39 +0000)]
More minor updates and copy-editing.
Bruce Momjian [Tue, 4 Jan 2005 00:05:45 +0000 (00:05 +0000)]
Add mention of performance impact on LIKE of non-C locales.
Peter Eisentraut [Mon, 3 Jan 2005 22:39:24 +0000 (22:39 +0000)]
Translation updates
Tom Lane [Mon, 3 Jan 2005 18:49:41 +0000 (18:49 +0000)]
Repair bufmgr deadlock problem reported by Michael Wildpaner. Must take
share lock on a buffer being written out before releasing BufMgrLock in
the BufferAlloc code path; if we do it later we might block on someone
who's re-pinned the buffer. I believe this is only an issue for BufferAlloc
and not the other places that call FlushBuffer. BufferSync must continue
to do it the old way since it may well be trying to write buffers that
other backends have pinned; but it should not be holding any conflicting
locks. FlushRelationBuffers is okay since it's got exclusive lock at the
relation level.
Bruce Momjian [Mon, 3 Jan 2005 06:16:54 +0000 (06:16 +0000)]
Update copyright script.
Bruce Momjian [Sun, 2 Jan 2005 21:08:14 +0000 (21:08 +0000)]
Add:
> * Allow building with directories containing spaces
Tom Lane [Sat, 1 Jan 2005 22:14:33 +0000 (22:14 +0000)]
Adjust a few more copyright notices to match the format expected by
the src/tools/copyright script.
Tom Lane [Sat, 1 Jan 2005 20:44:34 +0000 (20:44 +0000)]
Some more missed copyright notices. Many of these look like they
should have been caught by the src/tools/copyright script ... why
weren't they?
Bruce Momjian [Sat, 1 Jan 2005 17:29:17 +0000 (17:29 +0000)]
Update:
< the Win32 wcscoll() can be used.
> the Win32 wcscoll() can be used, and perhaps other functions
> like towupper().
Bruce Momjian [Sat, 1 Jan 2005 17:25:01 +0000 (17:25 +0000)]
Update:
< the Win32 strcoll() can be used.
> the Win32 wcscoll() can be used.
Bruce Momjian [Sat, 1 Jan 2005 16:36:57 +0000 (16:36 +0000)]
Update:
< o Disallow encodings like UTF8 which which PostgreSQL supports
> o Disallow encodings like UTF8 which PostgreSQL supports
914a915,917
>
> To fix UTF8, the data needs to be converted to UTF16 and then
> the Win32 strcoll() can be used.
Bruce Momjian [Sat, 1 Jan 2005 05:43:09 +0000 (05:43 +0000)]
Update copyrights that were missed.
PostgreSQL Daemon [Fri, 31 Dec 2004 22:22:24 +0000 (22:22 +0000)]
forgot to autoconf after tag'ng configure.in with rc3
PostgreSQL Daemon [Fri, 31 Dec 2004 22:04:05 +0000 (22:04 +0000)]
Tag appropriate files for rc3
Also performed an initial run through of upgrading our Copyright date to
extend to 2005 ... first run here was very simple ... change everything
where: grep 1996-2004 && the word 'Copyright' ... scanned through the
generated list with 'less' first, and after, to make sure that I only
picked up the right entries ...
Tom Lane [Fri, 31 Dec 2004 19:09:37 +0000 (19:09 +0000)]
Clean up win32ver.o on Windows, per Magnus.
Tom Lane [Fri, 31 Dec 2004 19:01:54 +0000 (19:01 +0000)]
make clean must remove zic$(X) for Windows, per Magnus.
Tom Lane [Thu, 30 Dec 2004 21:45:37 +0000 (21:45 +0000)]
More minor updates and copy-editing.
Michael Meskes [Thu, 30 Dec 2004 09:36:37 +0000 (09:36 +0000)]
Fixed segfault in connect when specifying no database name.
Tom Lane [Thu, 30 Dec 2004 03:13:56 +0000 (03:13 +0000)]
More updates and copy-editing. Rearrange order of sections a little bit
to put more widely useful info before less widely useful info.
Tom Lane [Thu, 30 Dec 2004 00:30:40 +0000 (00:30 +0000)]
Triggers should return TRIGGER not OPAQUE. Looks like this script got
overlooked in 7.3 updates. Not a critical fix but avoids a notice when
the resulting SQL script is executed.
Tom Lane [Wed, 29 Dec 2004 23:47:40 +0000 (23:47 +0000)]
Support Sun's compiler on SunOS4 (a/k/a Solaris 9). Per ayan@ayan.net
Tom Lane [Wed, 29 Dec 2004 23:36:47 +0000 (23:36 +0000)]
Convert external-projects to an appendix.
Tom Lane [Wed, 29 Dec 2004 21:36:09 +0000 (21:36 +0000)]
Refactor EXEC_BACKEND code so that postmaster child processes reattach
to shared memory as soon as possible, ie, right after read_backend_variables.
The effective difference from the original code is that this happens
before instead of after read_nondefault_variables(), which loads GUC
information and is apparently capable of expanding the backend's memory
allocation more than you'd think it should. This should fix the
failure-to-attach-to-shared-memory reports we've been seeing on Windows.
Also clean up a few bits of unnecessarily grotty EXEC_BACKEND code.
Peter Eisentraut [Wed, 29 Dec 2004 02:30:16 +0000 (02:30 +0000)]
Translation updates
Tom Lane [Tue, 28 Dec 2004 23:17:54 +0000 (23:17 +0000)]
Make libpq default to localhost connections on machines without Unix-domain
sockets, rather than failing as it formerly did. Revert the
thereby-obsoleted patch to make psql supply the localhost default.
Tom Lane [Tue, 28 Dec 2004 22:47:15 +0000 (22:47 +0000)]
More minor updates and copy-editing.
Tom Lane [Tue, 28 Dec 2004 19:08:58 +0000 (19:08 +0000)]
More minor updates and copy-editing.
Tom Lane [Tue, 28 Dec 2004 15:25:55 +0000 (15:25 +0000)]
BDST should be "British double SUMMER time", not Standard time.
Per John Smith.
Bruce Momjian [Mon, 27 Dec 2004 22:44:44 +0000 (22:44 +0000)]
Add:
> * Improve the background writer
>
> Allow the background writer to more efficiently write dirty buffers
> from the end of the LRU cache and use a clock sweep algorithm to
> write other dirty buffers to reduced checkpoint I/O
Tom Lane [Mon, 27 Dec 2004 22:30:10 +0000 (22:30 +0000)]
More minor updates and copy-editing.
Tom Lane [Mon, 27 Dec 2004 20:39:21 +0000 (20:39 +0000)]
Make sure --with-pgport option propagates into postgresql.conf.
Per gripe from Josh Berkus.
Tom Lane [Mon, 27 Dec 2004 20:13:48 +0000 (20:13 +0000)]
Move info about psql console code page issues out of install-win32.sgml,
where it doesn't belong, and put it in the psql reference page.
Tom Lane [Mon, 27 Dec 2004 19:19:24 +0000 (19:19 +0000)]
Cause pg_hba.conf file inclusion (@file stuff) to behave as documented,
that is, files are sought in the same directory as the referencing file.
Also allow absolute paths in @file constructs. Improve documentation
to actually say what is allowed in an included file.
Peter Eisentraut [Mon, 27 Dec 2004 14:24:22 +0000 (14:24 +0000)]
Translation update
Tom Lane [Sun, 26 Dec 2004 23:20:12 +0000 (23:20 +0000)]
Fix func_ptr declaration for netbsd-mac68k, per Rémi Zara.
Tom Lane [Sun, 26 Dec 2004 23:06:56 +0000 (23:06 +0000)]
More minor updates and copy-editing.
Tom Lane [Sun, 26 Dec 2004 19:20:33 +0000 (19:20 +0000)]
Rearrange include file contents into a saner order, add inclusion of
<signal.h>. Per Andrew Dunstan.
Bruce Momjian [Fri, 24 Dec 2004 19:20:18 +0000 (19:20 +0000)]
Improve Win32 install instructions.
Tom Lane [Fri, 24 Dec 2004 19:12:37 +0000 (19:12 +0000)]
Minor updates and copy-editing.
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