]> granicus.if.org Git - postgresql/log
postgresql
17 years agosimple script to pull together a very small (<500k) tar file that builds
Marc G. Fournier [Tue, 30 Oct 2007 02:34:48 +0000 (02:34 +0000)]
simple script to pull together a very small (<500k) tar file that builds
*just* libpq ... its not perfect, as it pulls in more files then is
necessarily required to build, but as it is, it requires one simple patch
to configure.in in order to work ...

Tested on FreeBSD ... patch for configure.in hasn't been applied, but
putting the script in place so that it doesn't get lost ...

17 years agoIn the previous commit message, I forgot to credit Simon Riggs who provided
Alvaro Herrera [Mon, 29 Oct 2007 22:17:41 +0000 (22:17 +0000)]
In the previous commit message, I forgot to credit Simon Riggs who provided
the patch, which I modified only slightly before applying.

17 years agoMention the index name in 'could not create unique index' errors,
Tom Lane [Mon, 29 Oct 2007 21:31:28 +0000 (21:31 +0000)]
Mention the index name in 'could not create unique index' errors,
per suggestion from Rene Gollent.

17 years agoRemove the hack in the grammar that "optimized away" DEFAULT NULL clauses.
Tom Lane [Mon, 29 Oct 2007 19:40:40 +0000 (19:40 +0000)]
Remove the hack in the grammar that "optimized away" DEFAULT NULL clauses.
Instead put in a test to drop a NULL default at the last moment before
storing the catalog entry.  This changes the behavior in a couple of ways:
* Specifying DEFAULT NULL when creating an inheritance child table will
  successfully suppress inheritance of any default expression from the
  parent's column, where formerly it failed to do so.
* Specifying DEFAULT NULL for a column of a domain type will correctly
  override any default belonging to the domain; likewise for a sub-domain.
The latter change happens because by the time the clause is checked,
it won't be a simple null Const but a CoerceToDomain expression.

Personally I think this should be back-patched, but there doesn't seem to
be consensus for that on pgsql-hackers, so refraining.

17 years ago- Add check of already changed page while replay WAL. This touches only
Teodor Sigaev [Mon, 29 Oct 2007 19:26:57 +0000 (19:26 +0000)]
- Add check of already changed page while replay WAL. This touches only
ginRedoInsert(), because other ginRedo* functions rewrite whole page or
make changes which could be applied several times without consistent's loss

- Remove check of identifying of corresponding split record:
it's possible that replaying of WAL starts after actual page split, but before
removing of that split from incomplete splits list. In this case, that check
cause FATAL error.

Per stress test which reproduces bug reported by Craig McElroy
<craig.mcelroy@contegix.com>

17 years agoDocumentation wording fixes.
Bruce Momjian [Mon, 29 Oct 2007 17:29:59 +0000 (17:29 +0000)]
Documentation wording fixes.

Guillaume Lelarge

17 years agoUpdate Russian FAQ.
Bruce Momjian [Mon, 29 Oct 2007 17:27:10 +0000 (17:27 +0000)]
Update Russian FAQ.

corochoone@gmail.com

17 years agoClarify restart is of the "database" server, in FAQ.
Bruce Momjian [Mon, 29 Oct 2007 17:22:20 +0000 (17:22 +0000)]
Clarify restart is of the "database" server, in FAQ.

17 years agoMake variable static, per Tom.
Magnus Hagander [Mon, 29 Oct 2007 14:04:42 +0000 (14:04 +0000)]
Make variable static, per Tom.

17 years agoFix coredump during replay WAL after crash. Change entrySplitPage() to prevent
Teodor Sigaev [Mon, 29 Oct 2007 13:49:21 +0000 (13:49 +0000)]
Fix coredump during replay WAL after crash. Change entrySplitPage() to prevent
usage of any information from system catalog, because it could be called during
replay of WAL.

Per bug report from Craig McElroy <craig.mcelroy@contegix.com>. Patch doesn't
change on-disk storage.

17 years agoAdd compat file for dynamically loading the functions that MinGW is missing
Magnus Hagander [Mon, 29 Oct 2007 12:35:41 +0000 (12:35 +0000)]
Add compat file for dynamically loading the functions that MinGW is missing
the imports for. Add RegisterWaitForSingleObject() to the list of such
functions, which should take care of the current buildfarm breakage.

17 years agoNew versions of mingw have gettimeofday(), so add an autoconf test
Magnus Hagander [Mon, 29 Oct 2007 11:25:42 +0000 (11:25 +0000)]
New versions of mingw have gettimeofday(), so add an autoconf test
for this.

