[COMMITTERS] pgsql: Remove unneeded variable test, per Tom.

2005-06-09 Thread Bruce Momjian
Log Message: --- Remove unneeded variable test, per Tom. Modified Files: -- pgsql/src/interfaces/libpq: fe-connect.c (r1.308 -> r1.309) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/fe-connect.c.diff?r1=1.308&r2=1.309)

[COMMITTERS] pgsql: Quick hack to allow the outer query's tuple_fraction to be passed

2005-06-09 Thread Tom Lane
Log Message: --- Quick hack to allow the outer query's tuple_fraction to be passed down to a subquery if the outer query is simple enough that the LIMIT can be reflected directly to the subquery. This didn't use to be very interesting, because a subquery that couldn't have been flattened i

[COMMITTERS] pgsql: Add the "PGPASSFILE" environment variable to specify to the

2005-06-09 Thread Bruce Momjian
Log Message: --- Add the "PGPASSFILE" environment variable to specify to the password file. Andrew Dunstan Modified Files: -- pgsql/doc/src/sgml: libpq.sgml (r1.183 -> r1.184) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/libpq.sgml.diff?r

[COMMITTERS] pgsql: If a LIMIT is applied to a UNION ALL query, plan each UNION arm

2005-06-09 Thread Tom Lane
Log Message: --- If a LIMIT is applied to a UNION ALL query, plan each UNION arm as if the limit were directly applied to it. This does not actually add a LIMIT plan node to the generated subqueries --- that would be useless overhead --- but it does cause the planner to prefer fast- start

[COMMITTERS] pgsql: Revise searching of subplan target lists to use something more

2005-06-09 Thread Tom Lane
Log Message: --- Revise searching of subplan target lists to use something more efficient than tlist_member calls. Building a large join tlist is still O(N^2), but with a much smaller constant factor than before. Modified Files: -- pgsql/src/backend/optimizer/plan:

[COMMITTERS] pgsql: This patch shows the full path name when doing a \s in psql, if

2005-06-09 Thread Bruce Momjian
Log Message: --- This patch shows the full path name when doing a \s in psql, if you have previously issued a \cd command. Greg Sabino Mullane Modified Files: -- pgsql/src/bin/psql: command.c (r1.144 -> r1.145) (http://developer.postgresql.org/cvsweb.cgi/p

[COMMITTERS] pgsql: Mention prefix %t has no milliseconds.

2005-06-09 Thread Bruce Momjian
Log Message: --- Mention prefix %t has no milliseconds. Modified Files: -- pgsql/doc/src/sgml: runtime.sgml (r1.323 -> r1.324) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/runtime.sgml.diff?r1=1.323&r2=1.324) pgsql/src/backend/utils/mi

[COMMITTERS] pgsql: Restructure log_line_prefix options to be clearer:

2005-06-09 Thread Bruce Momjian
Log Message: --- Restructure log_line_prefix options to be clearer: #log_line_prefix = '' # %u = user name # %d = database name # %r = remote host and port # %h = remote host

[COMMITTERS] pgsql: Free buffer allocated via malloc (process is short-lived, but fix

2005-06-09 Thread Bruce Momjian
Log Message: --- Free buffer allocated via malloc (process is short-lived, but fix it anyway). Modified Files: -- pgsql/src/backend/access/transam: xlog.c (r1.198 -> r1.199) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c

[COMMITTERS] pgsql: This patch against 8.0.0beta1 source adds log_line_prefix options

2005-06-09 Thread Bruce Momjian
Log Message: --- This patch against 8.0.0beta1 source adds log_line_prefix options for millisecond timestamps (%m) and remote host (%h). The milliseconds are useful for QPS measurements. Ed L. Modified Files: -- pgsql/doc/src/sgml: runtime.sgml (r1.322 -> r1.323)

[COMMITTERS] pgsql: Fix typo in comment, per Alvaro.

2005-06-09 Thread Tom Lane
Log Message: --- Fix typo in comment, per Alvaro. Modified Files: -- pgsql/src/backend/postmaster: postmaster.c (r1.451 -> r1.452) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/postmaster.c.diff?r1=1.451&r2=1.452) ---

[COMMITTERS] pgsql: Fix assign_datestyle() so that it doesn't misleadingly complain

2005-06-09 Thread Tom Lane
Log Message: --- Fix assign_datestyle() so that it doesn't misleadingly complain about 'conflicting datestyle specifications' for input that's actually only redundant, such as SET DATESTYLE = MDY, MDY. Per recent gripe. Modified Files: -- pgsql/src/backend/commands:

[COMMITTERS] pgsql: Make SPI set SPI_processed for CREATE TABLE AS / SELECT INTO

