[COMMITTERS] python - web: Script to synchronize the current build to

2005-04-23 Thread James William Pye
Log Message: --- Script to synchronize the current build to python.projects.postgresql.org Added Files: --- web: sync (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/web/sync?rev=1.1&content-type=text/x-cvsweb-markup) ---(end

[COMMITTERS] pgsql: Update VACUUM VERBOSE FSM message, per Tom.

2005-04-23 Thread Bruce Momjian
Log Message: --- Update VACUUM VERBOSE FSM message, per Tom. Modified Files: -- pgsql/src/backend/storage/freespace: freespace.c (r1.43 -> r1.44) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/freespace/freespace.c.diff?r1=1.43&r2=1.4

[COMMITTERS] python - be: Use get_attro and fill in members structure.

2005-04-23 Thread James William Pye
Log Message: --- Use get_attro and fill in members structure. Change PyHT's tuple descriptor accessor from 'desc' to 'TupleDesc'(like Pg.Type) Member entries are "virtual" as get_attro will grab them before it would ever get to GenericGetAttro. Disallow HT creation if the arg count in tupd_

[COMMITTERS] tablelog - tablelog: Written a restore view creating function in plpgsql

2005-04-23 Thread User Kimhanse
Log Message: --- Written a restore view creating function in plpgsql Modified Files: -- tablelog: table_log_init.sql (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/tablelog/tablelog/table_log_init.sql.diff?r1=1.2&r2=1.3) Added Files: -

[COMMITTERS] tablelog - tablelog: New Directory

2005-04-23 Thread User Kimhanse
Update of /cvsroot/tablelog/tablelog/notes In directory pgfoundry.org:/tmp/cvs-serv2939/notes Log Message: Directory /cvsroot/tablelog/tablelog/notes added to the repository ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[COMMITTERS] pgsql: Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov.

2005-04-23 Thread Tom Lane
Log Message: --- Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov. Comparison of timetz values misbehaved in --enable-integer-datetime cases, and EXTRACT(EPOCH) subtracted the zone instead of adding it in all cases. Backpatch to all supported releases (except --enable-integer-d

[COMMITTERS] pgsql: Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov.

2005-04-23 Thread Tom Lane
Log Message: --- Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov. Comparison of timetz values misbehaved in --enable-integer-datetime cases, and EXTRACT(EPOCH) subtracted the zone instead of adding it in all cases. Backpatch to all supported releases (except --enable-integer-d

[COMMITTERS] python - be: Move fnExtraCalls list to pl.c.

2005-04-23 Thread James William Pye
Log Message: --- Move fnExtraCalls list to pl.c. All insertions to the list occur after the call is made, thus allowing the decision to be based on the success of the call(if it errored or if it's the end of the VPC-SRF, there's no need to keep state). Also select out fn_extra before hitt

[COMMITTERS] pgsql: Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov.

2005-04-23 Thread Tom Lane
Log Message: --- Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov. Comparison of timetz values misbehaved in --enable-integer-datetime cases, and EXTRACT(EPOCH) subtracted the zone instead of adding it in all cases. Backpatch to all supported releases (except --enable-integer-d

[COMMITTERS] pgsql: Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov.

2005-04-23 Thread Tom Lane
Log Message: --- Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov. Comparison of timetz values misbehaved in --enable-integer-datetime cases, and EXTRACT(EPOCH) subtracted the zone instead of adding it in all cases. Backpatch to all supported releases (except --enable-integer-d

[COMMITTERS] pgsql: Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov.

2005-04-23 Thread Tom Lane
Log Message: --- Repair two TIME WITH TIME ZONE bugs found by Dennis Vshivkov. Comparison of timetz values misbehaved in --enable-integer-datetime cases, and EXTRACT(EPOCH) subtracted the zone instead of adding it in all cases. Backpatch to all supported releases (except --enable-integer-d

[COMMITTERS] pgsql: Remove useless argtype_inherit() code, and make consequent

2005-04-23 Thread Tom Lane
Log Message: --- Remove useless argtype_inherit() code, and make consequent simplifications. As I pointed out a few days ago, this code has failed to do anything useful for some time ... and if we did want to revive the capability to select functions by nearness of inheritance ancestry, thi

[COMMITTERS] pgsql: Item already added to existing 'thread' item: < * Consider

2005-04-23 Thread Bruce Momjian
Log Message: --- Item already added to existing 'thread' item: < * Consider parallel processing a single query < < This would involve using multiple threads or processes to do optimization, < sorting, or execution of single query. The major advantage of such a < feature would be to

[COMMITTERS] pgsql: Turns out our existing page size is already optimal in most

2005-04-23 Thread Bruce Momjian
Log Message: --- Turns out our existing page size is already optimal in most cases: < * Research the use of larger page sizes Modified Files: -- pgsql/doc: TODO (r1.1512 -> r1.1513) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1512&

[COMMITTERS] pgsql: Remove item, not sure what it refers to: < * Allow ORDER BY ...

2005-04-23 Thread Bruce Momjian
Log Message: --- Remove item, not sure what it refers to: < * Allow ORDER BY ... LIMIT 1 to select high/low value without sort or < index using a sequential scan for highest/lowest values < < If only one value is needed, there is no need to sort the entire < table. Instead a sequent

[COMMITTERS] pgsql: Remove explicit FreeExprContext calls during plan node shutdown.

2005-04-23 Thread Tom Lane
Log Message: --- Remove explicit FreeExprContext calls during plan node shutdown. The ExprContexts will be freed anyway when FreeExecutorState() is reached, and letting that routine do the work is more efficient because it will automatically free the ExprContexts in reverse creation order.

[COMMITTERS] pgsql: New item: > * Change WAL to use 32-bit CRC, for performance

2005-04-23 Thread Bruce Momjian
Log Message: --- New item: > * Change WAL to use 32-bit CRC, for performance reasons Modified Files: -- pgsql/doc: TODO (r1.1509 -> r1.1510) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1509&r2=1.1510) pgsql/doc/src/FAQ:

[COMMITTERS] pgsql: Update threading item: < Solaris) might benefit from

2005-04-23 Thread Bruce Momjian
Log Message: --- Update threading item: < Solaris) might benefit from threading. > Solaris) might benefit from threading. Also explore the idea of > a single session using multiple threads to execute a query faster. Modified Files: -- pgsql/doc: TODO (r1.150

[COMMITTERS] pgsql: Done: < * Improve SMP performance on i386 machines > * -Improve

2005-04-23 Thread Bruce Momjian
Log Message: --- Done: < * Improve SMP performance on i386 machines > * -Improve SMP performance on i386 machines Modified Files: -- pgsql/doc: TODO (r1.1507 -> r1.1508) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1507&r2=1.1508)

[COMMITTERS] pgsql: Done: < * Optimize locale to have minimal performance impact

2005-04-23 Thread Bruce Momjian
Log Message: --- Done: < * Optimize locale to have minimal performance impact when not used Modified Files: -- pgsql/doc: TODO (r1.1506 -> r1.1507) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1506&r2=1.1507) pgsql/doc/src/FAQ:

[COMMITTERS] pgsql: Fix typo: < * Add ISo INTERVAL handling > * Add ISO INTERVAL

2005-04-23 Thread Bruce Momjian
Log Message: --- Fix typo: < * Add ISo INTERVAL handling > * Add ISO INTERVAL handling Modified Files: -- pgsql/doc: TODO (r1.1505 -> r1.1506) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1505&r2=1.1506) pgsql/doc/src/FAQ:

