[COMMITTERS] pgsql: Un-Windows-ify newlines.

2005-08-02 Thread Tom Lane
Log Message:
---
Un-Windows-ify newlines.

Modified Files:
--
pgsql/src/backend/utils/adt:
dbsize.c (r1.1 -> r1.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/dbsize.c.diff?r1=1.1&r2=1.2)

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


[COMMITTERS] pgsql: rmtree() reported the wrong pathname if final rmdir failed.

2005-08-02 Thread Tom Lane
Log Message:
---
rmtree() reported the wrong pathname if final rmdir failed.

Modified Files:
--
pgsql/src/port:
dirmod.c (r1.37 -> r1.38)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/port/dirmod.c.diff?r1=1.37&r2=1.38)

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[COMMITTERS] pgsql: Use ReadDir() not readdir() so as to have some modicum of error

2005-08-02 Thread Tom Lane
Log Message:
---
Use ReadDir() not readdir() so as to have some modicum of error checking.

Modified Files:
--
pgsql/src/backend/utils/adt:
dbsize.c (r1.2 -> r1.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/dbsize.c.diff?r1=1.2&r2=1.3)

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


[COMMITTERS] pgsql: rmtree() reported the wrong pathname if final rmdir failed.

2005-08-02 Thread Tom Lane
Log Message:
---
rmtree() reported the wrong pathname if final rmdir failed.

Tags:

REL8_0_STABLE

Modified Files:
--
pgsql/src/port:
dirmod.c (r1.34.4.2 -> r1.34.4.3)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/port/dirmod.c.diff?r1=1.34.4.2&r2=1.34.4.3)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] pgsql: Add ERROR_NO_MORE_FILES workaround to check_data_dir().

2005-08-02 Thread Tom Lane
Log Message:
---
Add ERROR_NO_MORE_FILES workaround to check_data_dir().  This may or
may not be obsolete, but since every other readdir loop in our code
has it, I think this should too.

Modified Files:
--
pgsql/src/bin/initdb:
initdb.c (r1.93 -> r1.94)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/initdb/initdb.c.diff?r1=1.93&r2=1.94)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] pgsql: Code and docs review for pg_column_size() patch.

2005-08-02 Thread Tom Lane
Log Message:
---
Code and docs review for pg_column_size() patch.

Modified Files:
--
pgsql/doc/src/sgml:
func.sgml (r1.275 -> r1.276)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.275&r2=1.276)
pgsql/src/backend/access/heap:
tuptoaster.c (r1.50 -> r1.51)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap/tuptoaster.c.diff?r1=1.50&r2=1.51)
pgsql/src/backend/utils/adt:
varlena.c (r1.130 -> r1.131)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/varlena.c.diff?r1=1.130&r2=1.131)
pgsql/src/include/catalog:
pg_proc.h (r1.379 -> r1.380)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h.diff?r1=1.379&r2=1.380)

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[COMMITTERS] bizgres - bizgres:

2005-08-02 Thread User Nwakefield
Log Message:
---


Modified Files:
--
bizgres/KETL/bin:
ketl_start (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/bin/ketl_start.diff?r1=1.1&r2=1.2)
ketl_ctl (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/bin/ketl_ctl.diff?r1=1.1&r2=1.2)
bizgres/KETL/xml/examples:
CRT_REPORTS.xml (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/xml/examples/CRT_REPORTS.xml.diff?r1=1.3&r2=1.4)
bizgres/KETL/xml:
KETLServers.xml (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/xml/KETLServers.xml.diff?r1=1.2&r2=1.3)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] bizgres - bizgres:

2005-08-02 Thread User Nwakefield
Log Message:
---


Modified Files:
--
bizgres/KETL:
README.txt (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/README.txt.diff?r1=1.2&r2=1.3)
build.xml (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/build.xml.diff?r1=1.5&r2=1.6)

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


[COMMITTERS] bizgres - bizgres: added support for multiple locations of jars

2005-08-02 Thread User Nwakefield
Log Message:
---
added support for multiple locations of jars

Modified Files:
--
bizgres/KETL:
build.xml (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/build.xml.diff?r1=1.6&r2=1.7)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] pgsql: Clean up CREATE DATABASE processing to make it more robust and

2005-08-02 Thread Tom Lane
Log Message:
---
Clean up CREATE DATABASE processing to make it more robust and get rid
of special case for Windows port.  Put a PG_TRY around most of createdb()
to ensure that we remove copied subdirectories on failure, even if the
failure happens while creating the pg_database row.  (I think this explains
Oliver Siegmar's recent report.)  Having done that, there's no need for
the fragile assumption that copydir() mustn't ereport(ERROR), so simplify
its API.  Eliminate the old code that used system("cp ...") to copy
subdirectories, in favor of using copydir() on all platforms.  This not
only should allow much better error reporting, but allows us to fsync
the created files before trusting that the copy has succeeded.

Modified Files:
--
pgsql:
configure (r1.444 -> r1.445)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/configure.diff?r1=1.444&r2=1.445)
configure.in (r1.417 -> r1.418)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/configure.in.diff?r1=1.417&r2=1.418)
pgsql/src:
Makefile.global.in (r1.218 -> r1.219)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/Makefile.global.in.diff?r1=1.218&r2=1.219)
pgsql/src/backend/commands:
dbcommands.c (r1.168 -> r1.169)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c.diff?r1=1.168&r2=1.169)
pgsql/src/include:
port.h (r1.79 -> r1.80)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/port.h.diff?r1=1.79&r2=1.80)
pgsql/src/port:
copydir.c (r1.11 -> r1.12)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/port/copydir.c.diff?r1=1.11&r2=1.12)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] bizgres - bizgres: Example Warehouse and Metadata

