summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2007-09-18Avoid possibly-unportable initializer, per buildfarm warningTeodor Sigaev
per notice by Gregory Stark <stark@enterprisedb.com>
2007-09-18Doc reminder that integer pg version also needs updating.Bruce Momjian
2007-09-17Remove extra tab in postgresql.confBruce Momjian
2007-09-16Remove Assert(BgWriterShmem != NULL), which is rather pointless sinceTom Lane
we'd dump core anyway immediately afterward if it were null; and it seems to confuse some versions of icc into generating bad code. Per report from Sergey Koposov. Patched in HEAD only, for the moment, since this is only likely to affect developers.
2007-09-16Fix overflow in extract(epoch from interval) for intervals exceeding 68 years.Tom Lane
Seems to have been introduced in 8.1 by careless SECS_PER_DAY search-and-replace.
2007-09-16Update release notes for last-minute fix.Tom Lane
2007-09-16Fix aboriginal mistake in lazy VACUUM's code for truncating awayTom Lane
no-longer-needed pages at the end of a table. We thought we could throw away pages containing HEAPTUPLE_DEAD tuples; but this is not so, because such tuples very likely have index entries pointing at them, and we wouldn't have removed the index entries. The problem only emerges in a somewhat unlikely race condition: the dead tuples have to have been inserted by a transaction that later aborted, and this has to have happened between VACUUM's initial scan of the page and then rechecking it for empty in count_nondeletable_pages. But that timespan will include an index-cleaning pass, so it's not all that hard to hit. This seems to explain a couple of previously unsolved bug reports.
2007-09-15Update Japanese FAQ.Bruce Momjian
Jun Kuwamura
2007-09-14Add:Bruce Momjian
> > o Prevent long-lived temporary tables from causing frozen-xid > advancement starvation > > http://archives.postgresql.org/pgsql-general/2007-06/msg01645.php
2007-09-14Add:Bruce Momjian
> > * Make it possible to use RETURNING together with conditional DO INSTEAD > rules, such as for partitioning setups > > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00577.php
2007-09-14Fix markup.Bruce Momjian
2007-09-14Update pronunciation FAQ item.Bruce Momjian
2007-09-14Update to mention alternate project name is "Postgres".Bruce Momjian
2007-09-14Remove GIN interface section, which is now documented in SGML.Bruce Momjian
Heikki Linnakangas
2007-09-14Fix markup that doesn't work in back branches.Tom Lane
2007-09-14Fix GSS API pointer checking.Bruce Momjian
Kris Jurka
2007-09-14Document atan2() as y/x, rather than x/y, to conform to general usage.Bruce Momjian
Andrew Maclean
2007-09-14Minor editorialization on release notes.Tom Lane
2007-09-14Add some links for escape strings.Bruce Momjian
Brendan Jurd Fix markup in previous commit.
2007-09-14Add LDAP URL documentation.Bruce Momjian
Albe Laurenz
2007-09-14Update documentation to mention that autovacuum also does analyze so weBruce Momjian
don't need to recommend nightly analyzes anymore unless autovacuum is off.
2007-09-14Clarify tar documentation about return error codes.Bruce Momjian
Backpatch to 8.2.X.
2007-09-14Update tsearch include location in example.Bruce Momjian
Oleg.
2007-09-14Add tsearch tab completion support:Bruce Momjian
* 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
2007-09-14This is small patch fixes a spi example (PG_MODULE_MAGIC is required asBruce Momjian
of PostgreSQL 8.2) and provides a link to compiling and linking section. Euler Taveira de Oliveira
2007-09-14Update GNU tar error code documentation.Bruce Momjian
Backpatch to 8.2.X.
2007-09-14Mentino that PAM doesn't work for Unix system authentication because ofBruce Momjian
the problems non-root reading /etc/shadow.
2007-09-14Remove ill-considered (not to mention undocumented) attempt to makeTom Lane
contrib/intarray's GIN opclass override the built-in default. Per bug #3048 and other complaints.
2007-09-14Update documented error text.Bruce Momjian
Fujii Masao
2007-09-14Clarify age() 'months' calculation documentation.Bruce Momjian
2007-09-13Update documentation to emphasize autovacuum rather thanBruce Momjian
administrator-scheduled vacuums.
2007-09-13Fix typo in typecasting.Teodor Sigaev
patch from ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
2007-09-13Update Japanese FAQ, backpatch.Bruce Momjian
Jun Kuwamura
2007-09-12Fix a memory leak in the autovacuum launcher code. Noted by Darcy Buskermolen,Alvaro Herrera
who reported it privately to me.
2007-09-12Redefine the lp_flags field of item pointers as having four states, ratherTom Lane
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.
2007-09-12Perform post-escaping encoding validity checks on SQL literals and COPY inputAndrew Dunstan
so that invalidly encoded data cannot enter the database by these means.
2007-09-12Whitespace improvement.Bruce Momjian
2007-09-12Revert ill-starred change to ICC anti-aliasing switches. PerTom Lane
Jeremy Drake.
2007-09-12Install dictionary sample files.Magnus Hagander
Per buildfarm and Teodor.
2007-09-12Document an efficient way to create documentation for back branches.Bruce Momjian
2007-09-12Update Japanese FAQ to current release number.Bruce Momjian
2007-09-12Add a CHECK_FOR_INTERRUPTS call in the site where the vacuum delay pointAlvaro Herrera
was removed.
2007-09-11Give ICC its preferred, documented form of the no-strict-aliasingTom Lane
switch, viz '-fno-alias'. Since we have a separate code path here anyway, it's just as easy to cooperate.
2007-09-11Sync timezone data with 2007g zic release.Tom Lane
2007-09-11Upcoming most recent release will be 8.2.5.Bruce Momjian
2007-09-11StampBruce Momjian
2007-09-11Make sure that open hash table scans are cleaned up when bgwriter tries toTom Lane
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.
2007-09-11Include hash table name in all the internal-error elog messages inTom Lane
dynahash.c. Sergey Koposov's current open problem shows the possible usefulness of this, and it doesn't add much code.
2007-09-11Remove QueryOperand->istrue flag, it was used only in cover rankingTeodor Sigaev
(ts_rank_cd). Use palloc'ed array in ranking instead of flag.
2007-09-11Fix header's size of structs defines in ispell.Teodor Sigaev
Backpatch is needed for contrib version.
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-13 20:31:42 +0000