summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2007-10-24Disallow scrolling of FOR UPDATE/FOR SHARE cursors, so as to avoid problemsTom Lane
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.)
2007-10-24Remove obsolete statement that you can't update through a cursor.Tom Lane
2007-10-24Remove the aggregate form of ts_rewrite(), since it doesn't work as desiredTom Lane
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.
2007-10-23Rename and slightly redefine the default text search parser's "word"Tom Lane
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.
2007-10-22Clarify example of planner cost computation, per a suggestion fromTom Lane
James Shaw. Also update a couple of examples to reflect 8.3's improved plan-printing code.
2007-10-22Adjust ts_debug's output as per my proposal of yesterday: show theTom Lane
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.
2007-10-22Create a quick-and-dirty list of known migration issues for pre-8.3Tom Lane
users of tsearch. This isn't meant to be permanent documentation, but to call out the areas that need either fixing or real documentation.
2007-10-21Editorial overhaul for text search documentation. Organize the infoTom Lane
more clearly, improve a lot of unclear descriptions, add some missing material. We still need a migration guide though.
2007-10-20Update Japanese FAQ.Bruce Momjian
Jun Kuwamura
2007-10-20More release note word-smithing.Bruce Momjian
2007-10-20Fix release tag spelling typo.Bruce Momjian
2007-10-20More release note wording improvements.Bruce Momjian
2007-10-20Update German FAQ.Bruce Momjian
Ian Barwick
2007-10-20Add a note pointing out that you can't log to syslog without tweakingTom Lane
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 ...
2007-10-19More indenting cleanup for release notes.Bruce Momjian
2007-10-18Consistently indent release notes for prior releases.Bruce Momjian
2007-10-18More release wording adjustments.Bruce Momjian
2007-10-18More indenting cleanup, tag additions.Bruce Momjian
2007-10-18Move a few items into migration from the main changes section. IndentBruce Momjian
8.3 consistently.
2007-10-18Minor fixes for the release notes.Neil Conway
2007-10-18Small changes to release note descriptions.Bruce Momjian
2007-10-18First pass over release documentation. I trimmed down some of theBruce Momjian
entries and removed a few.
2007-10-17Re-add FAQ item:Bruce Momjian
<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>
2007-10-17Another round of editorialization on the text search documentation.Tom Lane
Notably, standardize on using "token" for the strings output by a parser, while "lexeme" is reserved for the normalized strings produced by a dictionary.
2007-10-16Mention Slony as just an example.Bruce Momjian
2007-10-16Fix the URL properly per Robert Treat.Magnus Hagander
2007-10-16Add doc clarifications for warm standby.Bruce Momjian
2007-10-16Update URLs to a couple of external projectsMagnus Hagander
2007-10-16Slony switch is only seconds of downtime.Bruce Momjian
2007-10-16Add mention of Slony for in-place upgrades.Bruce Momjian
2007-10-15Remove obsolete examples of add-on parsers and dictionary templates;Tom Lane
these are more easily and usefully maintained as contrib modules. Various other wordsmithing, markup improvement, etc.
2007-10-13Migrate the former contrib/txid module into core. This will make it easierTom Lane
for Slony and Skytools to depend on it. Per discussion.
2007-10-13Attached some minor corrections, mainly completion of removal ofBruce Momjian
the "relation with OID ##### does not exist" item, and some URL corrections. Ian Barwick
2007-10-11Add missing word.Bruce Momjian
2007-10-11Add missing word.Bruce Momjian
2007-10-11Update release notes in "major" and "migration" sections. Still haveBruce Momjian
remainder of release notes to review.
2007-10-11Whitespace cleanup.Bruce Momjian
2007-10-10Minor correction for full-text search limitations docs.Neil Conway
Heikki Linnakangas.
2007-10-10Fix typo in REVOKE reference page. Guillaume Lelarge.Neil Conway
2007-10-10Back out release changes that weren't ready for commit.Bruce Momjian
2007-10-10Update Japanese FAQ.Bruce Momjian
Jun Kuwamura
2007-10-09Add mention of full text indexing for word searches.Bruce Momjian
2007-10-09Remove FAQ item about temp tables in plpsql having invalid oid problems,Bruce Momjian
per suggestions from Pavel Stehule.
2007-10-09Update sequence FAQ items, per suggestion from Pavel Stehule.Bruce Momjian
2007-10-09Replace a reference to "start_log_collector" with "logging_collector",Neil Conway
per Guillaume Lelarge.
2007-10-09Update Brazilian FAQ.Bruce Momjian
Euler Taveira de Oliveira
2007-10-09Typo fix.Bruce Momjian
Euler Taveira de Oliveira
2007-10-09Add:Bruce Momjian
> * MONEY dumps in a locale-specific format making it difficult to > restore to a system with a different locale
2007-10-09Clarify user of "postmaster" vs. "server" in FAQs.Bruce Momjian
Brendan Jurd
2007-10-08Add:Bruce Momjian
> o Have ALTER SEQUENCE RENAME rename the sequence name stored > in the sequence table > > http://archives.postgresql.org/pgsql-bugs/2007-09/msg00092.php > http://archives.postgresql.org/pgsql-bugs/2007-10/msg00007.php >
generated by cgit v1.2.3 (git 2.46.0) at 2025-11-13 07:22:08 +0000