[COMMITTERS] pgsql: Improve planner's estimation of the size of an append relation:

2008-06-26 Thread Tom Lane
Log Message: --- Improve planner's estimation of the size of an append relation: rather than taking the maximum of any child rel's width, we should weight the widths proportionally to the number of rows expected from each child. In hindsight this is obviously correct because row width is r

[COMMITTERS] pgsql: Mention actual function names in documentation of how to pass

2008-06-26 Thread Bruce Momjian
Log Message: --- Mention actual function names in documentation of how to pass binary values to libpq. Modified Files: -- pgsql/doc/src/sgml: libpq.sgml (r1.259 -> r1.260) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/libpq.sgml?r1=1.259&r2=1

Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF

2008-06-26 Thread Bruce Momjian
Magnus Hagander wrote: > > Sure, see pg_timezone_abbrevs(), pg_timezone_names(). > > > > (This only started to work recently, which is why we have so many > > record-returning functions that don't do it that way. It might be > > an idea to fix them all sooner or later.) > > Wow, that was easy. N

[COMMITTERS] pgsql: Add to TODO: > > * Fix system views like pg_stat_all_tables to

2008-06-26 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Fix system views like pg_stat_all_tables to use set-returning > functions, rather than views of per-column functions Modified Files: -- pgsql/doc: TODO (r1.2476 -> r1.2477) (http://anoncvs.postgresql.org/cvsweb.cgi/pg

[COMMITTERS] pgsql: Fix 'pg_ctl reload' to properly preserve postmaster commend-line

2008-06-26 Thread Bruce Momjian
Log Message: --- Fix 'pg_ctl reload' to properly preserve postmaster commend-line arguments on restart. Patch to releases 8.0 - 8.3.X. Tags: REL8_3_STABLE Modified Files: -- pgsql/src/backend/postmaster: postmaster.c (r1.551 -> r1.551.2.1) (http://an

[COMMITTERS] pgsql: Fix 'pg_ctl reload' to properly preserve postmaster commend-line

2008-06-26 Thread Bruce Momjian
Log Message: --- Fix 'pg_ctl reload' to properly preserve postmaster commend-line arguments on restart. Patch to releases 8.0 - 8.3.X. Tags: REL8_2_STABLE Modified Files: -- pgsql/src/backend/postmaster: postmaster.c (r1.505.2.5 -> r1.505.2.6) (http:

[COMMITTERS] pgsql: Fix 'pg_ctl reload' to properly preserve postmaster commend-line

2008-06-26 Thread Bruce Momjian
Log Message: --- Fix 'pg_ctl reload' to properly preserve postmaster commend-line arguments on restart. Patch to releases 8.0 - 8.3.X. Tags: REL8_1_STABLE Modified Files: -- pgsql/src/backend/postmaster: postmaster.c (r1.475.2.9 -> r1.475.2.10) (http

[COMMITTERS] pgsql: Clarify plpgsql documentation by not treating IF THEN ELSE IF ...

2008-06-26 Thread Tom Lane
Log Message: --- Clarify plpgsql documentation by not treating IF THEN ELSE IF ... as a truly distinct version of IF. Per suggestion from Marko Kreen. Modified Files: -- pgsql/doc/src/sgml: plpgsql.sgml (r1.130 -> r1.131) (http://anoncvs.postgresql.org/cvs

[COMMITTERS] pgsql: Fix 'pg_ctl reload' to properly preserve postmaster commend-line

2008-06-26 Thread Bruce Momjian
Log Message: --- Fix 'pg_ctl reload' to properly preserve postmaster commend-line arguments on restart. Patch to releases 8.0 - 8.3.X. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/postmaster: postmaster.c (r1.443.4.10 -> r1.443.4.11) (htt

[COMMITTERS] pgsql: Modify the recently-added probe for -Wl,--as-needed some more,

2008-06-26 Thread Tom Lane
Log Message: --- Modify the recently-added probe for -Wl,--as-needed some more, because RHEL-4 vintage Linux is even more broken than we realized: a link to libreadline will succeed, and fail only at runtime. It seems that an AC_TRY_RUN test is the only reliable way to check whether this i

[COMMITTERS] pgsql: Use SGML table to show backslash string escapes, rather than have

2008-06-26 Thread Bruce Momjian
Log Message: --- Use SGML table to show backslash string escapes, rather than have them appear in a paragraph. Andy Anderson Modified Files: -- pgsql/doc/src/sgml: syntax.sgml (r1.122 -> r1.123) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/

[COMMITTERS] pgsql: Add MERGE TODO URL: >

2008-06-26 Thread Bruce Momjian
Log Message: --- Add MERGE TODO URL: > http://archives.postgresql.org/pgsql-hackers/2008-04/msg01890.php Modified Files: -- pgsql/doc: TODO (r1.2475 -> r1.2476) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2475&r2=1.2476) pgsql/doc/s

[COMMITTERS] pgsql: Fix pg_ctl bug where detection of binary location from

2008-06-26 Thread Bruce Momjian
Log Message: --- Fix pg_ctl bug where detection of binary location from postmaster.opts wasn't working. Modified Files: -- pgsql/src/bin/pg_ctl: pg_ctl.c (r1.102 -> r1.103) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_ctl/pg_ctl.c?r1=1.102&r2=

[COMMITTERS] pgsql: Fix bug "select lower('asd') = 'asd'" returns false with

2008-06-26 Thread Teodor Sigaev
Log Message: --- Fix bug "select lower('asd') = 'asd'" returns false with multibyte encoding and non-C locale. Fix is just to use correct source's length for char2wchar call. Modified Files: -- pgsql/src/backend/utils/adt: formatting.c (r1.143 -> r1.144) (h

[COMMITTERS] pgbouncer - pgbouncer: require libevent >= 1.3b

2008-06-26 Thread User Mkz
Log Message: --- require libevent >= 1.3b Modified Files: -- pgbouncer: NEWS (r1.20 -> r1.21) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/NEWS.diff?r1=1.20&r2=1.21) README (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bi

[COMMITTERS] pgbouncer - pgbouncer: make failed tests more visible

2008-06-26 Thread User Mkz
Log Message: --- make failed tests more visible Modified Files: -- pgbouncer/test: test.sh (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgbouncer/pgbouncer/test/test.sh.diff?r1=1.4&r2=1.5) -- Sent via pgsql-committers mailing list (pgsql-co

[COMMITTERS] npgsql - Npgsql2: Added support to not add casts to null values.

2008-06-26 Thread User Fxjr
Log Message: --- Added support to not add casts to null values. Thanks Waldemar Bergstreiser for heads up. Modified Files: -- Npgsql2/src/Npgsql: NpgsqlParameter.cs (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/Npg

[COMMITTERS] plproxy - plproxy: Support dynamic record as return type.

2008-06-26 Thread User Mkz
Log Message: --- Support dynamic record as return type. Now PL/Proxy allows function defined as RETURNS RECORD without OUT parameters. Such functions need actual result column types specified with AS clause: SELECT * FROM func() AS (col1 type1, col2 type2); PL/Proxy needs to detect th

[COMMITTERS] pgsql: Synced parser

2008-06-26 Thread Michael Meskes
Log Message: --- Synced parser Modified Files: -- pgsql/src/interfaces/ecpg: ChangeLog (r1.383 -> r1.384) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/ChangeLog?r1=1.383&r2=1.384) pgsql/src/interfaces/ecpg/preproc: preproc