[COMMITTERS] pgsql: Update VACUUM VERBOSE update, per Alvaro.

2005-04-23 Thread Bruce Momjian
Log Message: --- Update VACUUM VERBOSE update, per Alvaro. Modified Files: -- pgsql/src/backend/storage/freespace: freespace.c (r1.42 -> r1.43) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/freespace/freespace.c.diff?r1=1.42&r2=1.43)

[COMMITTERS] pgsql: Update working of VACUUM VERBOSE.

2005-04-23 Thread Bruce Momjian
Log Message: --- Update working of VACUUM VERBOSE. Modified Files: -- pgsql/src/backend/storage/freespace: freespace.c (r1.41 -> r1.42) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/freespace/freespace.c.diff?r1=1.41&r2=1.42) --

[COMMITTERS] pgsql: Make VACUUM VERBOSE FSM output all output in a single INFO output

2005-04-23 Thread Bruce Momjian
Log Message: --- Make VACUUM VERBOSE FSM output all output in a single INFO output statement. Modified Files: -- pgsql/src/backend/storage/freespace: freespace.c (r1.40 -> r1.41) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/freespac

[COMMITTERS] pgsql: Move info about lack of depencency checking in Makefiles to

2005-04-23 Thread Bruce Momjian
Log Message: --- Move info about lack of depencency checking in Makefiles to developer's faq.q Modified Files: -- pgsql/doc: FAQ_DEV (r1.92 -> r1.93) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_DEV.diff?r1=1.92&r2=1.93) pgsql/doc/src/FAQ:

[COMMITTERS] pgsql: Update FAQ by eliminating non-frequent items like large objects

2005-04-23 Thread Bruce Momjian
Log Message: --- Update FAQ by eliminating non-frequent items like large objects and extending questions. Update wording of various entries. Modified Files: -- pgsql/doc: FAQ (r1.340 -> r1.341) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff

[COMMITTERS] pgsql: Done: > * -Allow non-bitmap indexes to be combined by creating

