[COMMITTERS] pgsql: Remove win32 TODO.detail.

2004-11-08 Thread Bruce Momjian
Log Message: --- Remove win32 TODO.detail. Removed Files: - pgsql/doc/TODO.detail: win32 (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/win32) ---(end of broadcast)--- TIP 3: if posting/read

[COMMITTERS] pgsql: Update view info: < * Automatically create rules on views so

2004-11-08 Thread Bruce Momjian
Log Message: --- Update view info: < * Automatically create rules on views so they are updateable, per SQL99 [view] > * Automatically create rules on views so they are updateable, per SQL99 > > We can only auto-create rules for simple views. For more complex > cases users will still

[COMMITTERS] pgsql: Remove view TODO.detail.

2004-11-08 Thread Bruce Momjian
Log Message: --- Remove view TODO.detail. Removed Files: - pgsql/doc/TODO.detail: view (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/view) ---(end of broadcast)--- TIP 4: Don't 'kill -9' th

[COMMITTERS] pgsql: Remove atttypmod TODO.detail and merge into TODO list.

2004-11-08 Thread Bruce Momjian
Log Message: --- Remove atttypmod TODO.detail and merge into TODO list. Removed Files: - pgsql/doc/TODO.detail: atttypmod (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/atttypmod) ---(end of broadcast)

[COMMITTERS] pgsql: Update item description: < * CREATE TABLE AS can not determine

2004-11-08 Thread Bruce Momjian
Log Message: --- Update item description: < * CREATE TABLE AS can not determine column lengths from expressions [atttypmod] > * Allow CREATE TABLE AS to determine column lengths for complex > expressions like SELECT col1 || col2 Modified Files: -- pgsql/doc: TOD

[COMMITTERS] pgsql: Remove count TODO.detail.

2004-11-08 Thread Bruce Momjian
Log Message: --- Remove count TODO.detail. Modified Files: -- pgsql/doc: TODO (r1.1388 -> r1.1389) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1388&r2=1.1389) ---(end of broadcast)---

[COMMITTERS] pgsql: Remove count TODO.detail now that info is in TODO.

2004-11-08 Thread Bruce Momjian
Log Message: --- Remove count TODO.detail now that info is in TODO. Removed Files: - pgsql/doc/TODO.detail: count (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/count) ---(end of broadcast)-

[COMMITTERS] pgsql: Use correct function name in example

2004-11-08 Thread Peter Eisentraut
Log Message: --- Use correct function name in example Modified Files: -- pgsql/doc/src/sgml: func.sgml (r1.221 -> r1.222) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.221&r2=1.222) ---(end of br

[COMMITTERS] pgsql: Update workding on why we use is_absolute_path() as a macro.

2004-11-08 Thread Bruce Momjian
Log Message: --- Update workding on why we use is_absolute_path() as a macro. Modified Files: -- pgsql/src/include: port.h (r1.65 -> r1.66) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/port.h.diff?r1=1.65&r2=1.66) -

[COMMITTERS] pgsql: Recommend that archive_command be coded to not overwrite existing

2004-11-08 Thread Tom Lane
Log Message: --- Recommend that archive_command be coded to not overwrite existing files. Add explicit documentation of the recovery configuration settings. Other minor improvements in the PITR docs. Simon Riggs, some editorialization by Tom Lane. Modified Files: -- pgsql

[COMMITTERS] pgsql: Remove fadvise TODO.detail.

2004-11-08 Thread Bruce Momjian
Log Message: --- Remove fadvise TODO.detail. Merged into TODO. Removed Files: - pgsql/doc/TODO.detail: fadvise (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/fadvise) ---(end of broadcast)

[COMMITTERS] pgsql: Update: < posix_fadvise() [fadvise] > posix_fadvise() > >

2004-11-08 Thread Bruce Momjian
Log Message: --- Update: < posix_fadvise() [fadvise] > posix_fadvise() > > Posix_fadvise() can control both sequential/random file caching and > free-behind behavior, but it is unclear how the setting affects other > backends that also have the file open, and the feature is not

[COMMITTERS] pgsql: Use a hopefully-more-reliable method of detecting default

2004-11-08 Thread Tom Lane
Log Message: --- Use a hopefully-more-reliable method of detecting default selectivity estimates when combining the estimates for a range query. As pointed out by Miquel van Smoorenburg, the existing check for an impossible combined result would quite possibly fail to detect one default an

[COMMITTERS] pgsql: Remove inheritance, already in TODO.

2004-11-08 Thread Bruce Momjian
Log Message: --- Remove inheritance, already in TODO. Removed Files: - pgsql/doc/TODO.detail: inheritance (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/inheritance) ---(end of broadcast)--

[COMMITTERS] pgsql: Remove mmap TODO.detail, now in TODO.

2004-11-08 Thread Bruce Momjian
Log Message: --- Remove mmap TODO.detail, now in TODO. Removed Files: - pgsql/doc/TODO.detail: mmap (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.detail/mmap) ---(end of broadcast)--- TIP 6: Have

[COMMITTERS] pgsql: Update mmap details: < portability issues.

2004-11-08 Thread Bruce Momjian
Log Message: --- Update mmap details: < portability issues. Anonymous mmap is required to prevent I/O < overhead. > portability issues. Anonymous mmap (or mmap to /dev/zero) is required > to prevent I/O overhead. > > * Consider mmap()'ing files into a backend? > > Doing I/O

[COMMITTERS] pgsql: Fix typo: < Such indexes could be more compact if there are

2004-11-08 Thread Bruce Momjian
Log Message: --- Fix typo: < Such indexes could be more compact if there are few unique value. > Such indexes could be more compact if there are only a few unique values. Modified Files: -- pgsql/doc: TODO (r1.1391 -> r1.1392) (http://developer.postgre

[COMMITTERS] pgsql: This patch makes some cleanups to contrib/ to silence some sparse

2004-11-08 Thread Neil Conway
Log Message: --- This patch makes some cleanups to contrib/ to silence some sparse warnings: - remove pointless "extern" keyword from some function definitions in contrib/tsearch2 - use "NULL" not "0" as NULL pointer in contrib/tsearch, contrib/tsearch2, contrib/pgbench, and contrib/vacuu

[COMMITTERS] pgsql: Delete the `remove-old-headers' target, as it is no longer

2004-11-08 Thread Neil Conway
Log Message: --- Delete the `remove-old-headers' target, as it is no longer useful. Patch from Alvaro Herrera. Modified Files: -- pgsql/src/include: Makefile (r1.16 -> r1.17) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/Makefile.diff?r1=1.1