17 years agoRemove claim that ts_headline knows how to generate multiple ellipsis-separated
Tom Lane [Mon, 29 Oct 2007 01:55:11 +0000 (01:55 +0000)]
Remove claim that ts_headline knows how to generate multiple ellipsis-separated
excerpts of a document.  That's clearly desirable, but the functionality
is not there yet.

17 years agoOoops, fat-fingered last commit message. Should have
Tom Lane [Sun, 28 Oct 2007 22:33:25 +0000 (22:33 +0000)]
Ooops, fat-fingered last commit message.  Should have
mentioned updating FAQ_IRIX for information about buggy MIPSPro
compiler version, now confirmed by Herve Boulouis.

17 years agoFAQ_IRIX
Tom Lane [Sun, 28 Oct 2007 22:30:21 +0000 (22:30 +0000)]
FAQ_IRIX

17 years agoMake pg_dump and friends consistently report both the filename and the
Tom Lane [Sun, 28 Oct 2007 21:55:52 +0000 (21:55 +0000)]
Make pg_dump and friends consistently report both the filename and the
errno string when complaining of fopen failures.  Per gripe from Bob
Pawley, it's not always instantly obvious to the user which name we
tried to open.

17 years agoFix a couple of issues with pg_dump's handling of inheritance child tables
Tom Lane [Sun, 28 Oct 2007 19:08:02 +0000 (19:08 +0000)]
Fix a couple of issues with pg_dump's handling of inheritance child tables
that have default expressions different from their parent.  First, if the
parent table's default expression has to be split out as a separate
ALTER TABLE command, we need a dependency constraint to ensure that the
child's command is given second.  This is because the ALTER TABLE on the
parent will propagate to the child.  (We can't prevent that by using ONLY on
the parent's command, since it's possible that other children exist that
should receive the inherited default.)  Second, if the child has a NULL
default where the parent does not, we have to explicitly say DEFAULT NULL on
the child in order for this state to be preserved after reload.  (The latter
actually doesn't work right because of a backend bug, but that is a separate
issue.)

Backpatch as far as 8.0.  7.x pg_dump has enough issues with altered tables
(due to lack of dependency analysis) that trying to fix this one doesn't seem
very productive.

17 years agoChange text search parsing rules for hyphenated words so that digit strings
Tom Lane [Sat, 27 Oct 2007 19:03:45 +0000 (19:03 +0000)]
Change text search parsing rules for hyphenated words so that digit strings
containing decimal points aren't considered part of a hyphenated word.
Sync the hyphenated-word lookahead states with the subsequent part-by-part
reparsing states so that we don't get different answers about how much text
is part of the hyphenated word.  Per my gripe of a few days ago.

17 years agoAdd some rudimentary tracing code to the default text search parser, to help
Tom Lane [Sat, 27 Oct 2007 17:53:15 +0000 (17:53 +0000)]
Add some rudimentary tracing code to the default text search parser, to help
in debugging its state-machine rules.  Const-ify all the constant tables.
Minor other code cleanup, including using "token" rather than "lexeme" to
describe the output strings.

17 years agoRename default text search parser's "uri" token type to "url_path",
Tom Lane [Sat, 27 Oct 2007 16:01:09 +0000 (16:01 +0000)]
Rename default text search parser's "uri" token type to "url_path",
per recommendation from Alvaro.  This doesn't force initdb since the
numeric token type in the catalogs doesn't change; but note that
the expected regression test output changed.

17 years agoAvoid considering both sort directions as equally useful for merging.
Tom Lane [Sat, 27 Oct 2007 05:45:43 +0000 (05:45 +0000)]
Avoid considering both sort directions as equally useful for merging.
This doubles the planning workload for mergejoins while not actually
accomplishing much.  The only useful case is where one of the directions
matches the query's ORDER BY request; therefore, put a thumb on the scales
in that direction, and otherwise arbitrarily consider only the ASC direction.
(This is a lot easier now than it would've been before 8.3, since we have
more semantic knowledge embedded in PathKeys now.)

17 years agoStamp 8.3beta2. REL8_3_BETA2
Tom Lane [Sat, 27 Oct 2007 00:22:42 +0000 (00:22 +0000)]
Stamp 8.3beta2.

17 years agoMinor wording improvements per suggestion from Jeff Davis. Also tweak
Tom Lane [Sat, 27 Oct 2007 00:19:45 +0000 (00:19 +0000)]
Minor wording improvements per suggestion from Jeff Davis.  Also tweak
hyphenated-word parser examples per earlier discussion with Alvaro.

