[COMMITTERS] pgsql: - Moved from PQsetdbLogin to PQconnectDB.
Log Message: --- - Moved from PQsetdbLogin to PQconnectDB. - Correctly parse connect options. - Changed regression tests accordingly. Modified Files: -- pgsql/src/interfaces/ecpg: ChangeLog (r1.378 -> r1.379) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/ChangeLog?r1=1.378&r2=1.379) pgsql/src/interfaces/ecpg/ecpglib: connect.c (r1.49 -> r1.50) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/ecpglib/connect.c?r1=1.49&r2=1.50) pgsql/src/interfaces/ecpg/preproc: preproc.y (r1.362 -> r1.363) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/preproc/preproc.y?r1=1.362&r2=1.363) pgsql/src/interfaces/ecpg/test/connect: test1.pgc.in (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/connect/test1.pgc.in?r1=1.5&r2=1.6) pgsql/src/interfaces/ecpg/test/expected: compat_informix-rnull.stderr (r1.4 -> r1.5) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/compat_informix-rnull.stderr?r1=1.4&r2=1.5) compat_informix-test_informix.stderr (r1.8 -> r1.9) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/compat_informix-test_informix.stderr?r1=1.8&r2=1.9) compat_informix-test_informix2.stderr (r1.8 -> r1.9) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/compat_informix-test_informix2.stderr?r1=1.8&r2=1.9) connect-test1.c.in (r1.6 -> r1.7) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/connect-test1.c.in?r1=1.6&r2=1.7) connect-test1.stderr (r1.9 -> r1.10) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/connect-test1.stderr?r1=1.9&r2=1.10) connect-test2.stderr (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/connect-test2.stderr?r1=1.5&r2=1.6) connect-test3.stderr (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/connect-test3.stderr?r1=1.5&r2=1.6) connect-test4.stderr (r1.1 -> r1.2) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/connect-test4.stderr?r1=1.1&r2=1.2) connect-test5.stderr (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/connect-test5.stderr?r1=1.5&r2=1.6) pgtypeslib-dt_test.stderr (r1.8 -> r1.9) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/pgtypeslib-dt_test.stderr?r1=1.8&r2=1.9) pgtypeslib-num_test.stderr (r1.7 -> r1.8) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/pgtypeslib-num_test.stderr?r1=1.7&r2=1.8) preproc-array_of_struct.stderr (r1.3 -> r1.4) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/preproc-array_of_struct.stderr?r1=1.3&r2=1.4) preproc-autoprep.stderr (r1.3 -> r1.4) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/preproc-autoprep.stderr?r1=1.3&r2=1.4) preproc-comment.stderr (r1.1 -> r1.2) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/preproc-comment.stderr?r1=1.1&r2=1.2) preproc-define.stderr (r1.4 -> r1.5) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/preproc-define.stderr?r1=1.4&r2=1.5) preproc-type.stderr (r1.3 -> r1.4) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/preproc-type.stderr?r1=1.3&r2=1.4) preproc-variable.stderr (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/preproc-variable.stderr?r1=1.5&r2=1.6) preproc-whenever.stderr (r1.3 -> r1.4) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/preproc-whenever.stderr?r1=1.3&r2=1.4) sql-array.stderr (r1.3 -> r1.4) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/sql-array.stderr?r1=1.3&r2=1.4) sql-binary.stderr (r1.4 -> r1.5) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/sql-binary.stderr?r1=1.4&r2=1.5) sql-code100.stderr (r1.4 -> r1.5) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/sql-code100.stderr?r1=1.4&r2=1.5) sql-copystdout.stderr (r1.4 -> r1.5) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/sql-copystdout.stderr?r1=1.4&r2=1.5) sql-define.stderr (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/sql-define
[COMMITTERS] pgsql: Sorry, copied wrong files.
Log Message: --- Sorry, copied wrong files. Modified Files: -- pgsql/src/interfaces/ecpg/test/expected: thread-prep.stdout (r1.2 -> r1.3) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/thread-prep.stdout?r1=1.2&r2=1.3) thread-thread.stdout (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/thread-thread.stdout?r1=1.5&r2=1.6) thread-thread_implicit.stdout (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/expected/thread-thread_implicit.stdout?r1=1.5&r2=1.6) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Remove ipcclean utility command --- didn't work on all Unixes and
Log Message: --- Remove ipcclean utility command --- didn't work on all Unixes and on Windows. Users should use their operating system tools instead. Modified Files: -- pgsql/doc/src/sgml: reference.sgml (r1.65 -> r1.66) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/reference.sgml?r1=1.65&r2=1.66) pgsql/doc/src/sgml/ref: allfiles.sgml (r1.72 -> r1.73) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/allfiles.sgml?r1=1.72&r2=1.73) pgsql/src/backend/utils/init: miscinit.c (r1.166 -> r1.167) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/init/miscinit.c?r1=1.166&r2=1.167) pgsql/src/bin: Makefile (r1.52 -> r1.53) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/Makefile?r1=1.52&r2=1.53) Removed Files: - pgsql/doc/src/sgml/ref: ipcclean.sgml (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/ipcclean.sgml) pgsql/src/bin/ipcclean: Makefile (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/ipcclean/Makefile) ipcclean.sh (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/ipcclean/ipcclean.sh) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: When we have successfully optimized a MIN or MAX aggregate into
Log Message: --- When we have successfully optimized a MIN or MAX aggregate into an indexscan, the query result must be exactly one row (since we don't do this when there's any GROUP BY). Therefore any ORDER BY or DISTINCT attached to the query is useless and can be dropped. Aside from saving useless cycles, this protects us against problems with matching the hacked-up tlist entries to sort clauses, as seen in a bug report from Taiki Yamaguchi. We might need to work harder if we ever try to optimize grouped queries with this approach, but this solution will do for now. Modified Files: -- pgsql/src/backend/optimizer/plan: planner.c (r1.227 -> r1.228) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c?r1=1.227&r2=1.228) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: When we have successfully optimized a MIN or MAX aggregate into
Log Message: --- When we have successfully optimized a MIN or MAX aggregate into an indexscan, the query result must be exactly one row (since we don't do this when there's any GROUP BY). Therefore any ORDER BY or DISTINCT attached to the query is useless and can be dropped. Aside from saving useless cycles, this protects us against problems with matching the hacked-up tlist entries to sort clauses, as seen in a bug report from Taiki Yamaguchi. We might need to work harder if we ever try to optimize grouped queries with this approach, but this solution will do for now. Tags: REL8_3_STABLE Modified Files: -- pgsql/src/backend/optimizer/plan: planner.c (r1.226 -> r1.226.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c?r1=1.226&r2=1.226.2.1) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Add URL for: * Consider allowing control of upper/lower case
Log Message: --- Add URL for: * Consider allowing control of upper/lower case folding of unquoted identifiers > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00849.php Modified Files: -- pgsql/doc: TODO (r1.2400 -> r1.2401) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2400&r2=1.2401) pgsql/doc/src/FAQ: TODO.html (r1.906 -> r1.907) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html?r1=1.906&r2=1.907) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Add to TODO: > > * Consider being smarter about memory and
Log Message: --- Add to TODO: > > * Consider being smarter about memory and external files used during > sorts > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg01101.php > http://archives.postgresql.org/pgsql-hackers/2007-12/msg00045.php Modified Files: -- pgsql/doc: TODO (r1.2401 -> r1.2402) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2401&r2=1.2402) pgsql/doc/src/FAQ: TODO.html (r1.907 -> r1.908) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html?r1=1.907&r2=1.908) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Support statement-level ON TRUNCATE triggers.
Log Message: --- Support statement-level ON TRUNCATE triggers. Simon Riggs Modified Files: -- pgsql/doc/src/sgml: plperl.sgml (r2.67 -> r2.68) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plperl.sgml?r1=2.67&r2=2.68) plpgsql.sgml (r1.124 -> r1.125) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plpgsql.sgml?r1=1.124&r2=1.125) plpython.sgml (r1.38 -> r1.39) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plpython.sgml?r1=1.38&r2=1.39) pltcl.sgml (r2.47 -> r2.48) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/pltcl.sgml?r1=2.47&r2=2.48) trigger.sgml (r1.51 -> r1.52) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/trigger.sgml?r1=1.51&r2=1.52) pgsql/doc/src/sgml/ref: create_trigger.sgml (r1.47 -> r1.48) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_trigger.sgml?r1=1.47&r2=1.48) truncate.sgml (r1.24 -> r1.25) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/truncate.sgml?r1=1.24&r2=1.25) pgsql/src/backend/commands: tablecmds.c (r1.248 -> r1.249) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.248&r2=1.249) trigger.c (r1.230 -> r1.231) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/trigger.c?r1=1.230&r2=1.231) pgsql/src/backend/executor: execMain.c (r1.304 -> r1.305) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execMain.c?r1=1.304&r2=1.305) pgsql/src/backend/parser: gram.y (r2.610 -> r2.611) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.610&r2=2.611) pgsql/src/backend/utils/adt: ruleutils.c (r1.271 -> r1.272) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/ruleutils.c?r1=1.271&r2=1.272) pgsql/src/bin/pg_dump: pg_dump.c (r1.485 -> r1.486) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c?r1=1.485&r2=1.486) pgsql/src/include/catalog: pg_trigger.h (r1.31 -> r1.32) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_trigger.h?r1=1.31&r2=1.32) pgsql/src/include/commands: trigger.h (r1.66 -> r1.67) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/trigger.h?r1=1.66&r2=1.67) pgsql/src/include/executor: executor.h (r1.146 -> r1.147) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/executor.h?r1=1.146&r2=1.147) pgsql/src/include/utils: rel.h (r1.104 -> r1.105) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/rel.h?r1=1.104&r2=1.105) pgsql/src/pl/plperl: plperl.c (r1.138 -> r1.139) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plperl/plperl.c?r1=1.138&r2=1.139) pgsql/src/pl/plpgsql/src: pl_exec.c (r1.206 -> r1.207) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/pl_exec.c?r1=1.206&r2=1.207) pgsql/src/pl/plpython: plpython.c (r1.107 -> r1.108) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpython/plpython.c?r1=1.107&r2=1.108) pgsql/src/pl/tcl: pltcl.c (r1.118 -> r1.119) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/tcl/pltcl.c?r1=1.118&r2=1.119) pgsql/src/test/regress/expected: truncate.out (r1.12 -> r1.13) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/truncate.out?r1=1.12&r2=1.13) pgsql/src/test/regress/sql: truncate.sql (r1.5 -> r1.6) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/truncate.sql?r1=1.5&r2=1.6) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Department of second thoughts: the rule that ORDER BY and
Log Message: --- Department of second thoughts: the rule that ORDER BY and DISTINCT are useless for an ungrouped-aggregate query holds regardless of whether optimize_minmax_aggregates succeeds. So we might as well apply the optimization in any case. I'll leave 8.3 as it was, since this version is a tad more invasive than my earlier patch. Modified Files: -- pgsql/src/backend/optimizer/plan: planner.c (r1.228 -> r1.229) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planner.c?r1=1.228&r2=1.229) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Add: > * Allow one transaction to see tuples using the snapshot
Log Message: --- Add: > * Allow one transaction to see tuples using the snapshot of another > transaction > > This would assist multiple backends in working together. > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00400.php Modified Files: -- pgsql/doc: TODO (r1.2402 -> r1.2403) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2402&r2=1.2403) pgsql/doc/src/FAQ: TODO.html (r1.908 -> r1.909) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html?r1=1.908&r2=1.909) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
[COMMITTERS] pgsql: Add to TODO: > > o Add CASE capability to language (already in
Log Message: --- Add to TODO: > > o Add CASE capability to language (already in SQL) > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00696.php > > Modified Files: -- pgsql/doc: TODO (r1.2403 -> r1.2404) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2403&r2=1.2404) pgsql/doc/src/FAQ: TODO.html (r1.909 -> r1.910) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html?r1=1.909&r2=1.910) -- Sent via pgsql-committers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers
