[COMMITTERS] pgsql: Add: < > * Allow enable_constraint_exclusion to work for UNIONs

2005-07-29 Thread Bruce Momjian
Log Message: --- Add: < > * Allow enable_constraint_exclusion to work for UNIONs like it does for > inheritance Modified Files: -- pgsql/doc: TODO (r1.1608 -> r1.1609) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1608&r2=1.1609)

[COMMITTERS] pgsql: Add constraint exclusion items: < > * Allow EXPLAIN to identify

2005-07-29 Thread Bruce Momjian
Log Message: --- Add constraint exclusion items: < > * Allow EXPLAIN to identify tables that were skipped because of > enable_constraint_exclusion > * Allow EXPLAIN output to be more easily processed by scripts 760a763 > * Allow enable_constraint_exclusion to work for UPDATE and DELETE

[COMMITTERS] pgsql: Add: > * Prevent inherited tables from expanding temporary

2005-07-29 Thread Bruce Momjian
Log Message: --- Add: > * Prevent inherited tables from expanding temporary subtables of other > sessions Modified Files: -- pgsql/doc: TODO (r1.1607 -> r1.1608) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1607&r2=1.1608) pgs

[COMMITTERS] pgsql: Update AIX FAQ.

2005-07-29 Thread Bruce Momjian
Log Message: --- Update AIX FAQ. Chris Browne Tags: REL8_0_STABLE Modified Files: -- pgsql/doc: FAQ_AIX (r1.11 -> r1.11.8.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_AIX.diff?r1=1.11&r2=1.11.8.1) ---(end of b

[COMMITTERS] pgsql: Update AIX FAQ.

2005-07-29 Thread Bruce Momjian
Log Message: --- Update AIX FAQ. Chris Browne Modified Files: -- pgsql/doc: FAQ_AIX (r1.11 -> r1.12) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ_AIX.diff?r1=1.11&r2=1.12) ---(end of broadcast)-

[COMMITTERS] pgsql: Add: > * Allow SELECT ...

2005-07-29 Thread Bruce Momjian
Log Message: --- Add: > * Allow SELECT ... FOR UPDATE on inherited tables Modified Files: -- pgsql/doc: TODO (r1.1605 -> r1.1606) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1605&r2=1.1606) pgsql/doc/src/FAQ: TODO.html

[COMMITTERS] pgsql: Clarify: < * Add TRUNCATE permission > * Add a separate TRUNCATE

2005-07-29 Thread Bruce Momjian
Log Message: --- Clarify: < * Add TRUNCATE permission > * Add a separate TRUNCATE permission Modified Files: -- pgsql/doc: TODO (r1.1604 -> r1.1605) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1604&r2=1.1605) pgsql/doc/src/FAQ:

[COMMITTERS] pgsql: Add: > * Add system view to show free space map contents 884c885

