OSDN Git Service
Bruce Momjian [Thu, 15 Nov 2007 22:15:46 +0000 (22:15 +0000)]
Beef up README instructions, again.
Bruce Momjian [Thu, 15 Nov 2007 22:12:09 +0000 (22:12 +0000)]
CUpdate README to suggest 'gmake distclean'. Add library typedefs.
Bruce Momjian [Thu, 15 Nov 2007 22:09:07 +0000 (22:09 +0000)]
Update pgtools README to be clearer about typdefs.
Bruce Momjian [Thu, 15 Nov 2007 22:06:07 +0000 (22:06 +0000)]
Update pgindent with current typedefs.
Peter Eisentraut [Thu, 15 Nov 2007 22:02:12 +0000 (22:02 +0000)]
When logging the recovery.conf parameters, show them quoted as they would
appear in the configuration file.
Bruce Momjian [Thu, 15 Nov 2007 21:52:39 +0000 (21:52 +0000)]
Add blank lines to pgindent.
Tom Lane [Thu, 15 Nov 2007 21:49:47 +0000 (21:49 +0000)]
Use ftruncate() not truncate() in mdunlink. Seems Windows doesn't
support the latter.
Tom Lane [Thu, 15 Nov 2007 21:21:14 +0000 (21:21 +0000)]
Update timezone data files to release 2007i of the zic database.
Bruce Momjian [Thu, 15 Nov 2007 21:14:46 +0000 (21:14 +0000)]
pgindent run for 8.3.
Peter Eisentraut [Thu, 15 Nov 2007 20:38:15 +0000 (20:38 +0000)]
Translation updates
Tom Lane [Thu, 15 Nov 2007 20:36:40 +0000 (20:36 +0000)]
Prevent re-use of a deleted relation's relfilenode until after the next
checkpoint. This guards against an unlikely data-loss scenario in which
we re-use the relfilenode, then crash, then replay the deletion and
recreation of the file. Even then we'd be OK if all insertions into the
new relation had been WAL-logged ... but that's not guaranteed given all
the no-WAL-logging optimizations that have recently been added.
Patch by Heikki Linnakangas, per a discussion last month.
Peter Eisentraut [Thu, 15 Nov 2007 20:21:05 +0000 (20:21 +0000)]
Update config.guess and config.sub
Bruce Momjian [Thu, 15 Nov 2007 20:10:32 +0000 (20:10 +0000)]
Add more detail for non-TEXT cast release item.
Peter Eisentraut [Thu, 15 Nov 2007 20:04:38 +0000 (20:04 +0000)]
Message improvements
Peter Eisentraut [Thu, 15 Nov 2007 19:40:31 +0000 (19:40 +0000)]
Add to synopsis that timeout option also applies to stop mode
Peter Eisentraut [Thu, 15 Nov 2007 19:35:26 +0000 (19:35 +0000)]
Make help synopsis consistent
Peter Eisentraut [Thu, 15 Nov 2007 18:37:23 +0000 (18:37 +0000)]
Make synopses of -t option consistent
Bruce Momjian [Thu, 15 Nov 2007 17:09:40 +0000 (17:09 +0000)]
Document that /contrib/tsearch2 now contains a compatibility interface.
Tom Lane [Wed, 14 Nov 2007 23:48:55 +0000 (23:48 +0000)]
Adjust example to reduce confusion between a tsvector column and
an index, per Simon.
Tom Lane [Wed, 14 Nov 2007 23:43:27 +0000 (23:43 +0000)]
Add a rank/(rank+1) normalization option to ts_rank(). While the usefulness
of this seems a bit marginal, if it's useful enough to be shown in the manual
then we probably ought to support doing it without double evaluation of the
ts_rank function. Per my proposal earlier today.
Tom Lane [Wed, 14 Nov 2007 21:19:18 +0000 (21:19 +0000)]
Fix incorrect calculation of elapsed_xlogs. Itagaki Takahiro
Tom Lane [Wed, 14 Nov 2007 18:36:37 +0000 (18:36 +0000)]
Add an Accept parameter to "simple" dictionaries. The default of true
gives the old behavior; selecting false allows the dictionary to be used
as a filter ahead of other dictionaries, because it will pass on rather
than accept words that aren't in its stopword list.
Jan Urbanski
Bruce Momjian [Wed, 14 Nov 2007 14:38:30 +0000 (14:38 +0000)]
Mention that GSSAPI is preferred over Kerberos authentication because
GSSAPI is industry-standard.
Magnus Hagander [Wed, 14 Nov 2007 14:25:55 +0000 (14:25 +0000)]
Add note about deprecating krb5 authentication in favour of GSSAPI,
per discussions (a long time ago). Documentation only, we keep full
support in the code.
Bruce Momjian [Wed, 14 Nov 2007 14:06:54 +0000 (14:06 +0000)]
Capitalize "Migration to Version".
Bruce Momjian [Wed, 14 Nov 2007 12:36:34 +0000 (12:36 +0000)]
Properly capitalize "Migrate To Version"; seems we always had that
wrong.
Bruce Momjian [Wed, 14 Nov 2007 03:39:53 +0000 (03:39 +0000)]
Markup cleanup.
Bruce Momjian [Wed, 14 Nov 2007 03:39:17 +0000 (03:39 +0000)]
Reference pgfoundry instead of gborg.
Bruce Momjian [Wed, 14 Nov 2007 03:37:30 +0000 (03:37 +0000)]
Remove reference to gborg, instead reference pgfoundry.
Tom Lane [Wed, 14 Nov 2007 03:26:24 +0000 (03:26 +0000)]
Update discussion of tsearch2 migration. I'm not entirely sure about
the division of material between here and the tsearch2 contrib page,
but at least it's not obviously unfinished any more.
Tom Lane [Wed, 14 Nov 2007 02:36:43 +0000 (02:36 +0000)]
Move contrib docs to an appendix (next door to External Projects).
Change title to Additional Supplied Modules. Improve discussion of
how to build and install 'em.
Tom Lane [Wed, 14 Nov 2007 01:58:18 +0000 (01:58 +0000)]
Clean up some now-obsolete references to GBorg.
Tom Lane [Wed, 14 Nov 2007 01:09:50 +0000 (01:09 +0000)]
Add some quick documentation for tsearch2 compatibility module.
Bruce Momjian [Wed, 14 Nov 2007 00:16:27 +0000 (00:16 +0000)]
Update release notes to current CVS.
Tom Lane [Tue, 13 Nov 2007 23:36:26 +0000 (23:36 +0000)]
Clean up some stray references to tsearch2.
Tom Lane [Tue, 13 Nov 2007 22:49:47 +0000 (22:49 +0000)]
contrib/tsearch2 need not be special-cased any longer.
Tom Lane [Tue, 13 Nov 2007 22:14:50 +0000 (22:14 +0000)]
Resurrect the code for the rewrite(ARRAY[...]) aggregate function,
and put it into contrib/tsearch2 compatibility module.
Tom Lane [Tue, 13 Nov 2007 21:25:25 +0000 (21:25 +0000)]
Ooops, missed one file to remove.
Tom Lane [Tue, 13 Nov 2007 21:10:40 +0000 (21:10 +0000)]
Update description of contrib/tsearch2.
Tom Lane [Tue, 13 Nov 2007 21:04:45 +0000 (21:04 +0000)]
Re-add contrib/tsearch2 to the set of buildable contrib modules.
Tom Lane [Tue, 13 Nov 2007 21:02:29 +0000 (21:02 +0000)]
Replace the now-incompatible-with-core contrib/tsearch2 module with a
compatibility package. This supports importing dumps from past versions
using tsearch2, and provides the old names and API for most functions
that were changed. (rewrite(ARRAY[...]) is a glaring omission, though.)
Pavel Stehule and Tom Lane
Bruce Momjian [Tue, 13 Nov 2007 18:50:54 +0000 (18:50 +0000)]
Again properly fix Darwin strip.
Bruce Momjian [Tue, 13 Nov 2007 18:44:20 +0000 (18:44 +0000)]
Add link to Postgres-R glossary from our documentation (has helpful
terms defined).
Bruce Momjian [Tue, 13 Nov 2007 18:15:01 +0000 (18:15 +0000)]
Modify OS/X Darin test to actually work, (no $template)
Tom Lane [Tue, 13 Nov 2007 06:29:04 +0000 (06:29 +0000)]
Fix a few contrib regression test scripts that hadn't gotten the word
about best practice for including the module creation scripts: to wit
that you should suppress NOTICE messages. This avoids creating
regression failures by adding or removing comment lines in the module
scripts.
Bruce Momjian [Tue, 13 Nov 2007 04:27:26 +0000 (04:27 +0000)]
Adjust expected file for new CVS version label.
Bruce Momjian [Tue, 13 Nov 2007 04:24:29 +0000 (04:24 +0000)]
Add CVS version labels to all install/uninstall scripts.
Tom Lane [Tue, 13 Nov 2007 02:17:33 +0000 (02:17 +0000)]
Fix more script breakage.
Tom Lane [Tue, 13 Nov 2007 01:55:49 +0000 (01:55 +0000)]
Fix insufficient search-path paranoia in SQL function definitions.
Remove setting of search_path in install/uninstall scripts, since unlike
other contrib modules this one does not want to let you change the
installation schema.
Bruce Momjian [Tue, 13 Nov 2007 01:19:40 +0000 (01:19 +0000)]
Adjust script to be consistent (thanks Tom for the fix).
Tom Lane [Tue, 13 Nov 2007 00:20:36 +0000 (00:20 +0000)]
Undo damage from yesterday's script "cleanup".
Tom Lane [Tue, 13 Nov 2007 00:13:19 +0000 (00:13 +0000)]
I find that an out-of-the-box installation of OSSP uuid 1.6.0 installs
itself as libuuid, not libossp-uuid which was the only case expected by
our build support. Install a configure test to determine which name
to use (and to check that the library is present at all).
Bruce Momjian [Mon, 12 Nov 2007 18:01:44 +0000 (18:01 +0000)]
No master server overhead for middleware replication.
Bruce Momjian [Mon, 12 Nov 2007 17:02:14 +0000 (17:02 +0000)]
Change replication chart title to "No waiting for multiple servers".
Bruce Momjian [Mon, 12 Nov 2007 01:37:34 +0000 (01:37 +0000)]
Trim trailing whitespace --- needed commit to update anoncvs.
Tom Lane [Sun, 11 Nov 2007 19:22:49 +0000 (19:22 +0000)]
Ensure that typmod decoration on a datatype name is validated in all cases,
even in code paths where we don't pay any subsequent attention to the typmod
value. This seems needed in view of the fact that 8.3's generalized typmod
support will accept a lot of bogus syntax, such as "timestamp(foo)" or
"record(int, 42)" --- if we allow such things to pass without comment,
users will get confused. Per a recent example from Greg Stark.
To implement this in a way that's not very vulnerable to future
bugs-of-omission, refactor the API of parse_type.c's TypeName lookup routines
so that typmod validation is folded into the base lookup operation. Callers
can still choose not to receive the encoded typmod, but we'll check the
decoration anyway if it's present.
Bruce Momjian [Sun, 11 Nov 2007 14:23:18 +0000 (14:23 +0000)]
Remove tabs from SGML files.
Bruce Momjian [Sun, 11 Nov 2007 05:13:09 +0000 (05:13 +0000)]
Remove /contrib/dblink/doc directory, now in SGML.
Bruce Momjian [Sun, 11 Nov 2007 03:57:06 +0000 (03:57 +0000)]
Adjust pg_trgm expected output for new *.sql file.
Bruce Momjian [Sun, 11 Nov 2007 03:25:35 +0000 (03:25 +0000)]
Make /contrib install/uninstall script consistent:
remove transactions
use create or replace function
make formatting consistent
set search patch on first line
Add documentation on modifying *.sql to set the search patch, and
mention that major upgrades should still run the installation scripts.
Some of these issues were spotted by Tom today.
Bruce Momjian [Sat, 10 Nov 2007 23:59:52 +0000 (23:59 +0000)]
Remove references to READMEs from /contrib Makefiles.
Bruce Momjian [Sat, 10 Nov 2007 23:30:46 +0000 (23:30 +0000)]
Move most /contrib README files into SGML. Some still need conversion
or will never be converted.
Bruce Momjian [Sat, 10 Nov 2007 21:48:51 +0000 (21:48 +0000)]
Add pg_ctl -t/timeout parameter to control amount of time to wait for
start/shutdown.
Tom Lane [Sat, 10 Nov 2007 20:14:36 +0000 (20:14 +0000)]
Add an example of a SQL function with output parameters returning
multiple rows. I had thought this case was covered, but there was
no example in the obvious section to look in.
Tom Lane [Sat, 10 Nov 2007 19:29:54 +0000 (19:29 +0000)]
Add missing closing / in xsd:restriction, and remove some unnecessary
spaces for consistency. Per bug #3734 from Ben Leslie; fix by
Euler Taveira de Oliveira.
Bruce Momjian [Sat, 10 Nov 2007 19:19:36 +0000 (19:19 +0000)]
High availability wording fix.
Bruce Momjian [Sat, 10 Nov 2007 19:14:02 +0000 (19:14 +0000)]
Update high availability documentation with comments from Markus Schiltknecht.
Tom Lane [Sat, 10 Nov 2007 18:51:20 +0000 (18:51 +0000)]
xmlGetUTF8Char()'s second argument is both input and output. Fix
uninitialized value, and avoid invoking the function nine separate
times in the pg_xmlIsNameChar macro. Should resolve buildfarm failures.
Per report from Ben Leslie.
Bruce Momjian [Sat, 10 Nov 2007 16:15:23 +0000 (16:15 +0000)]
Use strip -x on OS/X-darwin because non-"-x" causes link problems:
http://archives.postgresql.org/pgsql-hackers/2007-10/msg01470.php
Bruce Momjian [Sat, 10 Nov 2007 15:39:34 +0000 (15:39 +0000)]
Have text search thesaurus files use "?" for stop words.
Throw an error for actual stop words, rather than a warning. This fixes
problems with cache reloading causing warning messages.
Re-enable stop words in regression tests; was disabled by Tom.
Document "?" as API change.
Bruce Momjian [Sat, 10 Nov 2007 14:36:44 +0000 (14:36 +0000)]
Reduce error level of ROLLBACK outside a transaction from WARNING to
NOTICE.
Bruce Momjian [Sat, 10 Nov 2007 14:07:18 +0000 (14:07 +0000)]
Fix markup problem with recent pg_ctl change.
Joe Conway [Sat, 10 Nov 2007 05:00:41 +0000 (05:00 +0000)]
Have crosstab variants treat NULL rowid as a category in its own right,
per suggestion from Tom Lane. This fixes crash-bug reported by Stefan
Schwarzer.
Bruce Momjian [Sat, 10 Nov 2007 04:52:17 +0000 (04:52 +0000)]
Properly order pg_ctl -c option alphabetically in docs.
Tom Lane [Fri, 9 Nov 2007 23:58:32 +0000 (23:58 +0000)]
Recognize RETURN QUERY via a textual test, so that QUERY doesn't need to be
a plpgsql keyword. This avoids springing a new reserved word on plpgsql
programmers.
For consistency, handle RETURN NEXT the same way.
Bruce Momjian [Fri, 9 Nov 2007 23:52:08 +0000 (23:52 +0000)]
Remove tabs from SGML files.
Tom Lane [Fri, 9 Nov 2007 22:52:08 +0000 (22:52 +0000)]
Add an expected-results file to get regression to pass cleanly in sv_SE
locale, which sorts a bit differently. Per recent gripe from Magnus.
Tom Lane [Fri, 9 Nov 2007 22:37:35 +0000 (22:37 +0000)]
Clean up ts_locale.h/.c. Fix broken and not-consistent-across-platforms
behavior of wchar2char/char2wchar; this should resolve bug #3730. Avoid
excess computations of pg_mblen in t_isalpha and friends. Const-ify
APIs where possible.
Alvaro Herrera [Fri, 9 Nov 2007 22:22:46 +0000 (22:22 +0000)]
Point to our own UUID page instead of to Wikipedia.
Tom Lane [Fri, 9 Nov 2007 20:10:02 +0000 (20:10 +0000)]
Second pass at improving LIKE/regex estimation in non-C locales. It turns
out that it's actually quite likely that a string that is an extension of
the given prefix will sort as larger than the "greater" string our previous
code created. To provide some defense against that, do the comparisons
against a modified string instead of just the bare prefix. We tack on
"Z", "z", "y", or "9", whichever is seen as largest in the current locale.
Testing suggests that this is sufficient at least for cases involving
ASCII data.
Magnus Hagander [Fri, 9 Nov 2007 17:31:07 +0000 (17:31 +0000)]
Add parameter krb_realm used by GSSAPI, SSPI and Kerberos
to validate the realm of the connecting user. By default
it's empty meaning no verification, which is the way
Kerberos authentication has traditionally worked in
PostgreSQL.
Bruce Momjian [Fri, 9 Nov 2007 16:36:04 +0000 (16:36 +0000)]
Move pl/proxy into Multi-server parallel query execution documentation
section.
Peter Eisentraut [Fri, 9 Nov 2007 15:52:51 +0000 (15:52 +0000)]
Allow XML processing instructions starting with "xml" while prohibiting
those being exactly "xml". Bug #3735 from Ben Leslie
Bruce Momjian [Fri, 9 Nov 2007 01:32:22 +0000 (01:32 +0000)]
In tsearch code, remove !(A && B) via restructuring, for clarity
Tom Lane [Thu, 8 Nov 2007 23:22:54 +0000 (23:22 +0000)]
If an index depends on no columns of its table, give it a dependency on the
whole table instead, to ensure that it goes away when the table is dropped.
Per bug #3723 from Sam Mason.
Backpatch as far as 7.4; AFAICT 7.3 does not have the issue, because it doesn't
have general-purpose expression indexes and so there must be at least one
column referenced by an index.
Bruce Momjian [Thu, 8 Nov 2007 22:14:18 +0000 (22:14 +0000)]
Wording improvement for pl/proxy mention.
Bruce Momjian [Thu, 8 Nov 2007 22:08:18 +0000 (22:08 +0000)]
Add mention of pl/proxy toolset to docs.
Tom Lane [Thu, 8 Nov 2007 21:49:48 +0000 (21:49 +0000)]
Fix EquivalenceClass code to handle volatile sort expressions in a more
predictable manner; in particular that if you say ORDER BY output-column-ref,
it will in fact sort by that specific column even if there are multiple
syntactic matches. An example is
SELECT random() AS a, random() AS b FROM ... ORDER BY b, a;
While the use-case for this might be a bit debatable, it worked as expected
in earlier releases, so we should preserve the behavior for 8.3. Per my
recent proposal.
While at it, fix convert_subquery_pathkeys() to handle RelabelType stripping
in both directions; it needs this for the same reasons make_sort_from_pathkeys
does.
Tom Lane [Thu, 8 Nov 2007 19:25:37 +0000 (19:25 +0000)]
Last week's patch for make_sort_from_pathkeys wasn't good enough: it has
to be able to discard top-level RelabelType nodes on *both* sides of the
equivalence-class-to-target-list comparison, since make_pathkey_from_sortinfo
might either add or remove a RelabelType. Also fix the latter to do the
removal case cleanly. Per example from Peter.
Bruce Momjian [Thu, 8 Nov 2007 19:18:23 +0000 (19:18 +0000)]
Properly indent SGML file.
Bruce Momjian [Thu, 8 Nov 2007 19:16:30 +0000 (19:16 +0000)]
Add "High Availability, Load Balancing, and Replication Feature Matrix"
table to docs.
Bruce Momjian [Thu, 8 Nov 2007 15:21:03 +0000 (15:21 +0000)]
Move NFS section into "Creating Cluster" documentation section because
it seems more logical there.
Peter Eisentraut [Thu, 8 Nov 2007 15:16:45 +0000 (15:16 +0000)]
After conferencing again with Bruce, put in more accurate XML error message.
Peter Eisentraut [Thu, 8 Nov 2007 14:56:37 +0000 (14:56 +0000)]
Adjust test results for message changes. Darn.
Peter Eisentraut [Thu, 8 Nov 2007 14:47:51 +0000 (14:47 +0000)]
Wording changes
Peter Eisentraut [Thu, 8 Nov 2007 14:47:41 +0000 (14:47 +0000)]
Add sentence-ending periods.
Peter Eisentraut [Thu, 8 Nov 2007 13:13:51 +0000 (13:13 +0000)]
Mention text search instead of tsearch2
Peter Eisentraut [Thu, 8 Nov 2007 13:13:28 +0000 (13:13 +0000)]
Small fixes
Peter Eisentraut [Thu, 8 Nov 2007 13:12:56 +0000 (13:12 +0000)]
Improve error message
Peter Eisentraut [Thu, 8 Nov 2007 10:37:54 +0000 (10:37 +0000)]
Add missing newlines to error messages, and normalize wording a bit.