[COMMITTERS] pgsql: Add: > * Allow FSM page return free space based on table

2006-03-03 Thread Bruce Momjian
Log Message: --- Add: > * Allow FSM page return free space based on table clustering, to assist > in maintaining clustering? Modified Files: -- pgsql/doc: TODO (r1.1779 -> r1.1780) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1779

[COMMITTERS] pgsql: > gettimeofday.c:35: warning: integer constant is too large for

2006-03-03 Thread Bruce Momjian
Log Message: --- > gettimeofday.c:35: warning: integer constant is too large for "long" > type Wouldn't it be better to use the UINT64CONST macro? I realize this file is Windows-only, but we do worry about more than one compiler on that platform. Kris Jurka Modified Files: -

[COMMITTERS] pgsql: > It doesn't say that only the listed commands acquire ACCESS

2006-03-03 Thread Bruce Momjian
Log Message: --- > It doesn't say that only the listed commands acquire ACCESS EXCLUSIVE, > just that certain commands do. TRUNCATE isn't shown. Patch against HEAD to add TRUNCATE to the list of commands that aquire ACCESS EXCLUSIVE. Jim C. Nasby, Sr. Modified Files: --

[COMMITTERS] pgsql: Use DEVTTY as 'con' on Win32 as a replacement for /dev/tty.

2006-03-03 Thread Bruce Momjian
Log Message: --- Use DEVTTY as 'con' on Win32 as a replacement for /dev/tty. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/bin/psql: command.c (r1.139.4.2 -> r1.139.4.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/command.c.diff?

[COMMITTERS] pgsql: Use DEVTTY as 'con' on Win32 as a replacement for /dev/tty.

2006-03-03 Thread Bruce Momjian
Log Message: --- Use DEVTTY as 'con' on Win32 as a replacement for /dev/tty. Tags: REL8_1_STABLE Modified Files: -- pgsql/src/bin/psql: command.c (r1.154.2.2 -> r1.154.2.3) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/command.c.diff?

[COMMITTERS] pgsql: Use DEVTTY as 'con' on Win32 as a replacement for /dev/tty.

2006-03-03 Thread Bruce Momjian
Log Message: --- Use DEVTTY as 'con' on Win32 as a replacement for /dev/tty. Modified Files: -- pgsql/src/bin/psql: command.c (r1.162 -> r1.163) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/command.c.diff?r1=1.162&r2=1.163) pgsql/src/i