2005-07-29 Thread Bruce Momjian
Log Message: --- Add: > * Add system view to show free space map contents 884c885 < o Move into the backend code > o -Move into the backend code Modified Files: -- pgsql/doc: TODO (r1.1606 -> r1.1607) (http://developer.postgresql.org/cvsweb.cgi

[COMMITTERS] pgsql: Add: > * Add TRUNCATE permission > > Currently only the owner

2005-07-29 Thread Bruce Momjian
Log Message: --- Add: > * Add TRUNCATE permission > > Currently only the owner can TRUNCATE a table because triggers are not > called, and the table is locked in exclusive mode. > Modified Files: -- pgsql/doc: TODO (r1.1603 -> r1.1604) (http://develop

[COMMITTERS] pgsql: SUNOS4_CC -> SUNOS_CC.

2005-07-29 Thread Bruce Momjian
Log Message: --- SUNOS4_CC -> SUNOS_CC. Modified Files: -- pgsql/src/backend/storage/lmgr: s_lock.c (r1.35 -> r1.36) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/s_lock.c.diff?r1=1.35&r2=1.36) pgsql/src/template: su

[COMMITTERS] pgsql: Add: > * Add PQescapeIdentifier() to libpq

2005-07-29 Thread Bruce Momjian
Log Message: --- Add: > * Add PQescapeIdentifier() to libpq Modified Files: -- pgsql/doc: TODO (r1.1602 -> r1.1603) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1602&r2=1.1603) pgsql/doc/src/FAQ: TODO.html (r1.109 -> r1.

[COMMITTERS] python - pq: Relocate message classes to a more natural position, and

2005-07-29 Thread James William Pye
Log Message: --- Relocate message classes to a more natural position, and remove an unnecessary comment. Modified Files: -- pq/src: element3.py (r1.1.1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/pq/src/element3.py.diff?r1=1.1.1.1&r2=1.2)

[COMMITTERS] bizgres - bizgres: Minor changes

2005-07-29 Thread User Nwakefield
Log Message: --- Minor changes Modified Files: -- bizgres/KETL/conf: clickstream.properties (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/conf/clickstream.properties.diff?r1=1.2&r2=1.3) Extra.Config (r1.2 -> r1.3)

[COMMITTERS] bizgres - bizgres: changed default build to package

2005-07-29 Thread User Nwakefield
Log Message: --- changed default build to package Modified Files: -- bizgres/KETL: build.xml (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/build.xml.diff?r1=1.3&r2=1.4) ---(end of broadcast)---

[COMMITTERS] pgsql: Fix an oversight I introduced on 2003-12-28: find_nots/push_nots

2005-07-29 Thread Tom Lane
Log Message: --- Fix an oversight I introduced on 2003-12-28: find_nots/push_nots should continue to recurse after eliminating a NOT-below-a-NOT, since the contained subexpression will now be part of the top-level AND/OR structure and so deserves to be simplified. The real-world impact of

[COMMITTERS] pgsql: Back-patch fix for NOT-below-a-NOT case.

2005-07-29 Thread Tom Lane
Log Message: --- Back-patch fix for NOT-below-a-NOT case. Tags: REL8_0_STABLE Modified Files: -- pgsql/src/backend/optimizer/prep: prepqual.c (r1.48 -> r1.48.4.1) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepqual.c.

[COMMITTERS] bizgres - bizgres: Changed the default image url from "/images" to

2005-07-29 Thread User Bklawans
Log Message: --- Changed the default image url from "/images" to "/bizgres/images". Modified Files: -- bizgres/JasperReportsRunner/src/com/jaspersoft/bizgres/clickstream: JasperReportsRunner.java (r1.7 -> r1.8) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/b

[COMMITTERS] bizgres - bizgres: Provide an error message when there are some

2005-07-29 Thread User Jzhang
Log Message: --- Provide an error message when there are some incompatible changes in the system catalog. Modified Files: -- bizgres/postgresql/src/include/catalog: catversion.h (r1.1.1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgre

[COMMITTERS] pgsql: Remove contrib version of pg_autovacuum --- superseded by

2005-07-29 Thread Tom Lane
Log Message: --- Remove contrib version of pg_autovacuum --- superseded by integrated version. Modified Files: -- pgsql/contrib: Makefile (r1.59 -> r1.60) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/Makefile.diff?r1=1.59&r2=1.60) READM

[COMMITTERS] pgsql: Clean up a number of autovacuum loose ends.

2005-07-29 Thread Tom Lane
Log Message: --- Clean up a number of autovacuum loose ends. Make the stats collector track shared relations in a separate hashtable, so that operations done from different databases are counted correctly. Add proper support for anti-XID-wraparound vacuuming, even in databases that are ne

[COMMITTERS] pgsql: It appears we need -DSUNOS4_CC for both solaris and sunos4

2005-07-29 Thread Tom Lane
Log Message: --- It appears we need -DSUNOS4_CC for both solaris and sunos4 templates. Per report from Andrew Clark. Modified Files: -- pgsql/src/template: solaris (r1.22 -> r1.23) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/template/solaris.diff?

[COMMITTERS] bizgres - bizgres: Cleanup and improvements per feedback.

2005-07-29 Thread User Llonergan
Log Message: --- Cleanup and improvements per feedback. Modified Files: -- bizgres/demo: clicksExample.tar (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/demo/clicksExample.tar.diff?r1=1.1&r2=1.2) ---(en

[COMMITTERS] bizgres - bizgres: Introduce release Release-0_7_3

2005-07-29 Thread User Builder
Log Message: --- Introduce release Release-0_7_3 Modified Files: -- bizgres: release.txt (r1.10 -> r1.11) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/release.txt.diff?r1=1.10&r2=1.11) ---(end of broadcast)--

[COMMITTERS] pgsql: Add detail: > > If CRC check fails during recovery, remember

2005-07-29 Thread Bruce Momjian
Log Message: --- Add detail: > > If CRC check fails during recovery, remember the page in case > a later CRC for that page properly matches. > Modified Files: -- pgsql/doc: TODO (r1.1601 -> r1.1602) (http://developer.postgresql.org/cvsweb

[COMMITTERS] pgsql: Move reindexdb from /contrib to /bin.

2005-07-29 Thread Bruce Momjian
Log Message: --- Move reindexdb from /contrib to /bin. Euler Taveira de Oliveira Modified Files: -- pgsql/contrib: Makefile (r1.58 -> r1.59) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/Makefile.diff?r1=1.58&r2=1.59) README (r1.80 -> r

[COMMITTERS] pgsql: Remove dbsize mention.

2005-07-29 Thread Bruce Momjian
Log Message: --- Remove dbsize mention. Modified Files: -- pgsql/contrib: README (r1.79 -> r1.80) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/README.diff?r1=1.79&r2=1.80) ---(end of broadcast)--

Re: [COMMITTERS] pgsql: Move dbsize functions into the backend.

2005-07-29 Thread Bruce Momjian
Tom Lane wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > Move dbsize functions into the backend. New functions: > > catversion.h? Sorry. Done. > Also, removing the dbsize directory without fixing contrib/README and > contrib/Makefile is a bad idea. I already did the Makefile, just did

[COMMITTERS] pgsql: Update catversion for dbsize changes.

2005-07-29 Thread Bruce Momjian
Log Message: --- Update catversion for dbsize changes. Modified Files: -- pgsql/src/include/catalog: catversion.h (r1.292 -> r1.293) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.292&r2=1.293)

Re: [COMMITTERS] pgsql: Move dbsize functions into the backend.

2005-07-29 Thread Tom Lane
[EMAIL PROTECTED] (Bruce Momjian) writes: > Move dbsize functions into the backend. New functions: catversion.h? Also, removing the dbsize directory without fixing contrib/README and contrib/Makefile is a bad idea. regards, tom lane ---(end of br

[COMMITTERS] pgsql: Move dbsize functions into the backend.

2005-07-29 Thread Bruce Momjian
Log Message: --- Move dbsize functions into the backend. New functions: pg_tablespace_size pg_database_size pg_relation_size pg_complete_relation_size pg_size_pretty Remove /contrib/dbsize. Dave Page Modified Files: -- pgs

[COMMITTERS] pgsql: Add mp3 entry to FAQ.

2005-07-29 Thread Bruce Momjian
Log Message: --- Add mp3 entry to FAQ. Modified Files: -- pgsql/doc: FAQ (r1.353 -> r1.354) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.353&r2=1.354) ---(end of broadcast)--- TIP 4: Ha

[COMMITTERS] pgsql: I've had this small patch in my local tree for a while.

2005-07-29 Thread Bruce Momjian
Log Message: --- I've had this small patch in my local tree for a while. It documents new commands which may make an SPI call fail. Alvaro Herrera Modified Files: -- pgsql/doc/src/sgml: spi.sgml (r1.41 -> r1.42) (http://developer.postgresql.org/cvsweb.cgi

[COMMITTERS] pgsql: Fix typo.

2005-07-29 Thread Bruce Momjian
Log Message: --- Fix typo. uniware Modified Files: -- pgsql/src/backend/utils/adt: varchar.c (r1.111 -> r1.112) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/varchar.c.diff?r1=1.111&r2=1.112) ---(end of br