summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
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-20Adjust error message to agree with documentation. The tsearch documentationTom Lane
uniformly calls these things weights, not classes.
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-19Found another small glitch in tsearch API: the two versions of ts_lexize()Tom Lane
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.
2007-10-19ts_rewrite() does not return a set, only one row; fix mislabeling inTom Lane
pg_proc.h.
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-17Add missing entry for PG_WIN1250 encoding, per gripe from Pavel Stehule.Tom Lane
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.
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-16Use 'token' not 'lexeme' to describe the output of a parser.Tom Lane
2007-10-16Tweak toast-related logic in heapam.c so that the toaster is only invokedTom Lane
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.
2007-10-16Teach pgxs.mk and Install.pm how to install files from a contrib moduleTom Lane
into SHAREDIR/tsearch_data. Use this instead of ad-hoc coding in dict_xsyn/Makefile. Should fix current ContribCheck failures on MSVC.
2007-10-16Add doc clarifications for warm standby.Bruce Momjian
2007-10-16Update URLs to a couple of external projectsMagnus Hagander
2007-10-16Re-allow UTF8 encodings on win32. Since UTF8 is converted toMagnus Hagander
UTF16 before being used, all (valid) locales will work for this.
2007-10-16Remove quotes around locale names in some places for consistency.Peter Eisentraut
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-15Fix pg_wchar_table[] to match revised ordering of the encoding ID enum.Tom Lane
Add some comments so hopefully the next poor sod doesn't fall into the same trap. (Wrong comments are worse than none at all...)
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-15Add sample text search dictionary templates and parsers, to replace theTom Lane
hard-to-maintain textual examples currently in the SGML docs. From Sergey Karpov.
2007-10-15Include NOLOGIN roles in the 'flat' password file. In the originalTom Lane
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.
2007-10-14make install is supposed to install everything under src/include/,Tom Lane
but it was missing a bunch of recently-added subdirectories.
2007-10-13Ooops, forgot about adding -DFRONTEND.Tom Lane
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-13Remove contrib/txid, in preparation for migrating it into core.Tom Lane
2007-10-13Try to fix msvc build for recent initdb changes.Tom Lane
2007-10-13Strengthen type_sanity's check on pg_type.typarray. It failed toTom Lane
complain about types that didn't have typarray set. Noted while working on txid patch.
2007-10-13Guard against possible double free during error escape from XMLTom Lane
functions. Patch for the reported issue from Kris Jurka, some other potential trouble spots plugged by Tom.
2007-10-13Fix the inadvertent libpq ABI breakage discovered by Martin Pitt: theTom Lane
renumbering of encoding IDs done between 8.2 and 8.3 turns out to break 8.2 initdb and psql if they are run with an 8.3beta1 libpq.so. For the moment we can rearrange the order of enum pg_enc to keep the same number for everything except PG_JOHAB, which isn't a problem since there are no direct references to it in the 8.2 programs anyway. (This does force initdb unfortunately.) Going forward, we want to fix things so that encoding IDs can be changed without an ABI break, and this commit includes the changes needed to allow libpq's encoding IDs to be treated as fully independent of the backend's. The main issue is that libpq clients should not include pg_wchar.h or otherwise assume they know the specific values of libpq's encoding IDs, since they might encounter version skew between pg_wchar.h and the libpq.so they are using. To fix, have libpq officially export functions needed for encoding name<=>ID conversion and validity checking; it was doing this anyway unofficially. It's still the case that we can't renumber backend encoding IDs until the next bump in libpq's major version number, since doing so will break the 8.2-era client programs. However the code is now prepared to avoid this type of problem in future. Note that initdb is no longer a libpq client: we just pull in the two source files we need directly. The patch also fixes a few places that were being sloppy about checking for an unrecognized encoding name.
2007-10-13Fix ALTER COLUMN TYPE to preserve the tablespace and reloptions of indexesTom Lane
it affects. The original coding neglected tablespace entirely (causing the indexes to move to the database's default tablespace) and for an index belonging to a UNIQUE or PRIMARY KEY constraint, it would actually try to assign the parent table's reloptions to the index :-(. Per bug #3672 and subsequent investigation. 8.0 and 8.1 did not have reloptions, but the tablespace bug is present.
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-13Teach planagg.c that partial indexes specifying WHERE foo IS NOT NULL can beTom Lane
used to perform MIN(foo) or MAX(foo), since we want to discard null rows in the indexscan anyway. (This would probably fall out for free if we were injecting the IS NOT NULL clause somewhere earlier, but given the current anatomy of the MIN/MAX optimization code we have to do it explicitly. Fortunately, very little added code is needed.) Per a discussion with Henk de Wit.
2007-10-12When telling the bgwriter that we need a checkpoint because too much xlogTom Lane
has been consumed, recheck against the latest value of RedoRecPtr before really sending the signal. This avoids useless checkpoint activity if XLogWrite is executed when we have a very stale local copy of RedoRecPtr. The potential for useless checkpoint is very much worse in 8.3 because of the walwriter process (which never does XLogInsert), so while this behavior was intentional, it needs to be changed. Per report from Itagaki Takahiro.
2007-10-12Remove hack in pg_tablespace_aclmask() that disallowed permissionsTom Lane
on pg_global even to superusers, and replace it with checks in various other places to complain about invalid uses of pg_global. This ends up being a bit more code but it allows a more specific error message to be given, and it un-breaks pg_tablespace_size() on pg_global. Per discussion.
2007-10-11Ensure that the result of evaluating a function during constant-expressionTom Lane
simplification gets detoasted before it is incorporated into a Const node. Otherwise, if an immutable function were to return a TOAST pointer (an unlikely case, but it can be made to happen), we would end up with a plan that depends on the continued existence of the out-of-line toast datum.