2005-08-02 Thread User Nwakefield
Log Message:
---
Example Warehouse and Metadata

Added Files:
---
bizgres/KETL/setup:
clickstreamExample.dmp.bz2 (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/setup/clickstreamExample.dmp.bz2?rev=1.1&content-type=text/x-cvsweb-markup)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] bizgres - bizgres: Empty warehouse with seeded metadata and example

2005-08-02 Thread User Nwakefield
Log Message:
---
Empty warehouse with seeded metadata and example weblog

Added Files:
---
bizgres/KETL/setup:
clickstreamBlank.dmp.bz2 (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/setup/clickstreamBlank.dmp.bz2?rev=1.1&content-type=text/x-cvsweb-markup)
exampleWebLog.bz2 (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/setup/exampleWebLog.bz2?rev=1.1&content-type=text/x-cvsweb-markup)

Removed Files:
-
bizgres/KETL/setup:
clickstreamWithData.dmp

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/setup/clickstreamWithData.dmp)
clickstreamWithMD.dmp

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/setup/clickstreamWithMD.dmp)
clickstreamEmpty.dmp

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/setup/clickstreamEmpty.dmp)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] pgsql: Prevent planner from including temp tables of other backends when

2005-08-02 Thread Tom Lane
Log Message:
---
Prevent planner from including temp tables of other backends when expanding
an inheritance tree.  Per recent discussions.

Modified Files:
--
pgsql/src/backend/optimizer/prep:
prepunion.c (r1.125 -> r1.126)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepunion.c.diff?r1=1.125&r2=1.126)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] pgsql: Tweak BgBufferSync() so that a persistent write error on a dirty

2005-08-02 Thread Tom Lane
Log Message:
---
Tweak BgBufferSync() so that a persistent write error on a dirty buffer
doesn't block the bgwriter from making progress writing out other buffers.
This was a hard problem in the context of the ARC/2Q design, but it's
trivial in the context of clock sweep ... just advance the sweep counter
before we try to write not after.

Modified Files:
--
pgsql/src/backend/postmaster:
bgwriter.c (r1.17 -> r1.18)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/postmaster/bgwriter.c.diff?r1=1.17&r2=1.18)
pgsql/src/backend/storage/buffer:
bufmgr.c (r1.189 -> r1.190)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/buffer/bufmgr.c.diff?r1=1.189&r2=1.190)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] bizgres - bizgres: moved clickstream.properties to WEB-INF/lib of webapp

2005-08-02 Thread User Nitin
Log Message:
---
moved clickstream.properties to WEB-INF/lib of webapp
added pointer in conf/Extra.Config

Removed Files:
-
bizgres/KETL/conf:
clickstream.properties

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/conf/clickstream.properties)

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


[COMMITTERS] bizgres - bizgres: modified -D clickstream.property.file

2005-08-02 Thread User Nitin
Log Message:
---
modified -D clickstream.property.file

Modified Files:
--
bizgres/KETL/conf:
Extra.Config (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/conf/Extra.Config.diff?r1=1.3&r2=1.4)

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[COMMITTERS] pgsql: Done: < * Prevent inherited tables from expanding temporary

2005-08-02 Thread Bruce Momjian
Log Message:
---

Done:

< * Prevent inherited tables from expanding temporary subtables of other
> * -Prevent inherited tables from expanding temporary subtables of other

Modified Files:
--
pgsql/doc:
TODO (r1.1616 -> r1.1617)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1616&r2=1.1617)
pgsql/doc/src/FAQ:
TODO.html (r1.123 -> r1.124)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.123&r2=1.124)

---(end of broadcast)---
TIP 6: explain analyze is your friend


[COMMITTERS] python - pq: Get the exception information from sys.exc_info().

2005-08-02 Thread James William Pye
Log Message:
---
Get the exception information from sys.exc_info().
Rename the exception attribute to exc_info to better describe the object.
Grab all exceptions. Not just Exception subclasses.

Modified Files:
--
pq/src:
transam.py (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/pq/src/transam.py.diff?r1=1.1.1.1&r2=1.2)

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


[COMMITTERS] python - pq: ShowOption is an asynchronous message, so treat it as such.

2005-08-02 Thread James William Pye
Log Message:
---
ShowOption is an asynchronous message, so treat it as such.

Also, 'Q' messages have an implied sync, so consume the SynchronizeMessage
returned by the handle_error state to avoid a double synchronize.
(Later, perhaps, remove the syncmsg return from handle_error entirely.)

Modified Files:
--
pq/src:
client3.py (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/pq/src/client3.py.diff?r1=1.1.1.1&r2=1.2)
pq/test:
client3.py (r1.1.1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/pq/test/client3.py.diff?r1=1.1.1.1&r2=1.2)

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster