[COMMITTERS] pgsql: Release builds generate different strangely formatted export

2007-05-03 Thread Magnus Hagander
Log Message:
---
Release builds generate different strangely formatted export names
for local symbols, that shouldn't be exported. This patch excludes them,
cutting down about 10,000 exported symbols and decreasing the binary size
by 20%.

Modified Files:
--
pgsql/src/tools/msvc:
gendef.pl (r1.5 -> r1.6)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/tools/msvc/gendef.pl.diff?r1=1.5&r2=1.6)

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


[COMMITTERS] pgsql: Fix some typos in the documentation.

2007-05-03 Thread Neil Conway
Log Message:
---
Fix some typos in the documentation. Patch from Brian Gough. Backport
the relevant fixes to 8.2 as well.

Modified Files:
--
pgsql/doc/src/sgml:
datatype.sgml (r1.198 -> r1.199)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datatype.sgml.diff?r1=1.198&r2=1.199)
ddl.sgml (r1.73 -> r1.74)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ddl.sgml.diff?r1=1.73&r2=1.74)
plperl.sgml (r2.64 -> r2.65)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plperl.sgml.diff?r1=2.64&r2=2.65)
spi.sgml (r1.56 -> r1.57)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/spi.sgml.diff?r1=1.56&r2=1.57)

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


[COMMITTERS] pgsql: Fix some typos in the documentation.

2007-05-03 Thread Neil Conway
Log Message:
---
Fix some typos in the documentation. Patch from Brian Gough. Backport
the relevant fixes to 8.2 as well.

Tags:

REL8_2_STABLE

Modified Files:
--
pgsql/doc/src/sgml:
ddl.sgml (r1.69 -> r1.69.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ddl.sgml.diff?r1=1.69&r2=1.69.2.1)
plperl.sgml (r2.59.2.1 -> r2.59.2.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plperl.sgml.diff?r1=2.59.2.1&r2=2.59.2.2)
spi.sgml (r1.49 -> r1.49.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/spi.sgml.diff?r1=1.49&r2=1.49.2.1)

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[COMMITTERS] pgsql: Fix a few more double words in docs.

2007-05-03 Thread Alvaro Herrera
Log Message:
---
Fix a few more double words in docs.

Tags:

REL8_2_STABLE

Modified Files:
--
pgsql/doc/src/sgml:
external-projects.sgml (r1.14 -> r1.14.2.1)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/external-projects.sgml.diff?r1=1.14&r2=1.14.2.1)
release.sgml (r1.488.2.10 -> r1.488.2.11)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.488.2.10&r2=1.488.2.11)

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


[COMMITTERS] pgsql: Fix a few more double words in docs.

2007-05-03 Thread Alvaro Herrera
Log Message:
---
Fix a few more double words in docs.

Modified Files:
--
pgsql/doc/src/sgml:
external-projects.sgml (r1.15 -> r1.16)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/external-projects.sgml.diff?r1=1.15&r2=1.16)
maintenance.sgml (r1.72 -> r1.73)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/maintenance.sgml.diff?r1=1.72&r2=1.73)
release.sgml (r1.502 -> r1.503)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.502&r2=1.503)
pgsql/doc/src/sgml/ref:
psql-ref.sgml (r1.190 -> r1.191)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/psql-ref.sgml.diff?r1=1.190&r2=1.191)

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


[COMMITTERS] pgsql: Tweak hash index AM to use the new ReadOrZeroBuffer bufmgr API

2007-05-03 Thread Tom Lane
Log Message:
---
Tweak hash index AM to use the new ReadOrZeroBuffer bufmgr API when fetching
pages it intends to zero immediately.  Just to show there is some use for that
function besides WAL recovery :-).
Along the way, fold _hash_checkpage and _hash_pageinit calls into _hash_getbuf
and friends, instead of expecting callers to do that separately.

Modified Files:
--
pgsql/contrib/pgstattuple:
pgstattuple.c (r1.26 -> r1.27)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pgstattuple/pgstattuple.c.diff?r1=1.26&r2=1.27)
pgsql/src/backend/access/hash:
hash.c (r1.93 -> r1.94)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hash.c.diff?r1=1.93&r2=1.94)
hashinsert.c (r1.44 -> r1.45)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hashinsert.c.diff?r1=1.44&r2=1.45)
hashovfl.c (r1.56 -> r1.57)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hashovfl.c.diff?r1=1.56&r2=1.57)
hashpage.c (r1.66 -> r1.67)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hashpage.c.diff?r1=1.66&r2=1.67)
hashsearch.c (r1.48 -> r1.49)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hashsearch.c.diff?r1=1.48&r2=1.49)
hashutil.c (r1.51 -> r1.52)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hashutil.c.diff?r1=1.51&r2=1.52)
pgsql/src/include/access:
hash.h (r1.79 -> r1.80)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/hash.h.diff?r1=1.79&r2=1.80)

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[COMMITTERS] pgsql: Teach tuplesort.c about "top N" sorting, in which only the first

