OSDN Git Service
Tom Lane [Wed, 12 Jan 2005 21:37:54 +0000 (21:37 +0000)]
Add conditional inclusion of <com_err.h> to support old 'heimdal'
version of Kerberos. Per report from Reinhard Max.
Tom Lane [Wed, 12 Jan 2005 17:32:36 +0000 (17:32 +0000)]
Re-allow an untyped literal as the test expression of a CASE, ie
CASE 'a' WHEN 'a' THEN 1 ELSE 2 END. This worked in 7.4 and before
but had been broken due to premature freezing of the type of the test
expression. Per gripe from GÄbor SzÃcs.
Tom Lane [Wed, 12 Jan 2005 16:38:17 +0000 (16:38 +0000)]
Increase MAXLISTEN to a more generous value, and add an error message
telling when it has been exceeded. Per trouble report from
Jean-GÅrard Pailloncy.
Tom Lane [Wed, 12 Jan 2005 16:19:51 +0000 (16:19 +0000)]
Ensure that the test postmaster started by 'make check' listens to as
few 'listen_addresses' as possible --- on most systems, none at all,
just the Unix socket. This avoids spurious check failures due to bogus
DNS setups, and is probably a good idea from a security standpoint anyway.
Per trouble report from Jean-GÅrard Pailloncy.
Tom Lane [Tue, 11 Jan 2005 18:33:46 +0000 (18:33 +0000)]
interval_out failed to mention 'ago' for negative intervals in SQL and
GERMAN datestyles. Ancient bug reported by Terry Lee Tucker.
Tom Lane [Tue, 11 Jan 2005 17:55:25 +0000 (17:55 +0000)]
Fix tracking of dump-order dependencies for stand-alone composite types.
Per report from Robert Koepferl.
Teodor Sigaev [Tue, 11 Jan 2005 16:07:55 +0000 (16:07 +0000)]
Fixes:
1 Report error message instead of do nothing in case of error in regex
2 Malloced storage for mask, find and repl part of Affix. This parts may be
large enough in real life (for example in czech, thanks to moje <moje@kalhotky.net>)
Tom Lane [Tue, 11 Jan 2005 06:08:45 +0000 (06:08 +0000)]
plperl was not being quite paranoid enough about detecting 'undef' values
returned by Perl. Per report from Nicolas Addington.
PostgreSQL Daemon [Tue, 11 Jan 2005 05:29:21 +0000 (05:29 +0000)]
up release to rc5
Tom Lane [Tue, 11 Jan 2005 05:14:13 +0000 (05:14 +0000)]
Clean up pg_dump's handling of ownership for indexes (including
pkey/unique constraint indexes) and schemas. Per report from
Michael Fuhr.
Tom Lane [Mon, 10 Jan 2005 21:57:19 +0000 (21:57 +0000)]
Separate the functions of relcache entry flush and smgr cache entry flush
so that we can get the size of a shared inval message back down to what it
was in 7.4 (and simplify the logic too). Phase 2 of fixing the
'SMgrRelation hashtable corrupted' problem.
Tom Lane [Mon, 10 Jan 2005 20:02:24 +0000 (20:02 +0000)]
Phase 1 of fix for 'SMgrRelation hashtable corrupted' problem. This
is the minimum required fix. I want to look next at taking advantage of
it by simplifying the message semantics in the shared inval message queue,
but that part can be held over for 8.1 if it turns out too ugly.
Michael Meskes [Mon, 10 Jan 2005 12:58:30 +0000 (12:58 +0000)]
Fixed segfault in adjust_informix due to missing varchar type.
Peter Eisentraut [Mon, 10 Jan 2005 09:01:04 +0000 (09:01 +0000)]
Update supported platforms list.
Peter Eisentraut [Mon, 10 Jan 2005 08:21:43 +0000 (08:21 +0000)]
Small polishing of bug reporting template
Peter Eisentraut [Mon, 10 Jan 2005 08:14:35 +0000 (08:14 +0000)]
Translation updates
Tom Lane [Mon, 10 Jan 2005 00:37:12 +0000 (00:37 +0000)]
Comment out check for substitution of private key file on Windows,
since st_ino can't be trusted on that platform. Per report from T.J.
Tom Lane [Mon, 10 Jan 2005 00:19:51 +0000 (00:19 +0000)]
Un-break MSVC build, per Andrew Dunstan.
Tom Lane [Mon, 10 Jan 2005 00:04:43 +0000 (00:04 +0000)]
Add some real documentation about TOAST (finally). Combine this with
the old 'page' chapter and the recently added 'filelayout' chapter to
make a coherent chapter about PostgreSQL's physical storage layout.
Tom Lane [Sun, 9 Jan 2005 21:03:19 +0000 (21:03 +0000)]
Undo an unadvertised change in the API of pg_atoi. In all previous
releases, a nonzero 'c' argument meant that the input string could be
terminated by either that character or \0. Recent refactoring broke
that, causing the thing to scan for 'c' only. This went undetected
because no part of the main code actually passes nonzero 'c'. However
it broke tsearch2 and possibly other user-written code that assumed
the old definition. Per report from Tom Hebbron.
Tom Lane [Sun, 9 Jan 2005 20:08:50 +0000 (20:08 +0000)]
Clarify description of greedy and non-greedy POSIX regular expressions,
per discussion in Nov 2004 with Ken Tanzer.
Bruce Momjian [Sun, 9 Jan 2005 19:44:25 +0000 (19:44 +0000)]
Update OS/2 URL.
Tom Lane [Sun, 9 Jan 2005 18:58:10 +0000 (18:58 +0000)]
Last batch of updates in response to 7.4 interactive docs comments.
Tom Lane [Sun, 9 Jan 2005 17:47:30 +0000 (17:47 +0000)]
Update discussion of ALTER TABLE ADD COLUMN, per Michael Fuhr.
Tom Lane [Sun, 9 Jan 2005 17:40:40 +0000 (17:40 +0000)]
Fix segfault when xpath_list function is applied to an invalid document.
John Gray
Peter Eisentraut [Sun, 9 Jan 2005 17:38:19 +0000 (17:38 +0000)]
New translations
Peter Eisentraut [Sun, 9 Jan 2005 17:32:05 +0000 (17:32 +0000)]
Translation updates
Peter Eisentraut [Sun, 9 Jan 2005 17:10:29 +0000 (17:10 +0000)]
New translation
Peter Eisentraut [Sun, 9 Jan 2005 17:07:27 +0000 (17:07 +0000)]
Translation updates
Tom Lane [Sun, 9 Jan 2005 05:57:45 +0000 (05:57 +0000)]
Some more small improvements in response to 7.4 interactive docs comments.
Tom Lane [Sat, 8 Jan 2005 22:51:15 +0000 (22:51 +0000)]
Consistently use geteuid() not getuid(); there were a few places deviating
from our long-established standard.
Tom Lane [Sat, 8 Jan 2005 22:13:38 +0000 (22:13 +0000)]
Some more small improvements in response to 7.4 interactive docs comments.
Peter Eisentraut [Sat, 8 Jan 2005 09:54:47 +0000 (09:54 +0000)]
Update supported platforms list.
Peter Eisentraut [Sat, 8 Jan 2005 09:54:29 +0000 (09:54 +0000)]
New version of mkinstalldirs fixes problems on Tru64 UNIX.
Tom Lane [Sat, 8 Jan 2005 05:19:18 +0000 (05:19 +0000)]
Some small docs improvements motivated by reading the comments for the 7.4
7.4 interactive docs.
Bruce Momjian [Sat, 8 Jan 2005 03:59:04 +0000 (03:59 +0000)]
Remove mp3 that is now missing.
Tom Lane [Sat, 8 Jan 2005 01:44:08 +0000 (01:44 +0000)]
Some small docs improvements motivated by reading the comments for the
7.4 interactive docs.
Tom Lane [Fri, 7 Jan 2005 23:59:17 +0000 (23:59 +0000)]
Improve comments in sample config files.
Tom Lane [Fri, 7 Jan 2005 23:08:44 +0000 (23:08 +0000)]
Add a tip showing how functions on composite types can be used to
emulate computed fields. I suppose this is why the Berkeley boys made
it work that way in the first place, but the docs never said so anyplace.
Tom Lane [Fri, 7 Jan 2005 22:40:46 +0000 (22:40 +0000)]
Improve discussion of SQL functions taking/returning row types.
Peter Eisentraut [Fri, 7 Jan 2005 10:21:02 +0000 (10:21 +0000)]
Update supported platforms list
Bruce Momjian [Fri, 7 Jan 2005 05:43:28 +0000 (05:43 +0000)]
Fix ECPGstatus() documentation of parameters.
Edmund Bacon
PostgreSQL Daemon [Fri, 7 Jan 2005 02:44:31 +0000 (02:44 +0000)]
upgrade tags to rc4
Tom Lane [Thu, 6 Jan 2005 21:41:45 +0000 (21:41 +0000)]
Minor mop-up for Windows home-directory stuff, per Magnus.
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