2005-06-09 Thread Tom Lane
Log Message: --- Make SPI set SPI_processed for CREATE TABLE AS / SELECT INTO commands; this in turn causes CREATE TABLE AS in plpgsql to set ROW_COUNT. This is how it behaved before 7.4; I had unintentionally changed the behavior in a bit of sloppy micro-optimization. Modified Files:

[COMMITTERS] pgsql: Add missing #include -- mea culpa.

2005-06-09 Thread Tom Lane
Log Message: --- Add missing #include -- mea culpa. Modified Files: -- pgsql/src/backend/access/hash: hashpage.c (r1.50 -> r1.51) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/hash/hashpage.c.diff?r1=1.50&r2=1.51) ---

[COMMITTERS] pgsql: Defend against omitted paramLengths[] array in PQsendQueryParams.

2005-06-09 Thread Tom Lane
Log Message: --- Defend against omitted paramLengths[] array in PQsendQueryParams. Per Volkan Yazici. Modified Files: -- pgsql/src/interfaces/libpq: fe-exec.c (r1.167 -> r1.168) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/fe-exec.

[COMMITTERS] pgsql: Repair error in description of nonblocking usage of

2005-06-09 Thread Tom Lane
Log Message: --- Repair error in description of nonblocking usage of PQgetCopyData(). Per Volkan Yazici. Tags: REL8_0_STABLE Modified Files: -- pgsql/doc/src/sgml: libpq.sgml (r1.178.4.1 -> r1.178.4.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql

[COMMITTERS] pgsql: Repair error in description of nonblocking usage of

2005-06-09 Thread Tom Lane
Log Message: --- Repair error in description of nonblocking usage of PQgetCopyData(). Per Volkan Yazici. Tags: REL7_4_STABLE Modified Files: -- pgsql/doc/src/sgml: libpq.sgml (r1.141.2.1 -> r1.141.2.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql

[COMMITTERS] pgsql: Repair error in description of nonblocking usage of

2005-06-09 Thread Tom Lane
Log Message: --- Repair error in description of nonblocking usage of PQgetCopyData(). Per Volkan Yazici. Modified Files: -- pgsql/doc/src/sgml: libpq.sgml (r1.182 -> r1.183) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/libpq.sgml.diff?r1=1

[COMMITTERS] pgsql: Avoid bare 'struct Node;' declaration --- provokes annoying

2005-06-09 Thread Tom Lane
Log Message: --- Avoid bare 'struct Node;' declaration --- provokes annoying warnings on some compilers. Modified Files: -- pgsql/src/include: fmgr.h (r1.38 -> r1.39) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/fmgr.h.diff?r1=1.38&r2=1.39)

[COMMITTERS] pgsql: \(rs should be \\(rs, per Tom.

2005-06-09 Thread Bruce Momjian
Log Message: --- \(rs should be \\(rs, per Tom. Modified Files: -- pgsql/src/bin/psql: print.c (r1.56 -> r1.57) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/print.c.diff?r1=1.56&r2=1.57) ---(end of broadcast)--

[COMMITTERS] pgsql: Put a critical section around update of hash index metapage.

2005-06-09 Thread Tom Lane
Log Message: --- Put a critical section around update of hash index metapage. Per discussion with Qingqing Zhou. Modified Files: -- pgsql/src/backend/access/hash: hashpage.c (r1.49 -> r1.50) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/acc

[COMMITTERS] pgsql: Add example for pg_config --configure.

2005-06-09 Thread Peter Eisentraut
Log Message: --- Add example for pg_config --configure. Modified Files: -- pgsql/doc/src/sgml/ref: pg_config-ref.sgml (r1.19 -> r1.20) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/pg_config-ref.sgml.diff?r1=1.19&r2=1.20) -

[COMMITTERS] pgsql: Since I needed this feature badly, I added the -n / --schema

2005-06-09 Thread Bruce Momjian
Log Message: --- Since I needed this feature badly, I added the -n / --schema switch to pg_restore. It restores the given schemaname only. It can be used in conjunction with the -t and other switches to make the selection very fine grained. Richard van den Bergg, CISSP Modified Files: ---

[COMMITTERS] pgsql: Please find attached a patch (diff -c against cvs HEAD) to add a

2005-06-09 Thread Bruce Momjian
Log Message: --- Please find attached a patch (diff -c against cvs HEAD) to add a function that accepts a double precision argument assumed to be a Unix epoch timestamp and returns timestamp with time zone, and accompanying documentation. Usage: test=# select to_timestamp(200120400);

[COMMITTERS] pgsql: I've created a patch which adds support for troff "-ms" output to

2005-06-09 Thread Bruce Momjian
Log Message: --- I've created a patch which adds support for troff "-ms" output to psql. i.e. "\pset format troff-ms". The patch also corrects some problems with the "latex" format, notably defining an extra column in the output table, and correcting some alignment issues; it also changes