2007-05-03 Thread Tom Lane
Log Message:
---
Teach tuplesort.c about "top N" sorting, in which only the first N tuples
need be returned.  We keep a heap of the current best N tuples and sift-up
new tuples into it as we scan the input.  For M input tuples this means
only about M*log(N) comparisons instead of M*log(M), not to mention a lot
less workspace when N is small --- avoiding spill-to-disk for large M
is actually the most attractive thing about it.  Patch includes planner
and executor support for invoking this facility in ORDER BY ... LIMIT
queries.  Greg Stark, with some editorialization by moi.

Modified Files:
--
pgsql/src/backend/executor:
nodeLimit.c (r1.29 -> r1.30)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeLimit.c.diff?r1=1.29&r2=1.30)
nodeSort.c (r1.60 -> r1.61)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeSort.c.diff?r1=1.60&r2=1.61)
pgsql/src/backend/optimizer/path:
costsize.c (r1.181 -> r1.182)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/costsize.c.diff?r1=1.181&r2=1.182)
pgsql/src/backend/optimizer/plan:
createplan.c (r1.229 -> r1.230)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/createplan.c.diff?r1=1.229&r2=1.230)
planmain.c (r1.100 -> r1.101)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planmain.c.diff?r1=1.100&r2=1.101)
planner.c (r1.218 -> r1.219)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c.diff?r1=1.218&r2=1.219)
pgsql/src/backend/optimizer/util:
pathnode.c (r1.139 -> r1.140)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/pathnode.c.diff?r1=1.139&r2=1.140)
pgsql/src/backend/utils/misc:
guc.c (r1.389 -> r1.390)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c.diff?r1=1.389&r2=1.390)
pgsql/src/backend/utils/sort:
tuplesort.c (r1.74 -> r1.75)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/sort/tuplesort.c.diff?r1=1.74&r2=1.75)
pgsql/src/include/nodes:
execnodes.h (r1.172 -> r1.173)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/execnodes.h.diff?r1=1.172&r2=1.173)
pgsql/src/include/optimizer:
cost.h (r1.85 -> r1.86)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/cost.h.diff?r1=1.85&r2=1.86)
planmain.h (r1.100 -> r1.101)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/planmain.h.diff?r1=1.100&r2=1.101)
pgsql/src/include/utils:
tuplesort.h (r1.25 -> r1.26)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/tuplesort.h.diff?r1=1.25&r2=1.26)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] pgsql: A few fixups in error handling: mark pg_re_throw() as noreturn

2007-05-03 Thread Tom Lane
Log Message:
---
A few fixups in error handling: mark pg_re_throw() as noreturn for gcc,
and for other compilers, insert a dummy exit() call so that they understand
PG_RE_THROW() doesn't return.  Insert fflush(stderr) in ExceptionalCondition,
per recent buildfarm evidence that that might not happen automatically on some
platforms.  And const-ify ExceptionalCondition's declaration while at it.

Modified Files:
--
pgsql/src/backend/utils/error:
assert.c (r1.33 -> r1.34)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/error/assert.c.diff?r1=1.33&r2=1.34)
elog.c (r1.184 -> r1.185)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/error/elog.c.diff?r1=1.184&r2=1.185)
pgsql/src/include:
postgres.h (r1.79 -> r1.80)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/postgres.h.diff?r1=1.79&r2=1.80)
pgsql/src/include/utils:
elog.h (r1.85 -> r1.86)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/elog.h.diff?r1=1.85&r2=1.86)

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


[COMMITTERS] pgsql: Suppress a recently-introduced 'variable might be clobbered by

2007-05-03 Thread Tom Lane
Log Message:
---
Suppress a recently-introduced 'variable might be clobbered by longjmp' warning.

Modified Files:
--
pgsql/src/backend/postmaster:
autovacuum.c (r1.44 -> r1.45)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/autovacuum.c.diff?r1=1.44&r2=1.45)

---(end of broadcast)---
TIP 6: explain analyze is your friend