[COMMITTERS] pgsql: Fix oversight in MIN/MAX optimization: must not return NULL

2005-04-11 Thread Tom Lane
Log Message: --- Fix oversight in MIN/MAX optimization: must not return NULL entries from index, since the aggregates ignore NULLs. Modified Files: -- pgsql/src/backend/optimizer/plan: createplan.c (r1.178 -> r1.179) (http://developer.postgresql.org/cvsweb.

[COMMITTERS] newsysviews - newsysview: table constraints and foreign keys

2005-04-11 Thread User Andrewsn
Log Message: --- table constraints and foreign keys Modified Files: -- newsysview/sql: _funcs.sql (r1.6 -> r1.7) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_funcs.sql.diff?r1=1.6&r2=1.7) Added Files: --- newsysview/

[COMMITTERS] newsysviews - newsysview: allow for missing tablespace row (7.4 compat

2005-04-11 Thread User Andrewsn
Log Message: --- allow for missing tablespace row (7.4 compat again) Modified Files: -- newsysview/sql: databases.sql (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/databases.sql.diff?r1=1.3&r2=1.4) -

[COMMITTERS] pgsql: Add aggsortop column to pg_aggregate, so that MIN/MAX

2005-04-11 Thread Tom Lane
Log Message: --- Add aggsortop column to pg_aggregate, so that MIN/MAX optimization can be supported for all datatypes. Add CREATE AGGREGATE and pg_dump support too. Add specialized min/max aggregates for bpchar, instead of depending on text's min/max, because otherwise the possible use o

[COMMITTERS] newsysviews - newsysview: 7.4 compat

2005-04-11 Thread User Andrewsn
Log Message: --- 7.4 compat Modified Files: -- newsysview/sql: _compat74.sql (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_compat74.sql.diff?r1=1.3&r2=1.4) databases.sql (r1.2 -> r1.3) (http://cvs.p

[COMMITTERS] pgsql: Fix broken markup.

2005-04-11 Thread Tom Lane
Log Message: --- Fix broken markup. Modified Files: -- pgsql/doc/src/sgml: geqo.sgml (r1.31 -> r1.32) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/geqo.sgml.diff?r1=1.31&r2=1.32) history.sgml (r1.26 -> r1.27) (http://devel

[COMMITTERS] newsysviews - newsysview: add view for database configuration

2005-04-11 Thread User Andrewsn
Log Message: --- add view for database configuration parameters, broken out into rows. Modified Files: -- newsysview/sql: _compat80.sql (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/_compat80.sql.diff?r1=1.3&r2=1.4)

[COMMITTERS] newsysviews - newsysview: Partial implementation of pg_users added for

2005-04-11 Thread User Aglio
Log Message: --- Partial implementation of pg_users added for examination. Added Files: --- newsysview/sql: users.sql (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/newsysviews/newsysview/sql/users.sql?rev=1.1&content-type=text/x-cvsweb-markup) --

[COMMITTERS] pgsql: Create the planner mechanism for optimizing simple MIN and MAX

2005-04-11 Thread Tom Lane
Log Message: --- Create the planner mechanism for optimizing simple MIN and MAX queries into indexscans on matching indexes. For the moment, it only handles int4 and text datatypes; next step is to add a column to pg_aggregate so that all MIN/MAX aggregates can be handled. Per my recent p

[COMMITTERS] python - web: Add CVS Web interface links to the project description

2005-04-11 Thread User Jwp
Log Message: --- Add CVS Web interface links to the project description pages. Remove a link from the site.xml, as there seems to be trouble with the sublink "thingies". Modified Files: -- web/src/documentation/content/xdocs: index.xml (r1.1.1.1 -> r1.2) (h

[COMMITTERS] pgsql: Fix interaction between materializing holdable cursors and firing

2005-04-11 Thread Tom Lane
Log Message: --- Fix interaction between materializing holdable cursors and firing deferred triggers: either one can create more work for the other, so we have to loop till it's all gone. Per example from [EMAIL PROTECTED] Add a regression test to help spot trouble in this area in future.

[COMMITTERS] pgsql: Fix interaction between materializing holdable cursors and firing

2005-04-11 Thread Tom Lane
Log Message: --- Fix interaction between materializing holdable cursors and firing deferred triggers: either one can create more work for the other, so we have to loop till it's all gone. Per example from [EMAIL PROTECTED] Add a regression test to help spot trouble in this area in future.

[COMMITTERS] python - web: Imported Sources

2005-04-11 Thread User Jwp
Update of /cvsroot/python/web In directory pgfoundry.org:/tmp/cvs-serv65845 Log Message: Bring in project web source[forrest 0.6] Status: Vendor Tag: NONE Release Tags: INIT N web/forrest.properties N web/.cvsignore N web/src/documentation/skinconf.xml N web/src/documentat

[COMMITTERS] docbot - www: Initial checkin of www stuff

2005-04-11 Thread User Pjmodos
Log Message: --- Initial checkin of www stuff Added Files: --- www/cgi-bin: search.pl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/docbot/www/cgi-bin/search.pl?rev=1.1&content-type=text/x-cvsweb-markup) www/images: docbot.css (r1.1)

[COMMITTERS] docbot - www: New Directory

2005-04-11 Thread User Pjmodos
Update of /cvsroot/docbot/www/images In directory pgfoundry.org:/tmp/cvs-serv53349/images Log Message: Directory /cvsroot/docbot/www/images added to the repository ---(end of broadcast)--- TIP 6: Have you searched our list archives?

[COMMITTERS] docbot - www: New Directory

2005-04-11 Thread User Pjmodos
Update of /cvsroot/docbot/www/cgi-bin In directory pgfoundry.org:/tmp/cvs-serv53349/cgi-bin Log Message: Directory /cvsroot/docbot/www/cgi-bin added to the repository ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregi

[COMMITTERS] docbot - www: New Directory

2005-04-11 Thread User Pjmodos
Update of /cvsroot/docbot/www/templates In directory pgfoundry.org:/tmp/cvs-serv53349/templates Log Message: Directory /cvsroot/docbot/www/templates added to the repository ---(end of broadcast)--- TIP 7: don't forget to increase your free space ma

[COMMITTERS] docbot - www: New Directory

2005-04-11 Thread User Pjmodos
Update of /cvsroot/docbot/www/integration In directory pgfoundry.org:/tmp/cvs-serv53349/integration Log Message: Directory /cvsroot/docbot/www/integration added to the repository ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go

[COMMITTERS] docbot - www: New Directory

2005-04-11 Thread User Pjmodos
Update of /cvsroot/docbot/www In directory pgfoundry.org:/tmp/cvs-serv51759/www Log Message: Directory /cvsroot/docbot/www added to the repository ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate s

[COMMITTERS] docbot - www: New Directory

2005-04-11 Thread User Pjmodos
Update of /cvsroot/docbot/www/templates In directory pgfoundry.org:/tmp/cvs-serv39874/templates Log Message: Directory /cvsroot/docbot/www/templates added to the repository ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[COMMITTERS] docbot - www: Added right files, sorry for that first commit

2005-04-11 Thread User Pjmodos
Log Message: --- Added right files, sorry for that first commit Added Files: --- www/cgi-bin: search.pl (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/docbot/www/cgi-bin/search.pl?rev=1.1&content-type=text/x-cvsweb-markup) www/images: docbot.cs

[COMMITTERS] docbot - www: New Directory

2005-04-11 Thread User Pjmodos
Update of /cvsroot/docbot/www/images In directory pgfoundry.org:/tmp/cvs-serv39874/images Log Message: Directory /cvsroot/docbot/www/images added to the repository ---(end of broadcast)--- TIP 6: Have you searched our list archives?

[COMMITTERS] docbot - www: Oops i did mistake, removed all files from www

2005-04-11 Thread User Pjmodos
Log Message: --- Oops i did mistake, removed all files from www Removed Files: - www/CVSROOT: checkoutlist (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/docbot/www/CVSROOT/checkoutlist) commitinfo (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi

[COMMITTERS] docbot - www: New Directory

2005-04-11 Thread User Pjmodos
Update of /cvsroot/docbot/www/integration In directory pgfoundry.org:/tmp/cvs-serv39874/integration Log Message: Directory /cvsroot/docbot/www/integration added to the repository ---(end of broadcast)--- TIP 8: explain analyze is your friend

[COMMITTERS] docbot - www: New Directory

2005-04-11 Thread User Pjmodos
Update of /cvsroot/docbot/www/cgi-bin In directory pgfoundry.org:/tmp/cvs-serv39874/cgi-bin Log Message: Directory /cvsroot/docbot/www/cgi-bin added to the repository ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[COMMITTERS] docbot - www: Imported Sources

2005-04-11 Thread User Pjmodos
Update of /cvsroot/docbot/www In directory pgfoundry.org:/tmp/cvs-serv34648 Log Message: Initial import of www stuff Status: Vendor Tag: DOCBOT_TEAM Release Tags: DOCBOT_WWW_1_0 N www/CVSROOT/checkoutlist N www/CVSROOT/commitinfo N www/CVSROOT/config N www/CVSROOT/cvswrapp

[COMMITTERS] pgsql: PersistHoldablePortal must establish the correct value for

2005-04-11 Thread Tom Lane
Log Message: --- PersistHoldablePortal must establish the correct value for ActiveSnapshot while completing execution of the cursor's query. Otherwise we get wrong answers or even crashes from non-volatile functions called by the query. Per report from [EMAIL PROTECTED] Tags: REL8_0_

[COMMITTERS] pgsql: PersistHoldablePortal must establish the correct value for

2005-04-11 Thread Tom Lane
Log Message: --- PersistHoldablePortal must establish the correct value for ActiveSnapshot while completing execution of the cursor's query. Otherwise we get wrong answers or even crashes from non-volatile functions called by the query. Per report from [EMAIL PROTECTED] Modified Files: --

[COMMITTERS] python - me: Imported Sources

2005-04-11 Thread User Jwp
Update of /cvsroot/python/me In directory pgfoundry.org:/tmp/cvs-serv9592 Log Message: Bring in the instradon metaend. Still lots of work to be done on this. xact.py doesn't do factory class (some abstract base classes just specifying the expected interfaces) dbapi2.py is far from complete lo.py

[COMMITTERS] python - be: Remove setattr as it was just a wasting way to say "you

2005-04-11 Thread User Jwp
Log Message: --- Remove setattr as it was just a wasting way to say "you can't set the attribute". Return false on comparisons that aren't comparing Postgres.Object's. This was meant to be a convenience, but it seems like it might cause more trouble than it would do good. Modified Files: -

[COMMITTERS] python - be: remove unnecessary type structure initializations, the

2005-04-11 Thread User Jwp
Log Message: --- remove unnecessary type structure initializations, the flags and the tp_free will be properly inherited from PyPgObject_Type. Modified Files: -- be/src: type.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/type.c

[COMMITTERS] python - be: uncomment the LargeObject initialization

2005-04-11 Thread User Jwp
Log Message: --- uncomment the LargeObject initialization Modified Files: -- be/src: prime.py (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/be/src/prime.py.diff?r1=1.3&r2=1.4) ---(end of broadcast)--

[COMMITTERS] python - be: fix assertion trap.

2005-04-11 Thread User Jwp
Log Message: --- fix assertion trap. If ErrorData is duplicated in the Error context, bad things could happen. Properly fetch the error's exception class. Modified Files: -- be/src: error.c (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/

[COMMITTERS] docbot - docbot: Output more urls per line

2005-04-11 Thread User Pjmodos
Log Message: --- Output more urls per line Modified Files: -- docbot: docbot.pl (r1.35 -> r1.36) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/docbot/docbot/docbot.pl.diff?r1=1.35&r2=1.36) ---(end of broadcast)---