aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Fix markup that doesn't work in back branches.Tom Lane2007-09-14
|
* Fix GSS API pointer checking.Bruce Momjian2007-09-14
| | | | Kris Jurka
* Document atan2() as y/x, rather than x/y, to conform to general usage.Bruce Momjian2007-09-14
| | | | Andrew Maclean
* Minor editorialization on release notes.Tom Lane2007-09-14
|
* Add some links for escape strings.Bruce Momjian2007-09-14
| | | | | | Brendan Jurd Fix markup in previous commit.
* Add LDAP URL documentation.Bruce Momjian2007-09-14
| | | | Albe Laurenz
* Update documentation to mention that autovacuum also does analyze so weBruce Momjian2007-09-14
| | | | don't need to recommend nightly analyzes anymore unless autovacuum is off.
* Clarify tar documentation about return error codes.Bruce Momjian2007-09-14
| | | | Backpatch to 8.2.X.
* Update tsearch include location in example.Bruce Momjian2007-09-14
| | | | Oleg.
* Add tsearch tab completion support:Bruce Momjian2007-09-14
| | | | | | | | | | | | | | | | | | | | | | | | | | * adds a few missing words to some commands (like adding GIN as a valid index type or OWNED BY for ALTER SEQUENCE,...) * support for ALTER TABLE foo ENABLE/DISABLE REPLICA TRIGGER/RULE * autocomplete CREATE DATABASE foo TEMPLATE (mostly done to prevent conflicts with the TEMPLATE keyword for text search) * support for ALTER/CREATE/DROP TEXT SEARCH as well as COMMENT ON TEXT SEARCH and the corresponding psql backslash commands. This proved a little more difficult than expected due to the fact that words_after_create[] is used for two purposes - one is to provide a list of words that follow immediatly after CREATE (or DROP) and the other purpose is to use it for autocompleting anywhere in the statement if the word in that struct is found with a query. Since TEXT SEARCH CONFIGURATION|DICTIONARY|TEMPLATE|PARSER results in 3 words instead of one (as all the other words in that list are) I added a flag to the struct to tell create_command_generator() to skip that entry for autocompleting immediatly after CREATE which feels like a dirty hack (but that holds true for a lot of code in tab-complete.c). Stefan Kaltenbrunner
* This is small patch fixes a spi example (PG_MODULE_MAGIC is required asBruce Momjian2007-09-14
| | | | | | of PostgreSQL 8.2) and provides a link to compiling and linking section. Euler Taveira de Oliveira
* Update GNU tar error code documentation.Bruce Momjian2007-09-14
| | | | Backpatch to 8.2.X.
* Mentino that PAM doesn't work for Unix system authentication because ofBruce Momjian2007-09-14
| | | | the problems non-root reading /etc/shadow.
* Remove ill-considered (not to mention undocumented) attempt to makeTom Lane2007-09-14
| | | | | contrib/intarray's GIN opclass override the built-in default. Per bug #3048 and other complaints.
* Update documented error text.Bruce Momjian2007-09-14
| | | | Fujii Masao
* Clarify age() 'months' calculation documentation.Bruce Momjian2007-09-14
|
* Update documentation to emphasize autovacuum rather thanBruce Momjian2007-09-13
| | | | administrator-scheduled vacuums.
* Fix typo in typecasting.Teodor Sigaev2007-09-13
| | | | patch from ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
* Update Japanese FAQ, backpatch.Bruce Momjian2007-09-13
| | | | Jun Kuwamura
* Fix a memory leak in the autovacuum launcher code. Noted by Darcy Buskermolen,Alvaro Herrera2007-09-12
| | | | who reported it privately to me.
* Redefine the lp_flags field of item pointers as having four states, ratherTom Lane2007-09-12
| | | | | | | | | than two independent bits (one of which was never used in heap pages anyway, or at least hadn't been in a very long time). This gives us flexibility to add the HOT notions of redirected and dead item pointers without requiring anything so klugy as magic values of lp_off and lp_len. The state values are chosen so that for the states currently in use (pre-HOT) there is no change in the physical representation.
* Perform post-escaping encoding validity checks on SQL literals and COPY inputAndrew Dunstan2007-09-12
| | | | so that invalidly encoded data cannot enter the database by these means.
* Whitespace improvement.Bruce Momjian2007-09-12
|
* Revert ill-starred change to ICC anti-aliasing switches. PerTom Lane2007-09-12
| | | | Jeremy Drake.
* Install dictionary sample files.Magnus Hagander2007-09-12
| | | | Per buildfarm and Teodor.
* Document an efficient way to create documentation for back branches.Bruce Momjian2007-09-12
|
* Update Japanese FAQ to current release number.Bruce Momjian2007-09-12
|
* Add a CHECK_FOR_INTERRUPTS call in the site where the vacuum delay pointAlvaro Herrera2007-09-12
| | | | was removed.
* Give ICC its preferred, documented form of the no-strict-aliasingTom Lane2007-09-11
| | | | | switch, viz '-fno-alias'. Since we have a separate code path here anyway, it's just as easy to cooperate.
* Sync timezone data with 2007g zic release.Tom Lane2007-09-11
|
* Upcoming most recent release will be 8.2.5.Bruce Momjian2007-09-11
|
* StampBruce Momjian2007-09-11
|
* Make sure that open hash table scans are cleaned up when bgwriter tries toTom Lane2007-09-11
| | | | | | | | recover from elog(ERROR). Problem was created by introduction of hash seq search tracking awhile back, and affects all branches that have bgwriter; in HEAD the disease has snuck into autovacuum and walwriter too. (Not sure that the latter two use hash_seq_search at the moment, but surely they might someday.) Per report from Sergey Koposov.
* Include hash table name in all the internal-error elog messages inTom Lane2007-09-11
| | | | | dynahash.c. Sergey Koposov's current open problem shows the possible usefulness of this, and it doesn't add much code.
* Remove QueryOperand->istrue flag, it was used only in cover rankingTeodor Sigaev2007-09-11
| | | | (ts_rank_cd). Use palloc'ed array in ranking instead of flag.
* Fix header's size of structs defines in ispell.Teodor Sigaev2007-09-11
| | | | Backpatch is needed for contrib version.
* Add regression tests for ispell, synonym and thesaurus dictionaries.Teodor Sigaev2007-09-11
| | | | | | | | Rename synonym.syn.sample and thesaurs.ths.sample to synonym_sample.syn and thesaurs_sample.ths accordingly to be able to use they in regression test. Ispell dictionary uses synthetic simple dictionary files.
* Fix ts_debug function to prevent unneeded calls of ts_lexize().Teodor Sigaev2007-09-11
| | | | | It will be mush better to reimplement ts_debug in C (instead of SQL as now), but it's planned for the future.
* Refactor from Heikki Linnakangas <heikki@enterprisedb.com>:Teodor Sigaev2007-09-11
| | | | | | | | | | | | | | * Defined new struct WordEntryPosVector that holds a uint16 length and a variable size array of WordEntries. This replaces the previous convention of a variable size uint16 array, with the first element implying the length. WordEntryPosVector has the same layout in memory, but is more readable in source code. The POSDATAPTR and POSDATALEN macros are still used, though it would now be more readable to access the fields in WordEntryPosVector directly. * Removed needfree field from DocRepresentation. It was always set to false. * Miscellaneous other commenting and refactoring
* Rename recently-added pg_stat_activity column from txn_start to xact_start,Tom Lane2007-09-11
| | | | for consistency with other column names such as in pg_stat_database.
* Arrange for SET LOCAL's effects to persist until the end of the current topTom Lane2007-09-11
| | | | | | | | | | | | | | transaction, unless rolled back or overridden by a SET clause for the same variable attached to a surrounding function call. Per discussion, these seem the best semantics. Note that this is an INCOMPATIBLE CHANGE: in 8.0 through 8.2, SET LOCAL's effects disappeared at subtransaction commit (leading to behavior that made little sense at the SQL level). I took advantage of the opportunity to rewrite and simplify the GUC variable save/restore logic a little bit. The old idea of a "tentative" value is gone; it was a hangover from before we had a stack. Also, we no longer need a stack entry for every nesting level, but only for those in which a variable's value actually changed.
* Make CLUSTER and REINDEX silently skip remote temp tables in theirAlvaro Herrera2007-09-10
| | | | | | database-wide editions. Per report from bitsandbytes88 <at> hotmail.com and subsequent discussion.
* Release the exclusive lock on the table early after truncating it in lazyAlvaro Herrera2007-09-10
| | | | vacuum, instead of waiting till commit.
* Heikki Linnakangas <heikki@enterprisedb.com>:Teodor Sigaev2007-09-10
| | | | | Add tsearch subdirectory is added to Makefile to allow compile custom tsearch dictionary as an external module.
* Fix recently introduced bugs about parsing ispell/hunspell files.Teodor Sigaev2007-09-10
| | | | | | In most cases it cause because of unneeded lowercasing of flags. Per experiment with regression checks with ispell dictionary.
* Remove the vacuum_delay_point call in count_nondeletable_pages, because we holdAlvaro Herrera2007-09-10
| | | | | | | | | | | | an exclusive lock on the table at this point, which we want to release as soon as possible. This is called in the phase of lazy vacuum where we truncate the empty pages at the end of the table. An alternative solution would be to lower the vacuum delay settings before starting the truncating phase, but this doesn't work very well in autovacuum due to the autobalancing code (which can cause other processes to change our cost delay settings). This case could be considered in the balancing code, but it is simpler this way.
* Change void* opaque argument to Datum type, add argument'sTeodor Sigaev2007-09-10
| | | | | | name to PushFunction type definition. Per suggestion by Tome Lane <tgl@sss.pgh.pa.us>
* Fixes from Heikki Linnakangas <heikki@enterprisedb.com>:Teodor Sigaev2007-09-10
| | | | | | | Apparently it's a bug I introduced when I refactored spell.c to use the readline function for reading and recoding the input file. I didn't notice that some calls to STRNCMP used the non-lowercased version of the input line.
* Revert temporary patch that made synchronous_commit default to OFF.Tom Lane2007-09-10
|
* Set the correct context (PGC_SIGHUP) for log_autovacuum, per ITAGAKI Takahiro.Tom Lane2007-09-10
| | | | Fix grammatical errors in its description.