Re: [COMMITTERS] pgsql: Fix memory arrangement of tsquery after removing stop words.

2008-03-09 Thread Teodor Sigaev



The buildfarm indicates there's something wrong with the 8.3 version
of this patch ...


Oh, my mistake. That means that patch of CompareTSQ should be reverted, because 
it change comparing of existing tsquery (it's important for existing btree indexes).


Computing tsquery->size and length of tsquery instead of using stored values 
causes the same effect: it will affect existing btree indexes.


However, Btree index over tsquery is not very useful. IMHO, the single purpose 
is a guarantee unique of stored tsquery.



--
Teodor Sigaev   E-mail: [EMAIL PROTECTED]
   WWW: http://www.sigaev.ru/

--
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Revert changes of CompareTSQ: it affects existing btree indexes.

2008-03-09 Thread Teodor Sigaev
Log Message:
---
Revert changes of CompareTSQ: it affects existing btree indexes.

Tags:

REL8_3_STABLE

Modified Files:
--
pgsql/src/backend/utils/adt:
tsquery_op.c (r1.3.2.1 -> r1.3.2.2)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_op.c?r1=1.3.2.1&r2=1.3.2.2)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgfouine - pgfouine: Made date parsing more permissive

2008-03-09 Thread User Gsmet
Log Message:
---
Made date parsing more permissive

Modified Files:
--
pgfouine/include/postgresql/parsers:
SyslogPostgreSQLParser.class.php (r1.16 -> r1.17)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/parsers/SyslogPostgreSQLParser.class.php.diff?r1=1.16&r2=1.17)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgfouine - pgfouine: global copyright update

2008-03-09 Thread User Gsmet
Log Message:
---
global copyright update

Modified Files:
--
pgfouine/include/reporting:
ReportAggregator.class.php (r1.20 -> r1.21)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/ReportAggregator.class.php.diff?r1=1.20&r2=1.21)
HtmlWithGraphsReportAggregator.class.php (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/HtmlWithGraphsReportAggregator.class.php.diff?r1=1.3&r2=1.4)
reports.lib.php (r1.15 -> r1.16)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports.lib.php.diff?r1=1.15&r2=1.16)
HtmlReportAggregator.class.php (r1.26 -> r1.27)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/HtmlReportAggregator.class.php.diff?r1=1.26&r2=1.27)
TextReportAggregator.class.php (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/TextReportAggregator.class.php.diff?r1=1.5&r2=1.6)
pgfouine/include/listeners/error:
NormalizedErrorsListener.class.php (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/listeners/error/NormalizedErrorsListener.class.php.diff?r1=1.6&r2=1.7)
PrintErrorListener.class.php (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/listeners/error/PrintErrorListener.class.php.diff?r1=1.3&r2=1.4)
GlobalErrorCountersListener.class.php (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/listeners/error/GlobalErrorCountersListener.class.php.diff?r1=1.3&r2=1.4)
ErrorListener.class.php (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/listeners/error/ErrorListener.class.php.diff?r1=1.4&r2=1.5)
pgfouine/include/reporting/reports:
HourlyStatsReport.class.php (r1.14 -> r1.15)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/HourlyStatsReport.class.php.diff?r1=1.14&r2=1.15)
NormalizedErrorsMostFrequentReport.class.php (r1.9 -> r1.10)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/NormalizedErrorsMostFrequentReport.class.php.diff?r1=1.9&r2=1.10)
OverallStatsReport.class.php (r1.17 -> r1.18)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/OverallStatsReport.class.php.diff?r1=1.17&r2=1.18)
NormalizedQueriesSlowestAverageReport.class.php (r1.11 -> r1.12)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/NormalizedQueriesSlowestAverageReport.class.php.diff?r1=1.11&r2=1.12)
SlowestQueriesReport.class.php (r1.12 -> r1.13)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/SlowestQueriesReport.class.php.diff?r1=1.12&r2=1.13)
Report.class.php (r1.13 -> r1.14)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/Report.class.php.diff?r1=1.13&r2=1.14)
NormalizedErrorsReport.class.php (r1.7 -> r1.8)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/NormalizedErrorsReport.class.php.diff?r1=1.7&r2=1.8)
NormalizedQueriesMostTimeReport.class.php (r1.14 -> r1.15)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/NormalizedQueriesMostTimeReport.class.php.diff?r1=1.14&r2=1.15)
QueriesByTypeReport.class.php (r1.8 -> r1.9)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/QueriesByTypeReport.class.php.diff?r1=1.8&r2=1.9)
NormalizedReport.class.php (r1.10 -> r1.11)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/NormalizedReport.class.php.diff?r1=1.10&r2=1.11)
NormalizedQueriesMostFrequentReport.class.php (r1.11 -> r1.12)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/reporting/reports/NormalizedQueriesMostFrequentReport.class.php.diff?r1=1.11&r2=1.12)
pgfouine/include/postgresql/lines:
PostgreSQLStatementLine.class.php (r1.7 -> r1.8)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/lines/PostgreSQLStatementLine.class.php.diff?r1=1.7&r2=1.8)
PostgreSQLContinuationLine.class.php (r1.8 -> r1.9)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/lines/PostgreSQLContinuationLine.class.php.diff?r1=1.8&r2=1.9)
PostgreSQLLogLine.class.php (r1.13 -> r1.14)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/lines/PostgreSQLLogLine.class.php.diff?r1=1.13&r2=1.14)
PostgreSQLContextLine.cla

