[COMMITTERS] pgsnmpd - pgsnmpd: Finish system tables, fix psqlCatalogTables typo

2007-09-10 Thread User Eggyknap
Log Message: --- Finish system tables, fix psqlCatalogTables typo Modified Files: -- pgsnmpd/pgsql_mib_pieces: pg_operator.mib (r1.1 -> r1.2) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgsnmpd/pgsnmpd/pgsql_mib_pieces/pg_operator.mib.diff?r1=1.1&r2=1.2)

[COMMITTERS] dbsamples - pagila: Update pagila schema for 8.3.

2007-09-10 Thread User Xzilla
Log Message: --- Update pagila schema for 8.3. Convert fulltext search to use built in functionality. Switch film rating column to use an enum type rather than text with constraints. Modified Files: -- pagila: README (r1.4 -> r1.5) (http://cvs.pgfoundry.o

[COMMITTERS] pgsql: Rename recently-added pg_stat_activity column from txn_start to

2007-09-10 Thread Tom Lane
Log Message: --- Rename recently-added pg_stat_activity column from txn_start to xact_start, for consistency with other column names such as in pg_stat_database. Modified Files: -- pgsql/src/backend/access/transam: xact.c (r1.250 -> r1.251) (http://develope

Re: [COMMITTERS] pgsql: Release the exclusive lock on the table early after truncating it

2007-09-10 Thread Alvaro Herrera
Tom Lane wrote: > [EMAIL PROTECTED] (Alvaro Herrera) writes: > > Release the exclusive lock on the table early after truncating it in lazy > > vacuum, instead of waiting till commit. > > Weren't you going to disable vacuum_delay in that stretch of code, too? > > BTW, not sure if you realized this

Re: [COMMITTERS] pgsql: Release the exclusive lock on the table early after truncating it

2007-09-10 Thread Tom Lane
[EMAIL PROTECTED] (Alvaro Herrera) writes: > Release the exclusive lock on the table early after truncating it in lazy > vacuum, instead of waiting till commit. Weren't you going to disable vacuum_delay in that stretch of code, too? BTW, not sure if you realized this, but just deleting the vacuum

[COMMITTERS] pgsql: Arrange for SET LOCAL's effects to persist until the end of the

2007-09-10 Thread Tom Lane
Log Message: --- Arrange for SET LOCAL's effects to persist until the end of the current top transaction, unless rolled back or overridden by a SET clause for the same variable attached to a surrounding function call. Per discussion, these seem the best semantics. Note that this is an INC

[COMMITTERS] pgsql: Make CLUSTER and REINDEX silently skip remote temp tables in

2007-09-10 Thread Alvaro Herrera
Log Message: --- Make CLUSTER and REINDEX silently skip remote temp tables in their database-wide editions. Per report from bitsandbytes88 hotmail.com and subsequent discussion. Tags: REL8_2_STABLE Modified Files: -- pgsql/src/backend/commands: cluster.c (r1

[COMMITTERS] pgsql: Make CLUSTER and REINDEX silently skip remote temp tables in

2007-09-10 Thread Alvaro Herrera
Log Message: --- Make CLUSTER and REINDEX silently skip remote temp tables in their database-wide editions. Per report from bitsandbytes88 hotmail.com and subsequent discussion. Modified Files: -- pgsql/src/backend/commands: cluster.c (r1.162 -> r1.163) (

[COMMITTERS] malaga-tsearch - malaga-tsearch: Initial version.

2007-09-10 Thread User Hlinnaka
Log Message: --- Initial version. Added Files: --- malaga-tsearch: COPYING (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/malaga-tsearch/malaga-tsearch/COPYING?rev=1.1&content-type=text/x-cvsweb-markup) Makefile (r1.1) (http://cvs.pgfoundr

[COMMITTERS] pgsql: Release the exclusive lock on the table early after truncating it

2007-09-10 Thread Alvaro Herrera
Log Message: --- Release the exclusive lock on the table early after truncating it in lazy vacuum, instead of waiting till commit. Modified Files: -- pgsql/src/backend/commands: vacuumlazy.c (r1.92 -> r1.93) (http://developer.postgresql.org/cvsweb.cgi/pgsql

[COMMITTERS] pgsql: Heikki Linnakangas <[EMAIL PROTECTED]>: Add tsearch

2007-09-10 Thread Teodor Sigaev
Log Message: --- Heikki Linnakangas <[EMAIL PROTECTED]>: Add tsearch subdirectory is added to Makefile to allow compile custom tsearch dictionary as an external module. Modified Files: -- pgsql/src/include: Makefile (r1.21 -> r1.22) (http://developer.post

[COMMITTERS] pgsql: Fix recently introduced bugs about parsing ispell/hunspell files.

2007-09-10 Thread Teodor Sigaev
Log Message: --- Fix recently introduced bugs about parsing ispell/hunspell files. In most cases it cause because of unneeded lowercasing of flags. Per experiment with regression checks with ispell dictionary. Modified Files: -- pgsql/src/backend/tsearch: spell.c (

[COMMITTERS] pgsql: Remove the vacuum_delay_point call in count_nondeletable_pages,

2007-09-10 Thread Alvaro Herrera
Log Message: --- Remove the vacuum_delay_point call in count_nondeletable_pages, because we hold an exclusive lock on the table at this point, which we want to release as soon as possible. This is called in the phase of lazy vacuum where we truncate the empty pages at the end of the table.

[COMMITTERS] pgsql: Remove the vacuum_delay_point call in count_nondeletable_pages,

2007-09-10 Thread Alvaro Herrera
Log Message: --- Remove the vacuum_delay_point call in count_nondeletable_pages, because we hold an exclusive lock on the table at this point, which we want to release as soon as possible. This is called in the phase of lazy vacuum where we truncate the empty pages at the end of the table.

[COMMITTERS] pgsql: Remove the vacuum_delay_point call in count_nondeletable_pages,

2007-09-10 Thread Alvaro Herrera
Log Message: --- Remove the vacuum_delay_point call in count_nondeletable_pages, because we hold an exclusive lock on the table at this point, which we want to release as soon as possible. This is called in the phase of lazy vacuum where we truncate the empty pages at the end of the table.

[COMMITTERS] pgsql: Remove the vacuum_delay_point call in count_nondeletable_pages,

2007-09-10 Thread Alvaro Herrera
Log Message: --- Remove the vacuum_delay_point call in count_nondeletable_pages, because we hold an exclusive lock on the table at this point, which we want to release as soon as possible. This is called in the phase of lazy vacuum where we truncate the empty pages at the end of the table.

[COMMITTERS] pgsql: Fixes from Heikki Linnakangas <[EMAIL PROTECTED]>:

2007-09-10 Thread Teodor Sigaev
Log Message: --- Fixes from Heikki Linnakangas <[EMAIL PROTECTED]>: Apparently it's a bug I introduced when I refactored spell.c to use the readline function for reading and recoding the input file. I didn't notice that some calls to STRNCMP used the non-lowercased version of the input lin

[COMMITTERS] pgsql: Change void* opaque argument to Datum type, add argument's

2007-09-10 Thread Teodor Sigaev
Log Message: --- Change void* opaque argument to Datum type, add argument's name to PushFunction type definition. Per suggestion by Tome Lane <[EMAIL PROTECTED]> Modified Files: -- pgsql/src/backend/tsearch: to_tsany.c (r1.2 -> r1.3) (http://develope

[COMMITTERS] pgtray - pgtray: Added win32 installer, based on PgFoundry's setupkit.

2007-09-10 Thread User Andrei
Log Message: --- Added win32 installer, based on PgFoundry's setupkit. Added Files: --- pgtray/pgtray/installers/win32: Config.bat (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgtray/pgtray/pgtray/installers/win32/Config.bat?rev=1.1&content-type=text/x-c

[COMMITTERS] pgsql: Revert temporary patch that made synchronous_commit default to

2007-09-10 Thread Tom Lane
Log Message: --- Revert temporary patch that made synchronous_commit default to OFF. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.143 -> r1.144) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.143&r2=1.144) pgsq