OSDN Git Service
Bruce Momjian [Thu, 12 Aug 2004 16:39:50 +0000 (16:39 +0000)]
Be more aggressive about adding flags to thread compiles. The configure
test only tests for building a binary, not building a shared library.
On Linux, you can build a binary with -pthread, but you can't build a
binary that uses a threaded shared library unless you also use -pthread
when building the binary, or adding -lpthread to the shared library
build. This patch has the effect of doing the later by adding both
-pthread and -lpthread when building libpq.
Bruce Momjian [Thu, 12 Aug 2004 14:58:37 +0000 (14:58 +0000)]
Minor style cleanup of thread test script.
Tom Lane [Wed, 11 Aug 2004 23:28:54 +0000 (23:28 +0000)]
Cause initdb to actually accept -s as intended, and fix some typos in
a comment.
Jon Jensen
Tom Lane [Wed, 11 Aug 2004 22:50:35 +0000 (22:50 +0000)]
Fix broken parsing of CREATE TABLE AS (looks like a mis-sync with main
parser).
Tom Lane [Wed, 11 Aug 2004 21:10:37 +0000 (21:10 +0000)]
Avoid crashing when restoring a saved GUC session_authorization value
that refers to a now-deleted userid. Per gripe from Chris Ochs.
Tom Lane [Wed, 11 Aug 2004 18:06:01 +0000 (18:06 +0000)]
Add PQserverVersion() to libpq to provide more-convenient access to
the server version number. This commit also removes bogus DOS line
endings from libpqddll.def.
Greg Sabino Mullane
Tom Lane [Wed, 11 Aug 2004 17:20:50 +0000 (17:20 +0000)]
Work around broken strtod() that's present in many Solaris releases.
Thanks to Michael Fuhr for identifying the problem.
Tom Lane [Wed, 11 Aug 2004 16:53:28 +0000 (16:53 +0000)]
Fix function definition that somehow missed being ANSI-fied, and align
it with previous prototype to suppress complaints from picky compilers,
per report from Scott Bailey. Also, remove substitute strerror
definition --- not needed, since we link this with libpgport.
Peter Eisentraut [Wed, 11 Aug 2004 11:06:23 +0000 (11:06 +0000)]
Allow compilation when CODESET is not defined (OpenBSD).
Peter Eisentraut [Wed, 11 Aug 2004 09:27:20 +0000 (09:27 +0000)]
Translation update
Peter Eisentraut [Wed, 11 Aug 2004 09:00:27 +0000 (09:00 +0000)]
Add translation from 7.4 branch to head.
Tom Lane [Wed, 11 Aug 2004 04:07:16 +0000 (04:07 +0000)]
Fix failure to guarantee that a checkpoint will write out pg_clog updates
for transaction commits that occurred just before the checkpoint. This is
an EXTREMELY serious bug --- kudos to Satoshi Okada for creating a
reproducible test case to prove its existence.
Joe Conway [Wed, 11 Aug 2004 00:49:35 +0000 (00:49 +0000)]
Hashed crosstab was dying with an SPI_finish error when the source SQL
produced no rows. Now it returns 0 rows instead. Adjusted regression
test for this case.
Tom Lane [Tue, 10 Aug 2004 22:24:06 +0000 (22:24 +0000)]
Set DYLD_LIBRARY_PATH so that 'make check' works without prior
'make install' on OS X. Per suggestion from Adam Witney.
Peter Eisentraut [Tue, 10 Aug 2004 19:10:21 +0000 (19:10 +0000)]
New translation
Peter Eisentraut [Tue, 10 Aug 2004 19:06:21 +0000 (19:06 +0000)]
Translation updates
Peter Eisentraut [Tue, 10 Aug 2004 18:59:57 +0000 (18:59 +0000)]
Translation update
Peter Eisentraut [Tue, 10 Aug 2004 18:42:22 +0000 (18:42 +0000)]
Translation updates
Peter Eisentraut [Tue, 10 Aug 2004 18:38:19 +0000 (18:38 +0000)]
Translation update
Bruce Momjian [Tue, 10 Aug 2004 17:30:47 +0000 (17:30 +0000)]
Update DELETE FROM:
< * Allow DELETE to handle table aliases for self-joins
> * Allow an alias to be provided for the target table in UPDATE/DELETE
276,
279c276,282
< There is no way to create a table alias for the deleted table for use
< in the DELETE WHERE clause. The agreed approach is to allow a USING
< clause to specify additional tables. UPDATE already has an optional
< FROM clause for this purpose.
> This is not SQL-spec but many DBMSs allow it.
>
> * Allow additional tables to be specified in DELETE for joins
>
> UPDATE already allows this (UPDATE...FROM) but we need similar
> functionality in DELETE. It's been agreed that the keyword should
> be USING, to avoid anything as confusing as DELETE FROM a FROM b.
Bruce Momjian [Tue, 10 Aug 2004 16:29:43 +0000 (16:29 +0000)]
Update DELETE FROM TODO info.
Bruce Momjian [Tue, 10 Aug 2004 01:38:59 +0000 (01:38 +0000)]
Add:
* Add COMMENT ON for all cluster global objects (users, groups,
databases and tablespaces)
Tom Lane [Tue, 10 Aug 2004 00:55:08 +0000 (00:55 +0000)]
Update documentation to reflect the fact that we now know exactly what
time zone names we support.
Bruce Momjian [Mon, 9 Aug 2004 22:48:01 +0000 (22:48 +0000)]
Removed, shared table:
< * Add COMMENT for tablespaces
Bruce Momjian [Mon, 9 Aug 2004 22:39:18 +0000 (22:39 +0000)]
Add:
> * Add COMMENT for tablespaces
Tom Lane [Mon, 9 Aug 2004 20:28:48 +0000 (20:28 +0000)]
syslogger.c needs <sys/time.h> on some platforms, per Greg Mullane.
Tom Lane [Mon, 9 Aug 2004 20:20:47 +0000 (20:20 +0000)]
Path-mangling logic was failing to account for paths containing mentions
of '.' or '..'. Extend canonicalize_path() to trim off trailing occurrences
of these things, and use it to fix up paths where needed (which I think is
only after places where we trim the last path component, but maybe some
others will turn up). Fixes Josh's complaint that './initdb' does not
work.
Tom Lane [Mon, 9 Aug 2004 16:26:06 +0000 (16:26 +0000)]
When expanding %p in archive_command or restore_command, translate
slashes to backslashes #ifdef WIN32. This is to cope with the fact
that Windows seems exceedingly unfriendly to slashes in shell commands,
as per recent discussion.
Tom Lane [Mon, 9 Aug 2004 05:34:39 +0000 (05:34 +0000)]
Remove no-longer-relevant information about trying to force your OS
to support PST8PDT time zone for the regression tests.
Bruce Momjian [Mon, 9 Aug 2004 03:12:38 +0000 (03:12 +0000)]
Fix Win32 pg_dumpall check.
Bruce Momjian [Mon, 9 Aug 2004 02:12:51 +0000 (02:12 +0000)]
Improve comment.
Bruce Momjian [Mon, 9 Aug 2004 01:55:42 +0000 (01:55 +0000)]
Stamp libpq.rc with 8.0 version.
PostgreSQL Daemon [Sun, 8 Aug 2004 23:27:11 +0000 (23:27 +0000)]
tag her configure 8.0.0beta1 ...
Tom Lane [Sun, 8 Aug 2004 22:40:46 +0000 (22:40 +0000)]
Add note pointing out the difference in semantics between Oracle and
plpgsql EXCEPTION blocks.
Tom Lane [Sun, 8 Aug 2004 21:33:11 +0000 (21:33 +0000)]
Move expanded discussion of inheritance's limitations out of tutorial
and into ddl.sgml. Rewrite for more completeness and (hopefully)
clarity.
Tom Lane [Sun, 8 Aug 2004 20:17:36 +0000 (20:17 +0000)]
Make listen_addresses be a comma-separated list instead of a space-separated
list. More consistent with our other list-containing GUC variables.
Tom Lane [Sun, 8 Aug 2004 19:42:57 +0000 (19:42 +0000)]
Document background writer control parameters, do some editorial work
on other recent changes in runtime parameter list.
Tom Lane [Sun, 8 Aug 2004 16:13:05 +0000 (16:13 +0000)]
If these are ifdef WIN32 in the .c file, should be so in .h as well.
Bruce Momjian [Sun, 8 Aug 2004 15:37:06 +0000 (15:37 +0000)]
Disable vacuum delay, as discussed on hackers.
Bruce Momjian [Sun, 8 Aug 2004 07:00:22 +0000 (07:00 +0000)]
Fix compiler warning in the proper way.
Bruce Momjian [Sun, 8 Aug 2004 06:58:00 +0000 (06:58 +0000)]
Supress warning about zero-length format string.
Bruce Momjian [Sun, 8 Aug 2004 06:44:36 +0000 (06:44 +0000)]
Allow libpgport to call memory allocation routines even though
CurrentMemoryContext is DLLIMPORT on Win32. Work around that by
creating stubs in the backend for palloc/pstrdup.
Also fix pg_dumpall to do proper quoting on Win32.
Joe Conway [Sun, 8 Aug 2004 06:03:36 +0000 (06:03 +0000)]
Another array syntax change (whitespace) clarification -- this time in
the release notes.
Joe Conway [Sun, 8 Aug 2004 05:55:55 +0000 (05:55 +0000)]
Minor clarification of documentation regarding trailing whitespace.
Joe Conway [Sun, 8 Aug 2004 05:46:40 +0000 (05:46 +0000)]
Updated release notes for recent array syntax changes.
Bruce Momjian [Sun, 8 Aug 2004 05:19:44 +0000 (05:19 +0000)]
More Win32 zic build cleanups now that we have symlinks, it needs help.
Bruce Momjian [Sun, 8 Aug 2004 05:04:41 +0000 (05:04 +0000)]
Adjust defines to be consistent.
Joe Conway [Sun, 8 Aug 2004 05:01:55 +0000 (05:01 +0000)]
Tighened up syntax checking of array input processing considerably. Junk that
was previously allowed in odd places with odd results now causes an ERROR.
Also changed behavior with respect to whitespace -- trailing whitespace is
now ignored as well as leading whitespace (which has always been ignored).
Documentation updated to reflect change in whitespace handling. Also some
refactoring to what I believe is a more sensible order of several paragraphs.
Bruce Momjian [Sun, 8 Aug 2004 04:53:41 +0000 (04:53 +0000)]
Another zic cleanup .
Tom Lane [Sun, 8 Aug 2004 04:34:43 +0000 (04:34 +0000)]
Update admin guide's discussion of WAL to match present reality.
Bruce Momjian [Sun, 8 Aug 2004 03:57:35 +0000 (03:57 +0000)]
Link in dirmod specially for zic so it works on Win32.
Bruce Momjian [Sun, 8 Aug 2004 03:51:20 +0000 (03:51 +0000)]
Remove xstrdup and friends who were only called once. Replace with
#ifdef calls.
Tom Lane [Sun, 8 Aug 2004 03:22:08 +0000 (03:22 +0000)]
Add a comment about why we always replay backup blocks from WAL.
Bruce Momjian [Sun, 8 Aug 2004 03:21:39 +0000 (03:21 +0000)]
Fix Win32 pg_dumpall, with help from Claudio.
Bruce Momjian [Sun, 8 Aug 2004 02:22:55 +0000 (02:22 +0000)]
Improve comment.
Tom Lane [Sun, 8 Aug 2004 02:05:32 +0000 (02:05 +0000)]
Minor editorialization on example --- I think that the use of dollar
quoting in this case is just needless obscurantism.
Bruce Momjian [Sun, 8 Aug 2004 01:52:14 +0000 (01:52 +0000)]
This patch adds SQL2003 to the set of standards with which PostgreSQL
is attempting to comply.
David Fetter
Bruce Momjian [Sun, 8 Aug 2004 01:51:05 +0000 (01:51 +0000)]
This adds a caveat to the inheritance part of the tutorial.
David Fetter
Bruce Momjian [Sun, 8 Aug 2004 01:49:30 +0000 (01:49 +0000)]
This patch adds an example to the CREATE DOMAIN docs.
David Fetter
Bruce Momjian [Sun, 8 Aug 2004 01:48:31 +0000 (01:48 +0000)]
Included is an example of using savepoints in a non-trivial example.
Giving examples in the SQL command reference is hard because we don't
have conditionals at the SQL level.
Gavin Sherry
Bruce Momjian [Sun, 8 Aug 2004 01:43:33 +0000 (01:43 +0000)]
Fix comment.
Bruce Momjian [Sun, 8 Aug 2004 01:31:15 +0000 (01:31 +0000)]
Fixups for Win32 symlinks.
Tom Lane [Sun, 8 Aug 2004 00:50:58 +0000 (00:50 +0000)]
Update plpgsql documentation for 8.0 (mostly, make use of named
function parameters and dollar quoting in examples; do some polishing
of the existing dollar-quoting docs). The 'how to port from Oracle'
section is looking pretty respectable these days ...
Bruce Momjian [Sat, 7 Aug 2004 21:48:09 +0000 (21:48 +0000)]
The attached patch implements a symlink for win32 using junctions, and
uses that for win32 tablespaces.
Andreas Pflug
Tom Lane [Sat, 7 Aug 2004 20:44:50 +0000 (20:44 +0000)]
Improve privileges discussion (mostly, mention grant options).
Tom Lane [Sat, 7 Aug 2004 19:53:48 +0000 (19:53 +0000)]
Update a couple of example error messages to reflect the fact that we
don't generate constraint names like "$1" anymore.
Tom Lane [Sat, 7 Aug 2004 19:14:45 +0000 (19:14 +0000)]
Improve markup a little.
Tom Lane [Sat, 7 Aug 2004 19:02:43 +0000 (19:02 +0000)]
Improve tablespace discussion, and bring it up to date with code.
Bruce Momjian [Sat, 7 Aug 2004 18:07:46 +0000 (18:07 +0000)]
Update pitr docs to mention inclusive/exclusive xid specification
Tom Lane [Sat, 7 Aug 2004 17:55:59 +0000 (17:55 +0000)]
Remove bogus trailing dot from eventlog output, per Andreas.
Clean up README file a bit.
Tom Lane [Sat, 7 Aug 2004 17:40:49 +0000 (17:40 +0000)]
Don't try to rewrite NEW references in a utility statement in a rule.
There won't be any, and in fact there won't even be an RTE for NEW,
which was leading to a core dump in CVS tip. 7.4 and earlier manage
not to crash when applying ResolveNew in this scenario, but I think
it was just good fortune that they didn't. Per report from
Bernd Helmle.
Bruce Momjian [Sat, 7 Aug 2004 12:21:25 +0000 (12:21 +0000)]
Fix markup.
Bruce Momjian [Sat, 7 Aug 2004 03:36:07 +0000 (03:36 +0000)]
Ignore trailing spaces in psql \h.
Greg Sabino Mullane
Bruce Momjian [Sat, 7 Aug 2004 03:21:11 +0000 (03:21 +0000)]
Mention that transactions can complete in a different numeric order, for
PITR recovery.
Jan Wieck [Sat, 7 Aug 2004 03:08:49 +0000 (03:08 +0000)]
Vacuum delay activated by default.
Jan
Bruce Momjian [Sat, 7 Aug 2004 01:58:12 +0000 (01:58 +0000)]
Add:
> * Create dump tool for write-ahead logs for use in determining
> transaction id for point-in-time recovery
Bruce Momjian [Sat, 7 Aug 2004 01:04:50 +0000 (01:04 +0000)]
Document delay as 0, per Matthew T. O'Connor
Tom Lane [Fri, 6 Aug 2004 23:33:48 +0000 (23:33 +0000)]
Some editorial work on the 8.0 release notes. Update for recent commits,
improve existing descriptions.
Tom Lane [Fri, 6 Aug 2004 19:17:31 +0000 (19:17 +0000)]
Arrange for proper newline termination of syslogger's own messages,
per Andreas.
Tom Lane [Fri, 6 Aug 2004 18:18:42 +0000 (18:18 +0000)]
Revert badly-broken patch to dump comments on composite-type columns.
Bruce Momjian [Fri, 6 Aug 2004 18:09:15 +0000 (18:09 +0000)]
I have noticed that the latex format in psql has some bugs:
o "_" is not escaped, and causes TeX to abort, thinking it's a
subscript outside of maths mode. Most of my table and field names
use underscores, so this is a really nasty one.
o The column count is calculated using the contents of opt_align. But
opt_align has one extra element, and so it's always one too many. I
changed it to count the column headings, like all the other output
formats. There may be a bug in computing opt_align that this patch
does not address, but I'm not yet familiar enough with the psql
source to fix this as well.
o The line drawing rules for each border setting (0-3) and expanded
mode didn't always match the documented behaviour and what other
formats (e.g. aligned) did. I made it as conformant as possible,
and also tidied the alignment of the first line of the footer, which
was incorrectly indented.
Roger Leigh
Tom Lane [Fri, 6 Aug 2004 18:05:49 +0000 (18:05 +0000)]
Use one, not zero, as the default lower bound for arrays of AclItems.
This avoids changing the displayed appearance of ACL columns now that
array_out decorates its output with bounds information when the lower
bound isn't one. Per gripe from Gaetano Mendola. Note that I did not
force initdb for this, although any database initdb'd in the last
couple of days is going to have some problems.
Bruce Momjian [Fri, 6 Aug 2004 17:52:44 +0000 (17:52 +0000)]
Modify:
> * Un-comment all variables in postgresql.conf
84,85c84,85
< By removing comments we prevent the confusion that commenting a line
< returns a modified value to its default, which it does not.
> By not showing commented-out variables, we discourage people from
> thinking that re-commenting a variable returns it to its default.
Tom Lane [Fri, 6 Aug 2004 16:06:59 +0000 (16:06 +0000)]
Add _O_TEXT option to dup2 call on Windows, to ensure redirected postmaster
stderr is in text mode. Per Andreas.
Tom Lane [Fri, 6 Aug 2004 16:00:51 +0000 (16:00 +0000)]
Fix several small Windows compatibility issues, per Andreas.
Bruce Momjian [Fri, 6 Aug 2004 15:24:20 +0000 (15:24 +0000)]
Add:
> * Track dependencies in function bodies and recompile/invalidate
Bruce Momjian [Fri, 6 Aug 2004 15:12:38 +0000 (15:12 +0000)]
Add description:
>
> By removing comments we prevent the confusion that commenting a line
> returns a modified value to its default, which it does not.
>
Bruce Momjian [Fri, 6 Aug 2004 15:08:52 +0000 (15:08 +0000)]
Add:
> * Remove comments on postgresql.conf variables
Bruce Momjian [Fri, 6 Aug 2004 04:15:09 +0000 (04:15 +0000)]
Rename vacuum_cost_naptime to vacuum_cost_delay, with agreement from Jan.
Tom Lane [Thu, 5 Aug 2004 23:32:13 +0000 (23:32 +0000)]
Create a built-in log rotation program, so that we no longer have to
recommend that people go get Apache's rotatelogs program. Additional
benefits are that configuration is done through GUC, rather than
externally, and that the postmaster can monitor the log rotator and
restart it after failure (though we certainly hope that won't happen
often).
Andreas Pflug, some rework by Tom Lane.
Dennis Bjorklund [Thu, 5 Aug 2004 06:50:27 +0000 (06:50 +0000)]
Translation updates
Dennis Bjorklund [Thu, 5 Aug 2004 06:43:42 +0000 (06:43 +0000)]
Translation updates
Joe Conway [Thu, 5 Aug 2004 03:30:44 +0000 (03:30 +0000)]
Require that array literals produce "rectangular" arrays, i.e. all the
subarrays of a given dimension have the same number of elements/subarrays.
Also repair a longstanding undocumented (as far as I can see) ability to
explicitly set array bounds in the array literal syntax. It now can
deal properly with negative array indicies. Modify array_out so that
arrays with non-standard lower bounds (i.e. not 1) are output with
the expicit dimension syntax. This fixes a longstanding issue whereby
arrays with non-default lower bounds had them changed to default
after a dump/reload cycle.
Modify regression tests and docs to suit, and add some minimal
documentation regarding the explicit dimension syntax.
Joe Conway [Thu, 5 Aug 2004 03:11:55 +0000 (03:11 +0000)]
Restore behavior of --pgxs option to that of the original shell script.
Joe Conway [Thu, 5 Aug 2004 03:10:29 +0000 (03:10 +0000)]
Move include for Python.h above postgres.h to eliminate compiler warning.
Bruce Momjian [Wed, 4 Aug 2004 22:59:42 +0000 (22:59 +0000)]
Update for 8.0
Dennis Bjorklund [Wed, 4 Aug 2004 21:55:27 +0000 (21:55 +0000)]
Use gettext_noop() to mark strings. errmsg() perform the
real gettext() later on, so it was called twice before.
Tom Lane [Wed, 4 Aug 2004 21:34:35 +0000 (21:34 +0000)]
Label CVS tip as 8.0devel instead of 7.5devel. Adjust various comments
and documentation to reference 8.0 instead of 7.5.
Tom Lane [Wed, 4 Aug 2004 20:58:46 +0000 (20:58 +0000)]
Add LOG_NOWAIT flag to openlog() call, per my note of 2004-06-24.
Tom Lane [Wed, 4 Aug 2004 20:53:53 +0000 (20:53 +0000)]
Fix silly thinko in ALTER COLUMN TYPE. Check for finding expected
dependency was looking at wrong columns and so would always fail.
Was not exposed by regression tests because we are only testing cases
involving built-in (pinned) types and so no actual dependency entry
exists to be removed.