[COMMITTERS] pgfouine - pgfouine: global copyright update

2008-03-09 Thread User Gsmet
Log Message:
---
global copyright update

Modified Files:
--
pgfouine/include/postgresql/vacuum/parsers:
PostgreSQLVacuumParser.class.php (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/parsers/PostgreSQLVacuumParser.class.php.diff?r1=1.6&r2=1.7)
pgfouine/include/postgresql/vacuum/lines:
PostgreSQLFSMInformationLine.class.php (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLFSMInformationLine.class.php.diff?r1=1.1&r2=1.2)
PostgreSQLVacuumContinuationLine.class.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLVacuumContinuationLine.class.php.diff?r1=1.2&r2=1.3)
PostgreSQLVacuumCpuDetailLine.class.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLVacuumCpuDetailLine.class.php.diff?r1=1.2&r2=1.3)
PostgreSQLVacuumOperationInformationLine.class.php (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLVacuumOperationInformationLine.class.php.diff?r1=1.1&r2=1.2)
PostgreSQLVacuumEndLine.class.php (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLVacuumEndLine.class.php.diff?r1=1.1&r2=1.2)
PostgreSQLIndexCleanupDetailLine.class.php (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLIndexCleanupDetailLine.class.php.diff?r1=1.4&r2=1.5)
PostgreSQLVacuumRemovableInformationLine.class.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLVacuumRemovableInformationLine.class.php.diff?r1=1.2&r2=1.3)
PostgreSQLVacuumDetailLine.class.php (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLVacuumDetailLine.class.php.diff?r1=1.4&r2=1.5)
PostgreSQLVacuumLogLine.class.php (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLVacuumLogLine.class.php.diff?r1=1.4&r2=1.5)
PostgreSQLFSMInformationDetailLine.class.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLFSMInformationDetailLine.class.php.diff?r1=1.2&r2=1.3)
PostgreSQLIndexCleanupInformationLine.class.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLIndexCleanupInformationLine.class.php.diff?r1=1.2&r2=1.3)
PostgreSQLAnalyzingTableLine.class.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLAnalyzingTableLine.class.php.diff?r1=1.2&r2=1.3)
PostgreSQLVacuumingTableLine.class.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/lines/PostgreSQLVacuumingTableLine.class.php.diff?r1=1.2&r2=1.3)
pgfouine/include/postgresql/vacuum/objects:
VacuumLogObject.class.php (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/objects/VacuumLogObject.class.php.diff?r1=1.3&r2=1.4)
AnalyzeTableLogObject.class.php (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/objects/AnalyzeTableLogObject.class.php.diff?r1=1.3&r2=1.4)
VacuumIndexInformation.class.php (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/objects/VacuumIndexInformation.class.php.diff?r1=1.4&r2=1.5)
FSMInformationLogObject.class.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/objects/FSMInformationLogObject.class.php.diff?r1=1.2&r2=1.3)
VacuumTableLogObject.class.php (r1.12 -> r1.13)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/objects/VacuumTableLogObject.class.php.diff?r1=1.12&r2=1.13)
pgfouine/include/postgresql/vacuum:
VacuumLogStream.class.php (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/VacuumLogStream.class.php.diff?r1=1.4&r2=1.5)
PostgreSQLVacuumAccumulator.class.php (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgfouine/pgfouine/include/postgresql/vacuum/PostgreSQLVacuumAccumulator.class.php.diff?r1=1.2&r2=1.3)
vacuum.lib.php (r1.6 -> r1.7)

(http:

[COMMITTERS] pgunittest - pgUnitTest_Rnd:

2008-03-09 Thread User Pgunittest
Log Message:
---


Modified Files:
--
pgUnitTest_Rnd/src:
pguUtilities.cpp (r1.6 -> r1.7)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Rnd/src/pguUtilities.cpp.diff?r1=1.6&r2=1.7)
pguMain.cpp (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Rnd/src/pguMain.cpp.diff?r1=1.2&r2=1.3)
pgUnitTest_Rnd/src/include/pgut:
pguUtilities.h (r1.5 -> r1.6)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Rnd/src/include/pgut/pguUtilities.h.diff?r1=1.5&r2=1.6)
pguContext.h (r1.4 -> r1.5)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgunittest/pgUnitTest_Rnd/src/include/pgut/pguContext.h.diff?r1=1.4&r2=1.5)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] npgsql - Npgsql2: Added support to property ProcessID in

2008-03-09 Thread User Fxjr
Log Message:
---


Added support to property ProcessID in NpgsqlConnection.

Modified Files:
--
Npgsql2/src/Npgsql:
NpgsqlConnection.cs (r1.14 -> r1.15)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/NpgsqlConnection.cs.diff?r1=1.14&r2=1.15)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Fix pgbench's getrand() function so that min and max have

2008-03-09 Thread Tom Lane
Log Message:
---
Fix pgbench's getrand() function so that min and max have approximately
the same chance of being selected as do numbers between them.  Problem
noted by Greg Stark; fix by Alexey Klyukin.

Modified Files:
--
pgsql/contrib/pgbench:
pgbench.c (r1.75 -> r1.76)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pgbench/pgbench.c?r1=1.75&r2=1.76)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Reduce memory consumption during VACUUM of large relations, by

2008-03-09 Thread Tom Lane
Log Message:
---
Reduce memory consumption during VACUUM of large relations, by using
FSMPageData (6 bytes) instead of PageFreeSpaceInfo (8 or 16 bytes)
for the temporary array of page-free-space information.

Itagaki Takahiro

Modified Files:
--
pgsql/src/backend/commands:
vacuum.c (r1.365 -> r1.366)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuum.c?r1=1.365&r2=1.366)
vacuumlazy.c (r1.103 -> r1.104)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuumlazy.c?r1=1.103&r2=1.104)
pgsql/src/backend/storage/freespace:
freespace.c (r1.59 -> r1.60)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/freespace/freespace.c?r1=1.59&r2=1.60)
pgsql/src/include/storage:
freespace.h (r1.27 -> r1.28)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/storage/freespace.h?r1=1.27&r2=1.28)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Remove no-longer-used XLogCacheByte field of XLogCtl.

2008-03-09 Thread Tom Lane
Log Message:
---
Remove no-longer-used XLogCacheByte field of XLogCtl.
Itagaki Takahiro

Modified Files:
--
pgsql/src/backend/access/transam:
xlog.c (r1.293 -> r1.294)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xlog.c?r1=1.293&r2=1.294)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Add a CaseSensitive parameter to synonym dictionaries.

2008-03-09 Thread Tom Lane
Log Message:
---
Add a CaseSensitive parameter to synonym dictionaries.
Simon Riggs

Modified Files:
--
pgsql/doc/src/sgml:
textsearch.sgml (r1.41 -> r1.42)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/textsearch.sgml?r1=1.41&r2=1.42)
pgsql/src/backend/tsearch:
dict_synonym.c (r1.7 -> r1.8)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tsearch/dict_synonym.c?r1=1.7&r2=1.8)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Increase the default value of log_min_messages to WARNING, so

2008-03-09 Thread Tom Lane
Log Message:
---
Increase the default value of log_min_messages to WARNING, so that
NOTICE-grade messages are not logged by default.  Per pgsql-hackers
discussion back on 21-Nov-2007.

Modified Files:
--
pgsql/doc/src/sgml:
config.sgml (r1.168 -> r1.169)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.168&r2=1.169)
pgsql/src/backend/utils/misc:
guc.c (r1.434 -> r1.435)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c?r1=1.434&r2=1.435)
postgresql.conf.sample (r1.237 -> r1.238)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample?r1=1.237&r2=1.238)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers


[COMMITTERS] pgsql: Throw an error for negative LIMIT or OFFSET values, instead of

2008-03-09 Thread Tom Lane
Log Message:
---
Throw an error for negative LIMIT or OFFSET values, instead of silently
treating them as zero.  Simon Riggs

Modified Files:
--
pgsql/src/backend/executor:
nodeLimit.c (r1.33 -> r1.34)

(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeLimit.c?r1=1.33&r2=1.34)

-- 
Sent via pgsql-committers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers