[COMMITTERS] pgsql: - Moved from PQsetdbLogin to PQconnectDB.

2008-03-27 Thread Michael Meskes
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/

[COMMITTERS] pgsql: Sorry, copied wrong files.

2008-03-27 Thread Michael Meskes
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)

[COMMITTERS] pgsql: Remove ipcclean utility command --- didn't work on all Unixes and

2008-03-27 Thread Bruce Momjian
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/cvsw

[COMMITTERS] pgsql: When we have successfully optimized a MIN or MAX aggregate into

2008-03-27 Thread Tom Lane
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 sa

[COMMITTERS] pgsql: When we have successfully optimized a MIN or MAX aggregate into

2008-03-27 Thread Tom Lane
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 sa

[COMMITTERS] pgsql: Add URL for: * Consider allowing control of upper/lower case

2008-03-27 Thread Bruce Momjian
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.p

[COMMITTERS] pgsql: Add to TODO: > > * Consider being smarter about memory and

2008-03-27 Thread Bruce Momjian
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: --

[COMMITTERS] pgsql: Support statement-level ON TRUNCATE triggers.

2008-03-27 Thread Tom Lane
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 (r

[COMMITTERS] pgsql: Department of second thoughts: the rule that ORDER BY and

2008-03-27 Thread Tom Lane
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 ve

[COMMITTERS] pgsql: Add: > * Allow one transaction to see tuples using the snapshot

2008-03-27 Thread Bruce Momjian
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:

[COMMITTERS] pgsql: Add to TODO: > > o Add CASE capability to language (already in

2008-03-27 Thread Bruce Momjian
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.postgres