[COMMITTERS] pgsql: Turn autovacuum on by default.

2006-08-28 Thread Peter Eisentraut
Log Message: --- Turn autovacuum on by default. (stats_row_level is also on by default.) Threshold and scale factor are cut in half for more aggressive behavior. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.75 -> r1.76) (http://developer.postgres

[COMMITTERS] npgsql - Npgsql: 2006-08-28 Francisco Figueiredo Jr.

2006-08-28 Thread User Fxjr
Log Message: --- 2006-08-28 Francisco Figueiredo Jr. <[EMAIL PROTECTED]> * NpgsqlCommand.cs: Implemented Cancel method. Modified Files: -- Npgsql/src/Npgsql: NpgsqlCommand.cs (r1.98 -> r1.99) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/

[COMMITTERS] npgsql - Npgsql: 2006-08-28 Francisco Figueiredo Jr.

2006-08-28 Thread User Fxjr
Log Message: --- 2006-08-28 Francisco Figueiredo Jr. <[EMAIL PROTECTED]> * UserManual.htm: Added Josh Cooley example about how to retrieve autogenerated sequence number. Added example about how to cancel requests in progress. Modified Files: -- Npgsql/docs:

[COMMITTERS] orafce - orafce: table is protected via rules

2006-08-28 Thread User Okbob
Log Message: --- table is protected via rules Removed Files: - orafce: protectable.c (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/protectable.c) ---(end of broadcast)--- TIP 6: explain analyze i

[COMMITTERS] pgsql: Tweak trivial_subqueryscan() to consider a SubqueryScan's

2006-08-28 Thread Tom Lane
Log Message: --- Tweak trivial_subqueryscan() to consider a SubqueryScan's targetlist trivial if it contains either Vars referencing the corresponding subplan columns, or Consts equaling the corresponding subplan columns. This lets the planner eliminate the SubqueryScan in some cases gener

[COMMITTERS] orafce - orafce: updated for 8.2 ..

2006-08-28 Thread User Okbob
Log Message: --- updated for 8.2 .. MODULE MAGIC Modified Files: -- orafce: Makefile (r1.9 -> r1.10) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/Makefile.diff?r1=1.9&r2=1.10) orafunc.sql (r1.10 -> r1.11) (http://cvs.pgfoundry

[COMMITTERS] orafce - orafce: small correctures

2006-08-28 Thread User Okbob
Log Message: --- small correctures Modified Files: -- orafce: magic.c (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/orafce/orafce/magic.c.diff?r1=1.1&r2=1.2) ---(end of broadcast)--- TIP 3: Have

[COMMITTERS] pgsql: Partial fix for ecpg's VPATH problems.

2006-08-28 Thread Tom Lane
Log Message: --- Partial fix for ecpg's VPATH problems. It compiles and successfully builds all the files needed for its regression tests, but the tests themselves fail because of diffs in the #line directives output by ecpg itself. Not sure what to do about that. Modified Files: ---

[COMMITTERS] pgfouine - pgfouine: added a TODO

2006-08-28 Thread User Gsmet
Log Message: --- added a TODO Modified Files: -- pgfouine/include/postgresql/lines: PostgreSQLQueryStartLine.class.php (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/lines/PostgreSQLQueryStartLine.class.ph

[COMMITTERS] pgfouine - pgfouine: added support for prepared statements (including

2006-08-28 Thread User Gsmet
Log Message: --- added support for prepared statements (including CVS tip bind parameters) Modified Files: -- pgfouine: version.php (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/version.php.diff?r1=1.2&r2=1.3) ChangeL

[COMMITTERS] pgsql: Fix pgstat_report_waiting() to not dump core if called before

2006-08-28 Thread Tom Lane
Log Message: --- Fix pgstat_report_waiting() to not dump core if called before pgstat_bestart() has been called; else any lock-block occurring during InitPostgres() is disastrous. I believe this explains recent wasp regression failure; at least it explains the crash I got while trying to d

[COMMITTERS] pgsql: Update: < * Allow DEFERRABLE UNIQUE constraints? > * Allow

2006-08-28 Thread Bruce Momjian
Log Message: --- Update: < * Allow DEFERRABLE UNIQUE constraints? > * Allow DEFERRABLE and end-of-statement UNIQUE constraints? > > This would allow UPDATE tab SET col = col + 1 to work if col has > a unique index. Currently, uniqueness checks are done while the > command is being

[COMMITTERS] pgsql: Move to referential integrity section: > o Allow DEFERRABLE and

2006-08-28 Thread Bruce Momjian
Log Message: --- Move to referential integrity section: > o Allow DEFERRABLE and end-of-statement UNIQUE constraints? > > This would allow UPDATE tab SET col = col + 1 to work if col has > a unique index. Currently, uniqueness checks are done while the > com

[COMMITTERS] pgsql: Add URL: >

2006-08-28 Thread Bruce Momjian
Log Message: --- Add URL: > > http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html > Modified Files: -- pgsql/doc: TODO (r1.1962 -> r1.1963) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1962&r2=1.1963

[COMMITTERS] pgsql: Now bind displays prepare as detail, and execute displays prepare

2006-08-28 Thread Bruce Momjian
Log Message: --- Now bind displays prepare as detail, and execute displays prepare and optionally bind. I re-added the "statement:" label so people will understand why the line is being printed (it is log_*statement behavior). Use single quotes for bind values, instead of double quotes, a

[COMMITTERS] pgsql: Only call log_after_parse() if necessary.

2006-08-28 Thread Bruce Momjian
Log Message: --- Only call log_after_parse() if necessary. Modified Files: -- pgsql/src/backend/tcop: postgres.c (r1.500 -> r1.501) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/postgres.c.diff?r1=1.500&r2=1.501) --

[COMMITTERS] npgsql - Npgsql: Fixed empty result check.

2006-08-28 Thread User H-saito
Log Message: --- Fixed empty result check. Modified Files: -- Npgsql/src/testsuite/MiniTerminal: Npsql.cs (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql/src/testsuite/MiniTerminal/Npsql.cs.diff?r1=1.2&r2=1.3)