[COMMITTERS] docbot - docbot: Rename to pg_docbot.
Log Message: --- Rename to pg_docbot. Modified Files: -- docbot: docbot.pl (r1.25 -> r1.26) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/docbot/docbot/docbot.pl.diff?r1=1.25&r2=1.26) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] docbot - docbot: Updated db dump.
Log Message: --- Updated db dump. Modified Files: -- docbot: rtfm_please.sql (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/docbot/docbot/rtfm_please.sql.diff?r1=1.2&r2=1.3) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] pgsql: Use InitFunctionCallInfoData() macro instead of MemSet in
Log Message: --- Use InitFunctionCallInfoData() macro instead of MemSet in performance critical places in execQual. By Atsushi Ogawa; some minor cleanup by moi. Modified Files: -- pgsql/src/backend/executor: execQual.c (r1.173 -> r1.174) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execQual.c.diff?r1=1.173&r2=1.174) nodeAgg.c (r1.130 -> r1.131) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeAgg.c.diff?r1=1.130&r2=1.131) pgsql/src/backend/utils/fmgr: fmgr.c (r1.89 -> r1.90) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/fmgr/fmgr.c.diff?r1=1.89&r2=1.90) pgsql/src/backend/utils/sort: tuplesort.c (r1.46 -> r1.47) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/sort/tuplesort.c.diff?r1=1.46&r2=1.47) pgsql/src/include: fmgr.h (r1.36 -> r1.37) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/fmgr.h.diff?r1=1.36&r2=1.37) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] docbot - docbot: Fixed do_learn and do_forget to handle three
Log Message: --- Fixed do_learn and do_forget to handle three parameters instead of two. Modified Files: -- docbot: docbot.pl (r1.26 -> r1.27) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/docbot/docbot/docbot.pl.diff?r1=1.26&r2=1.27) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[COMMITTERS] pgaccess - pgaccess: New Directory
Update of /cvsroot/pgaccess/pgaccess/lib/widgets/tablelist3.8/images In directory pgfoundry.org:/tmp/cvs-serv2257/tablelist3.8/images Log Message: Directory /cvsroot/pgaccess/pgaccess/lib/widgets/tablelist3.8/images added to the repository ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgaccess - pgaccess: updating tables to use tablelist for data display
Log Message: --- updating tables to use tablelist for data display and edit Modified Files: -- pgaccess: changelog (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/changelog.diff?r1=1.4&r2=1.5) pgaccess/lib: queries.tcl (r1.1.1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/queries.tcl.diff?r1=1.1.1.1&r2=1.2) tables.tcl (r1.1.1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/tables.tcl.diff?r1=1.1.1.1&r2=1.2) pgaccess/main: load.tcl (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/main/load.tcl.diff?r1=1.2&r2=1.3) Added Files: --- pgaccess/lib/widgets/tablelist3.8: CHANGES.txt (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/CHANGES.txt?rev=1.1&content-type=text/x-cvsweb-markup) COPYRIGHT.txt (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/COPYRIGHT.txt?rev=1.1&content-type=text/x-cvsweb-markup) README.txt (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/README.txt?rev=1.1&content-type=text/x-cvsweb-markup) pkgIndex.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/pkgIndex.tcl?rev=1.1&content-type=text/x-cvsweb-markup) tablelist.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/tablelist.tcl?rev=1.1&content-type=text/x-cvsweb-markup) Removed Files: - pgaccess/lib/widgets/tablelist3.3: CHANGES.txt (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/CHANGES.txt) COPYRIGHT.txt (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/COPYRIGHT.txt) README.txt (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/README.txt) pkgIndex.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/pkgIndex.tcl) tablelist.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/tablelist.tcl) pgaccess/lib/widgets/tablelist3.3/scripts: mwutil.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/scripts/mwutil.tcl) repair.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/scripts/repair.tcl) tablelistBind.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/scripts/tablelistBind.tcl) tablelistConfig.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/scripts/tablelistConfig.tcl) tablelistEdit.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/scripts/tablelistEdit.tcl) tablelistMove.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/scripts/tablelistMove.tcl) tablelistSort.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/scripts/tablelistSort.tcl) tablelistUtil.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/scripts/tablelistUtil.tcl) tablelistWidget.tcl (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/scripts/tablelistWidget.tcl) tclIndex (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.3/scripts/tclIndex) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] pgaccess - pgaccess: New Directory
Update of /cvsroot/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts In directory pgfoundry.org:/tmp/cvs-serv2257/tablelist3.8/scripts Log Message: Directory /cvsroot/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts added to the repository ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgsql: WAL must log CREATE and DROP DATABASE operations *without* using
Log Message: --- WAL must log CREATE and DROP DATABASE operations *without* using any explicit paths, so that the log can be replayed in a data directory with a different absolute path than the original had. To avoid forcing initdb in the 8.0 branch, continue to accept the old WAL log record types; they will never again be generated however, and the code can be dropped after the next forced initdb. Per report from Oleg Bartunov. We still need to think about what it really means to WAL-log CREATE TABLESPACE commands: we more or less have to put the absolute path into those, but how to replay in a different context?? Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/commands: dbcommands.c (r1.148.4.1 -> r1.148.4.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c.diff?r1=1.148.4.1&r2=1.148.4.2) pgsql/src/include/commands: dbcommands.h (r1.36 -> r1.36.4.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/dbcommands.h.diff?r1=1.36&r2=1.36.4.1) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] pgsql: WAL must log CREATE and DROP DATABASE operations *without* using
Log Message: --- WAL must log CREATE and DROP DATABASE operations *without* using any explicit paths, so that the log can be replayed in a data directory with a different absolute path than the original had. To avoid forcing initdb in the 8.0 branch, continue to accept the old WAL log record types; they will never again be generated however, and the code can be dropped after the next forced initdb. Per report from Oleg Bartunov. We still need to think about what it really means to WAL-log CREATE TABLESPACE commands: we more or less have to put the absolute path into those, but how to replay in a different context?? Modified Files: -- pgsql/src/backend/commands: dbcommands.c (r1.154 -> r1.155) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c.diff?r1=1.154&r2=1.155) pgsql/src/include/commands: dbcommands.h (r1.36 -> r1.37) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/dbcommands.h.diff?r1=1.36&r2=1.37) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgaccess - pgaccess: New Directory
Update of /cvsroot/pgaccess/pgaccess/lib/widgets/tablelist3.8 In directory pgfoundry.org:/tmp/cvs-serv2211/tablelist3.8 Log Message: Directory /cvsroot/pgaccess/pgaccess/lib/widgets/tablelist3.8 added to the repository ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] pgaccess - pgaccess: upgrading to tablelist 3.8
Log Message: --- upgrading to tablelist 3.8 Added Files: --- pgaccess/lib/widgets/tablelist3.8/images: checked_aqua.xbm (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/images/checked_aqua.xbm?rev=1.1&content-type=text/x-cvsweb-markup) checked_classic.xbm (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/images/checked_classic.xbm?rev=1.1&content-type=text/x-cvsweb-markup) checked_win32.xbm (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/images/checked_win32.xbm?rev=1.1&content-type=text/x-cvsweb-markup) checked_x11.xbm (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/images/checked_x11.xbm?rev=1.1&content-type=text/x-cvsweb-markup) unchecked_aqua.xbm (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/images/unchecked_aqua.xbm?rev=1.1&content-type=text/x-cvsweb-markup) unchecked_classic.xbm (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/images/unchecked_classic.xbm?rev=1.1&content-type=text/x-cvsweb-markup) unchecked_win32.xbm (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/images/unchecked_win32.xbm?rev=1.1&content-type=text/x-cvsweb-markup) unchecked_x11.xbm (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/images/unchecked_x11.xbm?rev=1.1&content-type=text/x-cvsweb-markup) pgaccess/lib/widgets/tablelist3.8/scripts: mwutil.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts/mwutil.tcl?rev=1.1&content-type=text/x-cvsweb-markup) repair.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts/repair.tcl?rev=1.1&content-type=text/x-cvsweb-markup) tablelistBind.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts/tablelistBind.tcl?rev=1.1&content-type=text/x-cvsweb-markup) tablelistConfig.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts/tablelistConfig.tcl?rev=1.1&content-type=text/x-cvsweb-markup) tablelistEdit.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts/tablelistEdit.tcl?rev=1.1&content-type=text/x-cvsweb-markup) tablelistMove.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts/tablelistMove.tcl?rev=1.1&content-type=text/x-cvsweb-markup) tablelistSort.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts/tablelistSort.tcl?rev=1.1&content-type=text/x-cvsweb-markup) tablelistUtil.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts/tablelistUtil.tcl?rev=1.1&content-type=text/x-cvsweb-markup) tablelistWidget.tcl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts/tablelistWidget.tcl?rev=1.1&content-type=text/x-cvsweb-markup) tclIndex (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgaccess/pgaccess/lib/widgets/tablelist3.8/scripts/tclIndex?rev=1.1&content-type=text/x-cvsweb-markup) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] pgsql: Remove: < < o Prevent conflicting SET options from being set
Log Message: --- Remove: < < o Prevent conflicting SET options from being set < < This requires a checking function to be called after the server < configuration file is read. Modified Files: -- pgsql/doc: TODO (r1.1466 -> r1.1467) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1466&r2=1.1467) ---(end of broadcast)--- TIP 8: explain analyze is your friend
[COMMITTERS] pgsql: Add: > > * Support table partitioning that allows a single
Log Message: --- Add: > > * Support table partitioning that allows a single table to be stored > in subtables that are partitioned based on the primary key or a WHERE > clause Modified Files: -- pgsql/doc: TODO (r1.1467 -> r1.1468) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1467&r2=1.1468) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] pgsql: Add for pg_dump: > o Update to use the newer COPY syntax
Log Message: --- Add for pg_dump: > o Update to use the newer COPY syntax Modified Files: -- pgsql/doc: TODO (r1.1468 -> r1.1469) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1468&r2=1.1469) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgsql: Remove: < o Update to use the newer COPY syntax
Log Message: --- Remove: < o Update to use the newer COPY syntax Modified Files: -- pgsql/doc: TODO (r1.1469 -> r1.1470) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1469&r2=1.1470) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[COMMITTERS] pgsql: Add: > o Update pg_dump and psql to use the new COPY libpq API
Log Message: --- Add: > o Update pg_dump and psql to use the new COPY libpq API Modified Files: -- pgsql/doc: TODO (r1.1470 -> r1.1471) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1470&r2=1.1471) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [COMMITTERS] pgsql: WAL must log CREATE and DROP DATABASE operations
Added to TODO: * Allow WAL replay of CREATE TABLESPACE to work when the directory structure on the recovery computer is different from the original --- Tom Lane wrote: > Log Message: > --- > WAL must log CREATE and DROP DATABASE operations *without* using any > explicit paths, so that the log can be replayed in a data directory > with a different absolute path than the original had. To avoid forcing > initdb in the 8.0 branch, continue to accept the old WAL log record > types; they will never again be generated however, and the code can be > dropped after the next forced initdb. Per report from Oleg Bartunov. > We still need to think about what it really means to WAL-log CREATE > TABLESPACE commands: we more or less have to put the absolute path > into those, but how to replay in a different context?? > > Tags: > > REL8_0_STABLE > > Modified Files: > -- > pgsql/src/backend/commands: > dbcommands.c (r1.148.4.1 -> r1.148.4.2) > > (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c.diff?r1=1.148.4.1&r2=1.148.4.2) > pgsql/src/include/commands: > dbcommands.h (r1.36 -> r1.36.4.1) > > (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/dbcommands.h.diff?r1=1.36&r2=1.36.4.1) > > ---(end of broadcast)--- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > -- Bruce Momjian| http://candle.pha.pa.us [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[COMMITTERS] pgsql: Add: > * Allow WAL replay of CREATE TABLESPACE to work when the
Log Message: --- Add: > * Allow WAL replay of CREATE TABLESPACE to work when the directory > structure on the recovery computer is different from the original Modified Files: -- pgsql/doc: TODO (r1.1471 -> r1.1472) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1471&r2=1.1472) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[COMMITTERS] pgsql: Remove duplicate: < * Allow a warm standby system to also allow
Log Message: --- Remove duplicate: < * Allow a warm standby system to also allow read-only queries Modified Files: -- pgsql/doc: TODO (r1.1472 -> r1.1473) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1472&r2=1.1473) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql: Add INTERVAL items: > * Add support for ANSI time INTERVAL
Log Message: --- Add INTERVAL items: > * Add support for ANSI time INTERVAL syntax, INTERVAL '1 2:03:04' DAY TO > SECOND > * Add support for ANSI date INTERVAL syntax, INTERVAL '1-2' YEAR TO MONTH > * Process mixed ANSI/PG INTERVAL syntax, and round value to requested > precision 184a188,189 > Interpret INTERVAL '1 year' MONTH as CAST (INTERVAL '1 year' AS INTERVAL > MONTH), and this should return '12 months' Modified Files: -- pgsql/doc: TODO (r1.1473 -> r1.1474) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1473&r2=1.1474) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[COMMITTERS] pgsql: Add: > > * Interpret INTERVAL '1:30' MINUTE TO SECOND as '1
Log Message: --- Add: > > * Interpret INTERVAL '1:30' MINUTE TO SECOND as '1 minute 30 seconds' Modified Files: -- pgsql/doc: TODO (r1.1474 -> r1.1475) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1474&r2=1.1475) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[COMMITTERS] pgsql: Assign: > o Update pg_dump and psql to use the new COPY libpq
Log Message: --- Assign: > o Update pg_dump and psql to use the new COPY libpq API (Christopher) Modified Files: -- pgsql/doc: TODO (r1.1475 -> r1.1476) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1475&r2=1.1476) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[COMMITTERS] pgsql: Add: > o Add MOVE to PL/pgSQL
Log Message: --- Add: > o Add MOVE to PL/pgSQL Modified Files: -- pgsql/doc: TODO (r1.1476 -> r1.1477) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1476&r2=1.1477) ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[COMMITTERS] pgsql: Adjust CREATE TRIGGER and ALTER TABLE ...
Log Message: --- Adjust CREATE TRIGGER and ALTER TABLE ... ADD FOREIGN KEY to acquire ExclusiveLock rather than AccessExclusiveLock. This will allow concurrent SELECT queries to proceed on the table. Per discussion with Andrew at SuperNews. Modified Files: -- pgsql/doc/src/sgml: mvcc.sgml (r2.47 -> r2.48) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/mvcc.sgml.diff?r1=2.47&r2=2.48) pgsql/src/backend/commands: tablecmds.c (r1.148 -> r1.149) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c.diff?r1=1.148&r2=1.149) trigger.c (r1.178 -> r1.179) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/trigger.c.diff?r1=1.178&r2=1.179) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