2005-04-23 Thread Bruce Momjian
Log Message: --- Done: > * -Allow non-bitmap indexes to be combined by creating bitmaps in memory Modified Files: -- pgsql/doc: TODO (r1.1504 -> r1.1505) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1504&r2=1.1505) pgsql/doc/src

[COMMITTERS] pgsql: Update H4 tag to H3 to be consistent with heading levels.

2005-04-23 Thread Bruce Momjian
Log Message: --- Update H4 tag to H3 to be consistent with heading levels. Modified Files: -- pgsql/doc: FAQ (r1.339 -> r1.340) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.339&r2=1.340) pgsql/doc/src/FAQ: FAQ.html (r1.296

[COMMITTERS] pgsql: Add item about server-side debugging.

2005-04-23 Thread Bruce Momjian
Log Message: --- Add item about server-side debugging. Modified Files: -- pgsql/doc: FAQ_DEV (r1.91 -> r1.92) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_DEV.diff?r1=1.91&r2=1.92) pgsql/doc/src/FAQ: FAQ_DEV.html (r1.94 -> r1.95)

[COMMITTERS] pgsql: Update FAQ items to point to existing web pages rather than

2005-04-23 Thread Bruce Momjian
Log Message: --- Update FAQ items to point to existing web pages rather than duplication such information. Remove MySQL mention. Move server-side debug item to developer's FAQ. Update URLs. Modified Files: -- pgsql/doc: FAQ (r1.338 -> r1.339) (http://dev

[COMMITTERS] pgsql: Add comment about checkpoint panic behavior during shutdown, per

2005-04-23 Thread Tom Lane
Log Message: --- Add comment about checkpoint panic behavior during shutdown, per suggestion from Qingqing Zhou. Modified Files: -- pgsql/src/backend/access/transam: xlog.c (r1.187 -> r1.188) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/acc

[COMMITTERS] pgsql: Allow -2147483648 to be treated as an INT4 rather than INT8

2005-04-23 Thread Tom Lane
Log Message: --- Allow -2147483648 to be treated as an INT4 rather than INT8 constant. Per discussion with Paul Edwards. Modified Files: -- pgsql/src/backend/parser: parse_node.c (r1.87 -> r1.88) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend

[COMMITTERS] tablelog - tablelog: Moved debugging #ifdef's to a single block in start

2005-04-23 Thread User Kimhanse
Log Message: --- Moved debugging #ifdef's to a single block in start of code Modified Files: -- tablelog: table_log.c (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/tablelog/tablelog/table_log.c.diff?r1=1.9&r2=1.10) --

[COMMITTERS] pgsql: Treat a zero-D array as empty in int_enum(), per

2005-04-23 Thread Tom Lane
Log Message: --- Treat a zero-D array as empty in int_enum(), per [EMAIL PROTECTED] Modified Files: -- pgsql/contrib/intagg: int_aggregate.c (r1.18 -> r1.19) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/intagg/int_aggregate.c.diff?r1=1.18&r2=1.

[COMMITTERS] pgsql: Recent changes got the sense of the notnull bit backwards in the

2005-04-23 Thread Tom Lane
Log Message: --- Recent changes got the sense of the notnull bit backwards in the 2.0 protocol output routines. Mea culpa :-(. Per report from Kris Jurka. Modified Files: -- pgsql/src/backend/access/common: printtup.c (r1.88 -> r1.89) (http://developer.po

[COMMITTERS] pgsql: Define the right-hand input of AT TIME ZONE as a full a_expr

2005-04-23 Thread Tom Lane
Log Message: --- Define the right-hand input of AT TIME ZONE as a full a_expr instead of c_expr. Perhaps the restriction was once needed to avoid bison errors, but it seems to work just fine now --- and even generates a slightly smaller state machine. This change allows examples like SELE

[COMMITTERS] tablelog - tablelog: Use the quoting functions from the server

2005-04-23 Thread User Kimhanse
Log Message: --- Use the quoting functions from the server Modified Files: -- tablelog: table_log.c (r1.8 -> r1.9) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/tablelog/tablelog/table_log.c.diff?r1=1.8&r2=1.9) ---(end of broadcast)-

[COMMITTERS] pgsql: Update FAQ release number to 8.0.2.

2005-04-23 Thread Bruce Momjian
Log Message: --- Update FAQ release number to 8.0.2. Modified Files: -- pgsql/doc: FAQ (r1.337 -> r1.338) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.337&r2=1.338) pgsql/doc/src/FAQ: FAQ.html (r1.294 -> r1.295) (

[COMMITTERS] pgsql: Modify output of VACUUM VERBOSE to be clearer.

2005-04-23 Thread Bruce Momjian
Log Message: --- Modify output of VACUUM VERBOSE to be clearer. Modified Files: -- pgsql/src/backend/storage/freespace: freespace.c (r1.39 -> r1.40) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/freespace/freespace.c.diff?r1=1.39&r2=