summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2007-10-30Add note on PostgreSQL vs. Postgres.Peter Eisentraut
2007-10-30Update some obsolete stuff in the GRANT and REVOKE reference pages:Tom Lane
simplify the syntax examples by unifying user and group cases, and fix no-longer-correct example of psql \z output. Per Erwin Brandstetter.
2007-10-30Add a note pointing out that some other databases make GREATEST andTom Lane
LEAST handle NULL arguments differently than we do. Per a discussion on 30-Jun that somehow didn't get done.
2007-10-29Documentation wording fixes.Bruce Momjian
Guillaume Lelarge
2007-10-29Update Russian FAQ.Bruce Momjian
corochoone@gmail.com
2007-10-29Clarify restart is of the "database" server, in FAQ.Bruce Momjian
2007-10-29Remove claim that ts_headline knows how to generate multiple ellipsis-separatedTom Lane
excerpts of a document. That's clearly desirable, but the functionality is not there yet.
2007-10-27Rename default text search parser's "uri" token type to "url_path",Tom Lane
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.
2007-10-27Minor wording improvements per suggestion from Jeff Davis. Also tweakTom Lane
hyphenated-word parser examples per earlier discussion with Alvaro.
2007-10-26Remove second-in-paragraph usage of "Postgres" in FAQ_DEV.Bruce Momjian
2007-10-26Remove use of "Postgres" aliases in the FAQ in second-in-paragraphBruce Momjian
cases.
2007-10-26Set Japanese FAQ character code to UTF-8.Bruce Momjian
Jun Kuwamura
2007-10-26Add plpgsql doc example of RETURN NEXT.Bruce Momjian
Ulrich Kroener
2007-10-25Fix ALTER SEQUENCE so that it does not affect the value of currval() forTom Lane
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.
2007-10-25Use more real-world examples in the text search parser documentation.Alvaro Herrera
2007-10-25Update release notes to current CVS.Bruce Momjian
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