[COMMITTERS] pgsql: Fix rounding problem in interval_div by using rint(), and improve

2005-07-23 Thread Bruce Momjian
Log Message: --- Fix rounding problem in interval_div by using rint(), and improve interval_mul function. Modified Files: -- pgsql/src/backend/utils/adt: timestamp.c (r1.145 -> r1.146) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/

[COMMITTERS] pgsql: Fix logic error in tbm_intersect: the intersection of a normal

2005-07-23 Thread Tom Lane
Log Message: --- Fix logic error in tbm_intersect: the intersection of a normal page and a lossy page has to be lossy, because we don't know exactly which tuples on the page should remain part of the bitmap. Per Jie Zhang. Modified Files: -- pgsql/src/backend/nodes:

[COMMITTERS] bizgres - bizgres: Fixed an incorrect bitmap intersect operation in the

2005-07-23 Thread User Jzhang
Log Message: --- Fixed an incorrect bitmap intersect operation in the Bitmap Scan. Modified Files: -- bizgres/postgresql/src/backend/nodes: tidbitmap.c (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/postgresql/src/backend/nodes/

[COMMITTERS] pgsql: Fix some failures to initialize table entries induced by recent

2005-07-23 Thread Tom Lane
Log Message: --- Fix some failures to initialize table entries induced by recent autovacuum integration. Not clear this explains recent stats problems, but it's definitely wrong. Modified Files: -- pgsql/src/backend/postmaster: pgstat.c (r1.100 -> r1.101)

[COMMITTERS] pginstaller - pginst: Remove culled/to-be-culled contrib modules.

2005-07-23 Thread User Dpage
Log Message: --- Remove culled/to-be-culled contrib modules. Untested, and dialogues need re-laying out. Modified Files: -- pginst/ca: pginstca.c (r1.76 -> r1.77) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/ca/pginstca.c.diff?r1=1.76&r2

[COMMITTERS] pgsql: Simple constraint exclusion.

2005-07-23 Thread Tom Lane
Log Message: --- Simple constraint exclusion. For now, only child tables of inheritance scans are candidates for exclusion; this should be fixed eventually. Simon Riggs, with some help from Tom Lane. Modified Files: -- pgsql/doc/src/sgml: runtime.sgml (r1.338 -> r1

[COMMITTERS] pginstaller - pginst: Reformat XML

2005-07-23 Thread User Dpage
Log Message: --- Reformat XML Modified Files: -- pginst/wxs: dialogs.wxs (r1.46 -> r1.47) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxs/dialogs.wxs.diff?r1=1.46&r2=1.47) pginst.wxs (r1.119 -> r1.120) (http://cvs.pgfoun

[COMMITTERS] pginstaller - pginst: Start tweaking things for 8.1

2005-07-23 Thread User Dpage
Log Message: --- Start tweaking things for 8.1 Modified Files: -- pginst/bmp: top.bmp (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/bmp/top.bmp.diff?r1=1.2&r2=1.3) pginst/txt: welcome.rtf (r1.13 -> r1.14)

Re: [COMMITTERS] pgsql: Add time/date macros for code clarity:

2005-07-23 Thread Marc G. Fournier
On Thu, 21 Jul 2005, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian writes: Tom Lane wrote: In short, I don't think this is an improvement. The problem is that 24 or 30 or 60 doesn't really say what it is, while the macros are self-documenting. Except that they're NOT. Anyone who i

[COMMITTERS] pgsql: Remove unintended code addition.

2005-07-23 Thread Bruce Momjian
Log Message: --- Remove unintended code addition. Modified Files: -- pgsql/src/backend/access/transam: xlog.c (r1.209 -> r1.210) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c.diff?r1=1.209&r2=1.210) ---

[COMMITTERS] pgsql: Macro alignment cleanup.

2005-07-23 Thread Bruce Momjian
Log Message: --- Macro alignment cleanup. Modified Files: -- pgsql/src/backend/access/transam: xlog.c (r1.208 -> r1.209) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c.diff?r1=1.208&r2=1.209) ---

[COMMITTERS] pgsql: Improve computations of interval_div to prevent rounding problem

2005-07-23 Thread Bruce Momjian
Log Message: --- Improve computations of interval_div to prevent rounding problem on AIX. Modified Files: -- pgsql/src/backend/utils/adt: timestamp.c (r1.144 -> r1.145) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff

Re: [COMMITTERS] pgsql: In the stats test, delay for the stats collector to catch up

2005-07-23 Thread Michael Fuhr
On Sat, Jul 23, 2005 at 11:18:57AM -0300, Tom Lane wrote: > In the stats test, delay for the stats collector to catch up using a > function that actually sleeps, instead of busy-waiting. Perhaps this > will resolve some of the intermittent stats failures we keep seeing. Any chance of exposing a s

[COMMITTERS] pgbuildfarm - client-code: save config log and CVS log where possible.

2005-07-23 Thread User Andrewd
Log Message: --- save config log and CVS log where possible. this is in preparation for uploading all log files regardless of status. Modified Files: -- client-code: run_build.pl (r1.35 -> r1.36) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbuildfarm/cli

Re: [COMMITTERS] pgsql: In the stats test, delay for the stats collector

2005-07-23 Thread Bruce Momjian
Tom Lane wrote: > Log Message: > --- > In the stats test, delay for the stats collector to catch up using a > function that actually sleeps, instead of busy-waiting. Perhaps this > will resolve some of the intermittent stats failures we keep seeing. Good. I was seeing these random stat f

[COMMITTERS] pgsql: Andrew pointed out that the current fix didn't handle dates that

2005-07-23 Thread Bruce Momjian
Log Message: --- Andrew pointed out that the current fix didn't handle dates that were near daylight savings time boudaries. This handles it properly, e.g. test=> select '2005-04-03 04:00:00'::timestamp at time zone 'America/Los_Angeles'; timezone -

[COMMITTERS] pgsql: In the stats test, delay for the stats collector to catch up

2005-07-23 Thread Tom Lane
Log Message: --- In the stats test, delay for the stats collector to catch up using a function that actually sleeps, instead of busy-waiting. Perhaps this will resolve some of the intermittent stats failures we keep seeing. Modified Files: -- pgsql/src/test/regress/expecte