[COMMITTERS] pgsql: That was a typo in my comment before the code (the nutshell

2006-03-03 Thread Bruce Momjian
Log Message: --- That was a typo in my comment before the code (the nutshell descriptions after the code are correct). Only shmmax needs to be multiples of the page size (at least, that's how I interpret the Darwin code). Chris Campbell Modified Files: -- pgsql/doc/src/sgm

Re: [COMMITTERS] pgsql: This patch fixes this warning.

2006-03-03 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: > Log Message: > --- > This patch fixes this warning. > gettimeofday.c:35: warning: integer constant is too large for "long" > type Wouldn't it be better to use the UINT64CONST macro? I realize this file is Windows-only, but we do worry about mor

[COMMITTERS] pgsql: This patch fixes this warning.

2006-03-03 Thread Bruce Momjian
Log Message: --- This patch fixes this warning. gettimeofday.c:35: warning: integer constant is too large for "long" type Kris Jurka Modified Files: -- pgsql/src/port: gettimeofday.c (r1.7 -> r1.8) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/por

[COMMITTERS] pgsql: Avoid trying to open /dev/tty on Win32.

2006-03-03 Thread Bruce Momjian
Log Message: --- Avoid trying to open /dev/tty on Win32. Some Win32 systems have /dev/tty, but it isn't a device file and doesn't work as expected. This fixes a known bug where psql does not prompt for a password on some Win32 systems. Backpatch to 8.0.X too. Robert Kinberg Tags:

[COMMITTERS] pgsql: Avoid trying to open /dev/tty on Win32.

2006-03-03 Thread Bruce Momjian
Log Message: --- Avoid trying to open /dev/tty on Win32. Some Win32 systems have /dev/tty, but it isn't a device file and doesn't work as expected. This fixes a known bug where psql does not prompt for a password on some Win32 systems. Backpatch to 8.1.X. Robert Kinberg Tags: REL8

[COMMITTERS] pgsql: Avoid trying to open /dev/tty on Win32.

2006-03-03 Thread Bruce Momjian
Log Message: --- Avoid trying to open /dev/tty on Win32. Some Win32 systems have /dev/tty, but it isn't a device file and doesn't work as expected. This fixes a known bug where psql does not prompt for a password on some Win32 systems. Backpatch to 8.1.X. Robert Kinberg Modified Files:

[COMMITTERS] pgsql: Improve pg_dump and psql to use libpq's newer COPY support

2006-03-03 Thread Tom Lane
Log Message: --- Improve pg_dump and psql to use libpq's newer COPY support routines, instead of the old deprecated ones. Volkan Yazici, with some editorializing by moi. Modified Files: -- pgsql/src/bin/pg_dump: pg_backup_db.c (r1.69 -> r1.70) (http://devel

[COMMITTERS] pgsql: Fixes for Win32-client only compiles.

2006-03-03 Thread Bruce Momjian
Log Message: --- Fixes for Win32-client only compiles. Hiroshi Saito Modified Files: -- pgsql/src: win32.mak (r1.11 -> r1.12) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/win32.mak.diff?r1=1.11&r2=1.12) pgsql/src/bin/psql: win32.mak (r

[COMMITTERS] bizgres - bizgres: Improve sorting speed by pre-extracting the first

2006-03-03 Thread User Aparashar
Log Message: --- Improve sorting speed by pre-extracting the first sort-key column of each tuple, as per my proposal of several days ago. Also, clean up sort memory management by keeping all working data in a separate memory context, and refine the handling of low-memory conditions. Simon

[COMMITTERS] bizgres - bizgres: 1.

2006-03-03 Thread User Aparashar
Log Message: --- 1. Improve tuplesort.c to support variable merge order. The original coding with fixed merge order (fixed number of "tapes") was based on obsolete assumptions, namely that tape drives are expensive. Since our "tapes" are really just a couple of buffers, we can have a lot

[COMMITTERS] bizgres - bizgres: Improve tuplesort.c to support variable merge order.

2006-03-03 Thread User Aparashar
Log Message: --- Improve tuplesort.c to support variable merge order. The original coding with fixed merge order (fixed number of "tapes") was based on obsolete assumptions, namely that tape drives are expensive. Since our "tapes" are really just a couple of buffers, we can have a lot of

[COMMITTERS] bizgres - bizgres: Modify logtape.c so that the initial

2006-03-03 Thread User Aparashar
Log Message: --- Modify logtape.c so that the initial LogicalTapeSetCreate call only allocates the control data. The per-tape buffers are allocated only on first use. This saves memory in situations where tuplesort.c overestimates the number of tapes needed (ie, there are fewer runs than

[COMMITTERS] pgsql: Rename Online Backup to Continuous Archiving.

2006-03-03 Thread Bruce Momjian
Log Message: --- Rename Online Backup to Continuous Archiving. Modified Files: -- pgsql/doc/src/sgml: backup.sgml (r2.77 -> r2.78) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/backup.sgml.diff?r1=2.77&r2=2.78) config.sgml (r1.47 ->

[COMMITTERS] pgsql: Update ipcclean to use try 'id' first for root check.

2006-03-03 Thread Bruce Momjian
Log Message: --- Update ipcclean to use try 'id' first for root check. Tags: REL8_1_STABLE Modified Files: -- pgsql/src/bin/ipcclean: ipcclean.sh (r1.15.6.1 -> r1.15.6.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/ipcclean/ipcclean.sh.d

[COMMITTERS] pgsql: Update ipcclean to use try 'id' first for root check.

2006-03-03 Thread Bruce Momjian
Log Message: --- Update ipcclean to use try 'id' first for root check. Modified Files: -- pgsql/src/bin/ipcclean: ipcclean.sh (r1.17 -> r1.18) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/ipcclean/ipcclean.sh.diff?r1=1.17&r2=1.18)

[COMMITTERS] bizgres - bizgres: Improve tuplesort.c to support variable merge order.

2006-03-03 Thread User Aparashar
Log Message: --- Improve tuplesort.c to support variable merge order. The original coding with fixed merge order (fixed number of "tapes") was based on obsolete assumptions, namely that tape drives are expensive. Since our "tapes" are really just a couple of buffers, we can have a lot of

[COMMITTERS] pgsql: Add workaround so MSVC doesn't try to load strings.h, which it

2006-03-03 Thread Bruce Momjian
Log Message: --- Add workaround so MSVC doesn't try to load strings.h, which it doesn't have. This happens when MSVC uses pg_config.h generated by MinGW. Per report from Charles F. I. Savage Modified Files: -- pgsql/src/include: c.h (r1.196 -> r1.197) (ht

[COMMITTERS] pgsql: Teach PQcmdTuples() that a COPY command tag might contain a row

2006-03-03 Thread Tom Lane
Log Message: --- Teach PQcmdTuples() that a COPY command tag might contain a row count, and tighten up its sanity checking of the tag as a safety measure. Volkan Yazici. Modified Files: -- pgsql/doc/src/sgml: libpq.sgml (r1.204 -> r1.205) (http://developer.

[COMMITTERS] pgsql: Clarify macro layout for win32 IMPORT.

2006-03-03 Thread Bruce Momjian
Log Message: --- Clarify macro layout for win32 IMPORT. Modified Files: -- pgsql/src/include/port: win32.h (r1.50 -> r1.51) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/port/win32.h.diff?r1=1.50&r2=1.51) ---(end of

[COMMITTERS] pgsql: Done: > * -Allow TRUNCATE ...

2006-03-03 Thread Bruce Momjian
Log Message: --- Done: > * -Allow TRUNCATE ... CASCADE/RESTRICT Modified Files: -- pgsql/doc: TODO (r1.1778 -> r1.1779) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1778&r2=1.1779) pgsql/doc/src/FAQ: TODO.html (r1.282 ->

[COMMITTERS] pgsql: Done: < o %Have COPY return the number of rows loaded/unloaded?

2006-03-03 Thread Bruce Momjian
Log Message: --- Done: < o %Have COPY return the number of rows loaded/unloaded? > o -Have COPY return the number of rows loaded/unloaded? Modified Files: -- pgsql/doc: TODO (r1.1777 -> r1.1778) (http://developer.postgresql.org/cvsweb.cgi/pgsql

[COMMITTERS] pgsql: Make the COPY command return a command tag that includes the

2006-03-03 Thread Tom Lane
Log Message: --- Make the COPY command return a command tag that includes the number of rows copied. Backend side of Volkan Yazici's recent patch, with corrections and documentation. Modified Files: -- pgsql/doc/src/sgml: protocol.sgml (r1.63 -> r1.64) (ht

[COMMITTERS] pgsql: Dept.

2006-03-03 Thread Tom Lane
Log Message: --- Dept. of second thoughts: rejigger the TRUNCATE ... CASCADE patch so that relations are still checked for permissions etc as soon as they are opened. The original form of the patch could hold exclusive lock for a long time on relations that the user doesn't even have permi

[COMMITTERS] pgsql: In ipcclean, check LOGNAME only if USER is not set.

2006-03-03 Thread Bruce Momjian
Log Message: --- In ipcclean, check LOGNAME only if USER is not set. Fixes problem with 'su' on some platforms. Tags: REL8_1_STABLE Modified Files: -- pgsql/src/bin/ipcclean: ipcclean.sh (r1.15 -> r1.15.6.1) (http://developer.postgresql.org/cvsweb.cg

[COMMITTERS] pgsql: In ipcclean, check LOGNAME only if USER is not set.

2006-03-03 Thread Bruce Momjian
Log Message: --- In ipcclean, check LOGNAME only if USER is not set. Fixes problem with 'su' on some platforms. Modified Files: -- pgsql/src/bin/ipcclean: ipcclean.sh (r1.16 -> r1.17) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/ipcclean/ipccl