17 years agoTranslation updates
Peter Eisentraut [Sat, 27 Oct 2007 00:13:43 +0000 (00:13 +0000)]
Translation updates

17 years agoChange win32 child-death tracking code to use a threadpool to wait for
Magnus Hagander [Fri, 26 Oct 2007 21:50:10 +0000 (21:50 +0000)]
Change win32 child-death tracking code to use a threadpool to wait for
childprocess deaths instead of using one thread per child. This drastastically
reduces the address space usage and should allow for more backends running.

Also change the win32_waitpid functionality to use an IO Completion Port for
queueing child death notices instead of using a fixed-size array.

17 years agoAllow an autovacuum worker to be interrupted automatically when it is found
Alvaro Herrera [Fri, 26 Oct 2007 20:45:10 +0000 (20:45 +0000)]
Allow an autovacuum worker to be interrupted automatically when it is found
to be locking another process (except when it's working to prevent Xid
wraparound problems).

17 years agoRemove second-in-paragraph usage of "Postgres" in FAQ_DEV.
Bruce Momjian [Fri, 26 Oct 2007 19:08:57 +0000 (19:08 +0000)]
Remove second-in-paragraph usage of "Postgres" in FAQ_DEV.

17 years agoRemove use of "Postgres" aliases in the FAQ in second-in-paragraph
Bruce Momjian [Fri, 26 Oct 2007 19:04:37 +0000 (19:04 +0000)]
Remove use of "Postgres" aliases in the FAQ in second-in-paragraph
cases.

17 years agoChange have_join_order_restriction() so that we do not force a clauseless join
Tom Lane [Fri, 26 Oct 2007 18:10:50 +0000 (18:10 +0000)]
Change have_join_order_restriction() so that we do not force a clauseless join
if either of the input relations can legally be joined to any other rels using
join clauses.  This avoids uselessly (and expensively) considering a lot of
really stupid join paths when there is a join restriction with a large
footprint, that is, lots of relations inside its LHS or RHS.  My patch of
15-Feb-2007 had been causing the code to consider joining *every* combination
of rels inside such a group, which is exponentially bad :-(.  With this
behavior, clauseless bushy joins will be done if necessary, but they'll be
put off as long as possible.  Per report from Jakub Ouhrabka.

Backpatch to 8.2.  We might someday want to backpatch to 8.1 as well, but 8.1
does not have the problem for OUTER JOIN nests, only for IN-clauses, so it's
not clear anyone's very likely to hit it in practice; and the current patch
doesn't apply cleanly to 8.1.

17 years agoAvoid having backend-only code compiled into ecpg. Per Zdenek Kotala
Tom Lane [Fri, 26 Oct 2007 14:17:53 +0000 (14:17 +0000)]
Avoid having backend-only code compiled into ecpg.  Per Zdenek Kotala

17 years agoAvoid including any backend-only stuff in the zic utility program.
Tom Lane [Fri, 26 Oct 2007 13:30:10 +0000 (13:30 +0000)]
Avoid including any backend-only stuff in the zic utility program.
Per gripe from Zdenek Kotala, though not exactly his patch.

17 years agoSet Japanese FAQ character code to UTF-8.
Bruce Momjian [Fri, 26 Oct 2007 03:59:22 +0000 (03:59 +0000)]
Set Japanese FAQ character code to UTF-8.

Jun Kuwamura

17 years agoAdd plpgsql doc example of RETURN NEXT.
Bruce Momjian [Fri, 26 Oct 2007 01:11:09 +0000 (01:11 +0000)]
Add plpgsql doc example of RETURN NEXT.

Ulrich Kroener

17 years agoMake initdb's selection of default text search configuration depend
Tom Lane [Thu, 25 Oct 2007 20:22:53 +0000 (20:22 +0000)]
Make initdb's selection of default text search configuration depend
only on the 'language' part of the locale name, ignoring the country code.
We may need to be smarter later when there are more built-in configurations,
but for now this is good enough and avoids having to bloat the table.

17 years agoFix memory management for new variables -- they must actually survive
Alvaro Herrera [Thu, 25 Oct 2007 19:13:37 +0000 (19:13 +0000)]
Fix memory management for new variables -- they must actually survive
transaction end, in case we decide to do a vacuum analyze (which is done in two
xacts).

17 years agoFix ALTER SEQUENCE so that it does not affect the value of currval() for
Tom Lane [Thu, 25 Oct 2007 18:54:03 +0000 (18:54 +0000)]
Fix ALTER SEQUENCE so that it does not affect the value of currval() for
the sequence.  Also, make setval() with is_called = false not affect the
currval state, either.  Per report from Kris Jurka that an implicit
ALTER SEQUENCE OWNED BY unexpectedly caused currval() to become valid.
Since this isn't 100% backwards compatible, it will go into HEAD only;
I'll put a more limited patch into 8.2.

17 years agoExtract catalog info for error reporting before an error actually happens.
Alvaro Herrera [Thu, 25 Oct 2007 14:45:55 +0000 (14:45 +0000)]
Extract catalog info for error reporting before an error actually happens.
Also, remove redundant reset of for-wraparound PGPROC flag.

Thanks to Tom Lane for noticing both bogosities.

17 years agoTweak new error messages to match the actual syntax of DECLARE CURSOR.
Tom Lane [Thu, 25 Oct 2007 13:48:57 +0000 (13:48 +0000)]
Tweak new error messages to match the actual syntax of DECLARE CURSOR.
(Last night I copied-and-pasted from the WITH HOLD case, but that's
wrong because of the bizarrely irregular syntax specified by the standard.)

17 years agoUse more real-world examples in the text search parser documentation.
Alvaro Herrera [Thu, 25 Oct 2007 13:06:35 +0000 (13:06 +0000)]
Use more real-world examples in the text search parser documentation.

17 years agoAdd new encoding aliases for Solaris, per Zdenek Kotala.
Alvaro Herrera [Thu, 25 Oct 2007 12:29:17 +0000 (12:29 +0000)]
Add new encoding aliases for Solaris, per Zdenek Kotala.

17 years agoUpdate release notes to current CVS.
Bruce Momjian [Thu, 25 Oct 2007 02:50:26 +0000 (02:50 +0000)]
Update release notes to current CVS.

17 years agoDisallow scrolling of FOR UPDATE/FOR SHARE cursors, so as to avoid problems
Tom Lane [Wed, 24 Oct 2007 23:27:08 +0000 (23:27 +0000)]
Disallow scrolling of FOR UPDATE/FOR SHARE cursors, so as to avoid problems
in corner cases such as re-fetching a just-deleted row.  We may be able to
relax this someday, but let's find out how many people really care before
we invest a lot of work in it.  Per report from Heikki and subsequent
discussion.

While in the neighborhood, make the combination of INSENSITIVE and FOR UPDATE
throw an error, since they are semantically incompatible.  (Up to now we've
accepted but just ignored the INSENSITIVE option of DECLARE CURSOR.)

17 years agoRemove obsolete statement that you can't update through a cursor.
Tom Lane [Wed, 24 Oct 2007 22:55:52 +0000 (22:55 +0000)]
Remove obsolete statement that you can't update through a cursor.

17 years agoRearrange vacuum-related bits in PGPROC as a bitmask, to better support
Alvaro Herrera [Wed, 24 Oct 2007 20:55:36 +0000 (20:55 +0000)]
Rearrange vacuum-related bits in PGPROC as a bitmask, to better support
having several of them.  Add two more flags: whether the process is
executing an ANALYZE, and whether a vacuum is for Xid wraparound (which
is obviously only set by autovacuum).

Sneakily move the worker's recently-acquired PostAuthDelay to a more useful
place.

17 years agoFix an error in make_outerjoininfo introduced by my patch of 30-Aug: the code
Tom Lane [Wed, 24 Oct 2007 20:54:27 +0000 (20:54 +0000)]
Fix an error in make_outerjoininfo introduced by my patch of 30-Aug: the code
neglected to test whether an outer join's join-condition actually refers to
the lower outer join it is looking at.  (The comment correctly described what
was supposed to happen, but the code didn't do it...)  This often resulted in
adding an unnecessary constraint on the join order of the two outer joins,
which was bad enough.  However, it also seems to expose a performance
problem in an older patch (from 15-Feb): once we've decided that there is a
join ordering constraint, we will start trying clauseless joins between every
combination of rels within the constraint, which pointlessly eats up lots of
time and space if there are numerous rels below the outer join.  That probably
needs to be revisited :-(.  Per gripe from Jakub Ouhrabka.

17 years agoDanish_Danmark -> Danish_Denmark
Alvaro Herrera [Wed, 24 Oct 2007 20:11:00 +0000 (20:11 +0000)]
Danish_Danmark -> Danish_Denmark

17 years agoMinor changes to autovacuum worker: change error handling so that it continues
Alvaro Herrera [Wed, 24 Oct 2007 19:08:25 +0000 (19:08 +0000)]
Minor changes to autovacuum worker: change error handling so that it continues
with the next table on schedule instead of exiting, in all cases instead of
just on query cancel.

Add a errcontext() line indicating the activity of the worker to the error
message when it is cancelled.

Change the WorkerInfo struct to contain a pointer to the worker's PGPROC
instead of just the PID.

Add forgotten post-auth delays, per Simon Riggs.  Also to autovac launcher.

17 years agoFix UPDATE/DELETE WHERE CURRENT OF to support repeated update and update-
Tom Lane [Wed, 24 Oct 2007 18:37:09 +0000 (18:37 +0000)]
Fix UPDATE/DELETE WHERE CURRENT OF to support repeated update and update-
then-delete on the current cursor row.  The basic fix is that nodeTidscan.c
has to apply heap_get_latest_tid() to the current-scan-TID obtained from the
cursor query; this ensures we get the latest row version to work with.
However, since that only works if the query plan is a TID scan, we also have
to hack the planner to make sure only that type of plan will be selected.
(Formerly, the planner might decide to apply a seqscan if the table is very
small.  This change is probably a Good Thing anyway, since it's hard to see
how a seqscan could really win.)  That means the execQual.c code to support
CurrentOfExpr as a regular expression type is dead code, so replace it with
just an elog().  Also, add regression tests covering these cases.  Note
that the added tests expose the fact that re-fetching an updated row
misbehaves if the cursor used FOR UPDATE.  That's an independent bug that
should be fixed later.  Per report from Dharmendra Goyal.

17 years agoKeep heap_page_prune from marking the buffer dirty when it didn't
Tom Lane [Wed, 24 Oct 2007 13:05:57 +0000 (13:05 +0000)]
Keep heap_page_prune from marking the buffer dirty when it didn't
really change anything.  Per report from Itagaki Takahiro.  Fix by
Pavan Deolasee.

17 years agoSet read_only = TRUE while evaluating input queries for ts_rewrite()
Tom Lane [Wed, 24 Oct 2007 03:30:03 +0000 (03:30 +0000)]
Set read_only = TRUE while evaluating input queries for ts_rewrite()
and ts_stat(), per my recent suggestion.  Also add a possibly-not-needed-
but-can't-hurt check for NULL SPI_tuptable, before we try to dereference
same.

17 years agoRemove the aggregate form of ts_rewrite(), since it doesn't work as desired
Tom Lane [Wed, 24 Oct 2007 02:24:49 +0000 (02:24 +0000)]
Remove the aggregate form of ts_rewrite(), since it doesn't work as desired
if there are zero rows to aggregate over, and the API seems both conceptually
and notationally ugly anyway.  We should look for something that improves
on the tsquery-and-text-SELECT version (which is also pretty ugly but at
least it works...), but it seems that will take query infrastructure that
doesn't exist today.  (Hm, I wonder if there's anything in or near SQL2003
window functions that would help?)  Per discussion.

17 years agoMake configure probe for the location of the <uuid.h> header file.
Tom Lane [Tue, 23 Oct 2007 21:38:16 +0000 (21:38 +0000)]
Make configure probe for the location of the <uuid.h> header file.
Needed to accommodate different layout on some platforms (Debian for
one).  Heikki Linnakangas

17 years agoRename and slightly redefine the default text search parser's "word"
Tom Lane [Tue, 23 Oct 2007 20:46:12 +0000 (20:46 +0000)]
Rename and slightly redefine the default text search parser's "word"
categories, as per discussion.  asciiword (formerly lword) is still
ASCII-letters-only, and numword (formerly word) is still the most general
mixed-alpha-and-digits case.  But word (formerly nlword) is now
any-group-of-letters-with-at-least-one-non-ASCII, rather than all-non-ASCII as
before.  This is no worse than before for parsing mixed Russian/English text,
which seems to have been the design center for the original coding; and it
should simplify matters for parsing most European languages.  In particular
it will not be necessary for any language to accept strings containing digits
as being regular "words".  The hyphenated-word categories are adjusted
similarly.

17 years agoUse snprintf instead of wsprintf, and use getenv("APPDATA") instead of
Magnus Hagander [Tue, 23 Oct 2007 17:58:01 +0000 (17:58 +0000)]
Use snprintf instead of wsprintf, and use getenv("APPDATA") instead of
SHGetFolderPath.

This removes the direct dependency on shell32.dll and user32.dll, which
eats a lot of "desktop heap" for each backend that's started. The
desktop heap is a very limited resource, causing backends to no
longer start once it's been exhausted.

We still have indirect depdendencies on user32.dll through third party
libraries, but those can't easily be removed.

Dave Page

17 years agoFix two-argument form of ts_rewrite() so it actually works for cases where
Tom Lane [Tue, 23 Oct 2007 01:44:40 +0000 (01:44 +0000)]
Fix two-argument form of ts_rewrite() so it actually works for cases where
a later rewrite rule should change a subtree modified by an earlier one.
Per my gripe of a few days ago.

17 years agoFix several bugs in tsvectorin, including crash due to uninitialized field and
Tom Lane [Tue, 23 Oct 2007 00:51:23 +0000 (00:51 +0000)]
Fix several bugs in tsvectorin, including crash due to uninitialized field and
miscomputation of required palloc size.  The crash could only occur if the
input contained lexemes both with and without positions, which is probably not
common in practice.  The miscomputation would definitely result in wasted
space.  Also fix some inconsistent coding around alignment of strings and
positions in a tsvector value; these errors could also lead to crashes given
mixed with/without position data and a machine that's picky about alignment.
And be more careful about checking for overflow of string offsets.

Patch is only against HEAD --- I have not looked to see if same bugs are
in back-branch contrib/tsearch2 code.

17 years agoClarify example of planner cost computation, per a suggestion from
Tom Lane [Mon, 22 Oct 2007 21:34:33 +0000 (21:34 +0000)]
Clarify example of planner cost computation, per a suggestion from
James Shaw.  Also update a couple of examples to reflect 8.3's improved
plan-printing code.

17 years agoAdjust ts_debug's output as per my proposal of yesterday: show the
Tom Lane [Mon, 22 Oct 2007 20:13:37 +0000 (20:13 +0000)]
Adjust ts_debug's output as per my proposal of yesterday: show the
active dictionary and its output lexemes as separate columns, instead
of smashing them into one text column, and lowercase the column names.
Also, define the output rowtype using OUT parameters instead of a
composite type, to be consistent with the other built-in functions.

17 years agoBe careful to get share lock on each page before computing its free space.
Tom Lane [Mon, 22 Oct 2007 17:29:35 +0000 (17:29 +0000)]
Be careful to get share lock on each page before computing its free space.
ITAGAKI Takahiro

17 years agoRemove an Assert that's been obsoleted by recent changes in the parsetree
Tom Lane [Mon, 22 Oct 2007 17:04:35 +0000 (17:04 +0000)]
Remove an Assert that's been obsoleted by recent changes in the parsetree
representation of DECLARE CURSOR.  Report and fix by Heikki.

17 years agoIncrease FD_SETSIZE on Win32 to allow for more than 54 clients.
Magnus Hagander [Mon, 22 Oct 2007 10:40:47 +0000 (10:40 +0000)]
Increase FD_SETSIZE on Win32 to allow for more than 54 clients.

Per Greg Stark & Dave Page

17 years agoCreate a quick-and-dirty list of known migration issues for pre-8.3
Tom Lane [Mon, 22 Oct 2007 03:37:04 +0000 (03:37 +0000)]
Create a quick-and-dirty list of known migration issues for pre-8.3
users of tsearch.  This isn't meant to be permanent documentation,
but to call out the areas that need either fixing or real documentation.

17 years agoAdd a useless return statement to suppress a warning seen with some
Tom Lane [Mon, 22 Oct 2007 01:02:22 +0000 (01:02 +0000)]
Add a useless return statement to suppress a warning seen with some
versions of gcc (I'm seeing it with Apple's gcc 4.0.1).  I think the
reason we did not see this before was that the assert() macros in the
regex code were all no-ops till recently.

17 years agoFix shared tsvector/tsquery input code so that we don't say "syntax error in
Tom Lane [Sun, 21 Oct 2007 22:29:56 +0000 (22:29 +0000)]
Fix shared tsvector/tsquery input code so that we don't say "syntax error in
tsvector" when we are really parsing a tsquery.  Report the bogus input,
too.  Make styles of some related error messages more consistent.

17 years agoEditorial overhaul for text search documentation. Organize the info
Tom Lane [Sun, 21 Oct 2007 20:04:37 +0000 (20:04 +0000)]
Editorial overhaul for text search documentation.  Organize the info
more clearly, improve a lot of unclear descriptions, add some missing
material.  We still need a migration guide though.

17 years agoUpdate Japanese FAQ.
Bruce Momjian [Sat, 20 Oct 2007 23:59:15 +0000 (23:59 +0000)]
Update Japanese FAQ.

Jun Kuwamura

17 years agoMore release note word-smithing.
Bruce Momjian [Sat, 20 Oct 2007 23:41:23 +0000 (23:41 +0000)]
More release note word-smithing.

17 years agoAdjust error message to agree with documentation. The tsearch documentation
Tom Lane [Sat, 20 Oct 2007 21:06:20 +0000 (21:06 +0000)]
Adjust error message to agree with documentation.  The tsearch documentation
uniformly calls these things weights, not classes.

17 years agoFix release tag spelling typo.
Bruce Momjian [Sat, 20 Oct 2007 20:19:06 +0000 (20:19 +0000)]
Fix release tag spelling typo.

17 years agoMore release note wording improvements.
Bruce Momjian [Sat, 20 Oct 2007 16:41:09 +0000 (16:41 +0000)]
More release note wording improvements.

17 years agoUpdate German FAQ.
Bruce Momjian [Sat, 20 Oct 2007 15:49:09 +0000 (15:49 +0000)]
Update German FAQ.

Ian Barwick

17 years agoAdd a note pointing out that you can't log to syslog without tweaking
Tom Lane [Sat, 20 Oct 2007 04:00:38 +0000 (04:00 +0000)]
Add a note pointing out that you can't log to syslog without tweaking
the syslog configuration file (at least not on most known Unixen).
I dunno why we hadn't had that info in the docs all along ...

17 years agoFound another small glitch in tsearch API: the two versions of ts_lexize()
Tom Lane [Fri, 19 Oct 2007 22:01:45 +0000 (22:01 +0000)]
Found another small glitch in tsearch API: the two versions of ts_lexize()
are really redundant, since we invented a regdictionary alias type.
We can have just one function, declared as taking regdictionary, and
it will handle both behaviors.  Noted while working on documentation.

17 years agots_rewrite() does not return a set, only one row; fix mislabeling in
Tom Lane [Fri, 19 Oct 2007 19:48:34 +0000 (19:48 +0000)]
ts_rewrite() does not return a set, only one row; fix mislabeling in
pg_proc.h.

17 years agoMore indenting cleanup for release notes.
Bruce Momjian [Fri, 19 Oct 2007 01:56:06 +0000 (01:56 +0000)]
More indenting cleanup for release notes.

17 years agoConsistently indent release notes for prior releases.
Bruce Momjian [Thu, 18 Oct 2007 23:34:54 +0000 (23:34 +0000)]
Consistently indent release notes for prior releases.

17 years agoMore release wording adjustments.
Bruce Momjian [Thu, 18 Oct 2007 23:05:06 +0000 (23:05 +0000)]
More release wording adjustments.

17 years agoMore indenting cleanup, tag additions.
Bruce Momjian [Thu, 18 Oct 2007 16:47:58 +0000 (16:47 +0000)]
More indenting cleanup, tag additions.

17 years agoMove a few items into migration from the main changes section. Indent
Bruce Momjian [Thu, 18 Oct 2007 16:45:05 +0000 (16:45 +0000)]
Move a few items into migration from the main changes section.  Indent
8.3 consistently.

17 years agoMinor fixes for the release notes.
Neil Conway [Thu, 18 Oct 2007 06:07:23 +0000 (06:07 +0000)]
Minor fixes for the release notes.

17 years agoSmall changes to release note descriptions.
Bruce Momjian [Thu, 18 Oct 2007 05:39:06 +0000 (05:39 +0000)]
Small changes to release note descriptions.

17 years agoFirst pass over release documentation. I trimmed down some of the
Bruce Momjian [Thu, 18 Oct 2007 05:15:48 +0000 (05:15 +0000)]
First pass over release documentation.  I trimmed down some of the
entries and removed a few.

17 years agoRe-add FAQ item:
Bruce Momjian [Wed, 17 Oct 2007 17:34:51 +0000 (17:34 +0000)]
Re-add FAQ item:

    <H3 id="item4.19">4.19) Why do I get "relation with OID #####
    does not exist" errors when accessing temporary tables in PL/PgSQL
    functions?</H3>

17 years agoAdd missing entry for PG_WIN1250 encoding, per gripe from Pavel Stehule.
Tom Lane [Wed, 17 Oct 2007 15:24:04 +0000 (15:24 +0000)]
Add missing entry for PG_WIN1250 encoding, per gripe from Pavel Stehule.
Also enable translation of PG_WIN874, which certainly seems to have an
obvious translation now, though maybe it did not at the time this table's
ancestor was created.

17 years agoAnother round of editorialization on the text search documentation.
Tom Lane [Wed, 17 Oct 2007 01:01:28 +0000 (01:01 +0000)]
Another round of editorialization on the text search documentation.
Notably, standardize on using "token" for the strings output by a parser,
while "lexeme" is reserved for the normalized strings produced by a
dictionary.

17 years agoMention Slony as just an example.
Bruce Momjian [Tue, 16 Oct 2007 19:44:18 +0000 (19:44 +0000)]
Mention Slony as just an example.

17 years agoFix the URL properly per Robert Treat.
Magnus Hagander [Tue, 16 Oct 2007 19:04:34 +0000 (19:04 +0000)]
Fix the URL properly per Robert Treat.

17 years agoUse 'token' not 'lexeme' to describe the output of a parser.
Tom Lane [Tue, 16 Oct 2007 18:02:26 +0000 (18:02 +0000)]
Use 'token' not 'lexeme' to describe the output of a parser.

17 years agoTweak toast-related logic in heapam.c so that the toaster is only invoked
Tom Lane [Tue, 16 Oct 2007 17:05:26 +0000 (17:05 +0000)]
Tweak toast-related logic in heapam.c so that the toaster is only invoked
when relkind = RELKIND_RELATION.  This syncs these tests with the Asserts
in tuptoaster.c, and ensures that we won't ever try to, for example,
compress a sequence's tuple.  Problem found by Greg Stark while stress-testing
with much-smaller-than-normal page sizes.

17 years agoTeach pgxs.mk and Install.pm how to install files from a contrib module
Tom Lane [Tue, 16 Oct 2007 16:00:00 +0000 (16:00 +0000)]
Teach pgxs.mk and Install.pm how to install files from a contrib module
into SHAREDIR/tsearch_data.  Use this instead of ad-hoc coding in
dict_xsyn/Makefile.  Should fix current ContribCheck failures on MSVC.

17 years agoAdd doc clarifications for warm standby.
Bruce Momjian [Tue, 16 Oct 2007 14:56:51 +0000 (14:56 +0000)]
Add doc clarifications for warm standby.

17 years agoUpdate URLs to a couple of external projects
Magnus Hagander [Tue, 16 Oct 2007 12:14:33 +0000 (12:14 +0000)]
Update URLs to a couple of external projects

17 years agoRe-allow UTF8 encodings on win32. Since UTF8 is converted to
Magnus Hagander [Tue, 16 Oct 2007 11:30:16 +0000 (11:30 +0000)]
Re-allow UTF8 encodings on win32. Since UTF8 is converted to
UTF16 before being used, all (valid) locales will work for this.

17 years agoRemove quotes around locale names in some places for consistency.
Peter Eisentraut [Tue, 16 Oct 2007 09:09:11 +0000 (09:09 +0000)]
Remove quotes around locale names in some places for consistency.

17 years agoSlony switch is only seconds of downtime.
Bruce Momjian [Tue, 16 Oct 2007 05:37:40 +0000 (05:37 +0000)]
Slony switch is only seconds of downtime.

17 years agoAdd mention of Slony for in-place upgrades.
Bruce Momjian [Tue, 16 Oct 2007 02:48:57 +0000 (02:48 +0000)]
Add mention of Slony for in-place upgrades.

17 years agoFix pg_wchar_table[] to match revised ordering of the encoding ID enum.
Tom Lane [Mon, 15 Oct 2007 22:46:27 +0000 (22:46 +0000)]
Fix pg_wchar_table[] to match revised ordering of the encoding ID enum.
Add some comments so hopefully the next poor sod doesn't fall into the
same trap.  (Wrong comments are worse than none at all...)

17 years agoRemove obsolete examples of add-on parsers and dictionary templates;
Tom Lane [Mon, 15 Oct 2007 21:39:57 +0000 (21:39 +0000)]
Remove obsolete examples of add-on parsers and dictionary templates;
these are more easily and usefully maintained as contrib modules.
Various other wordsmithing, markup improvement, etc.

17 years agoAdd sample text search dictionary templates and parsers, to replace the
Tom Lane [Mon, 15 Oct 2007 21:36:50 +0000 (21:36 +0000)]
Add sample text search dictionary templates and parsers, to replace the
hard-to-maintain textual examples currently in the SGML docs.  From
Sergey Karpov.

17 years agoInclude NOLOGIN roles in the 'flat' password file. In the original
Tom Lane [Mon, 15 Oct 2007 15:11:29 +0000 (15:11 +0000)]
Include NOLOGIN roles in the 'flat' password file.  In the original
coding this was seen as useless, but the problem with not including them
is that the error message will often be something about authentication
failure, rather than the more helpful one about 'role is not permitted
to log in'.  Per discussion.