[COMMITTERS] npgsql - Npgsql2: Support date extraction functions

Log Message: --- Support date extraction functions Modified Files: -- Npgsql2/src/Npgsql/SqlGenerators: SqlBaseGenerator.cs (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/SqlGenerators/SqlBaseGenerator.cs.diff?r1=1.4&r

[COMMITTERS] pgsql: Add a comment explaining one of the ways that pgbench fails to

Log Message: --- Add a comment explaining one of the ways that pgbench fails to fully comply with TPC-B. Per Itagaki Takahiro and discussion of bug#3681. Modified Files: -- pgsql/contrib/pgbench: pgbench.c (r1.76 -> r1.77) (http://anoncvs.postgresql.org/cv

[COMMITTERS] pgsql: Add URL for: * Improve speed with indexes For large table

Log Message: --- Add URL for: * Improve speed with indexes For large table adjustments during VACUUM FULL, it is faster to cluster or reindex rather than update the index. Also, index updates can bloat the index. > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00307.p

[COMMITTERS] pgsql: Add: > > * Allow domains to be cast > >

Log Message: --- Add: > > * Allow domains to be cast > > http://archives.postgresql.org/pgsql-hackers/2003-06/msg01206.php > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00289.php Modified Files: -- pgsql/doc: TODO (r1.2315 -> r1.2316) (ht

[COMMITTERS] pgsql: Add: > > * Consider simplifying how memory context resets

Log Message: --- Add: > > * Consider simplifying how memory context resets handle child contexts > > http://archives.postgresql.org/pgsql-patches/2007-08/msg00067.php Modified Files: -- pgsql/doc: TODO (r1.2314 -> r1.2315) (http://anoncvs.postgresql.or

[COMMITTERS] pgsql: Add URL for: >

Log Message: --- Add URL for: > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00082.php Modified Files: -- pgsql/doc: TODO (r1.2313 -> r1.2314) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2313&r2=1.2314) pgsql/doc/src/FAQ:

[COMMITTERS] pgsql: Add URL for: * Consider increasing NUM_CLOG_BUFFERS >

Log Message: --- Add URL for: * Consider increasing NUM_CLOG_BUFFERS > http://archives.postgresql.org/pgsql-performance/2007-08/msg00024.php Modified Files: -- pgsql/doc: TODO (r1.2312 -> r1.2313) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO

[COMMITTERS] pgsql: Add URL for: * Consider increasing NUM_CLOG_BUFFERS > >

Log Message: --- Add URL for: * Consider increasing NUM_CLOG_BUFFERS > > http://archives.postgresql.org/pgsql-hackers/2007-08/msg00030.php > Modified Files: -- pgsql/doc: TODO (r1.2311 -> r1.2312) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO

[COMMITTERS] pgsql: Prevent psql \copy from accepting multiple string parameters,

Log Message: --- Prevent psql \copy from accepting multiple string parameters, e.g. test=> \copy billing_data from ../BillingSamplePricerFile.csv with csv header quote as '"' null as 'abc' null as '123' \copy: parse error at "null" Per report from Stephen Frost

[COMMITTERS] pgsql: Update TODO: o Allow COPY in CSV mode to control whether

Log Message: --- Update TODO: o Allow COPY in CSV mode to control whether a quoted zero-length string is treated as NULL Currently this is always treated as a zero-length string, which generates an error when loading into an integer column Modified F

[COMMITTERS] pgsql: add to TODO COPY: > > o Allow COPY in CSV mode to control

Log Message: --- add to TODO COPY: > > o Allow COPY in CSV mode to control whether "" is treated as NULL > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00905.php Modified Files: -- pgsql/doc: TODO (r1.2309 -> r1.2310) (http://a

[COMMITTERS] pgsql: Add to pl/pgsql: > > o Improve logic of determining if an

Log Message: --- Add to pl/pgsql: > > o Improve logic of determining if an identifier is a a > variable or column name > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00436.php Modified Files: -- pgsql/doc: TODO (r1.2308 -> r1.23

[COMMITTERS] pgsql: Add: > > * Add automated check for invalid C++ source code

Log Message: --- Add: > > * Add automated check for invalid C++ source code constructs > > http://archives.postgresql.org/pgsql-patches/2007-07/msg00056.php Modified Files: -- pgsql/doc: TODO (r1.2307 -> r1.2308) (http://anoncvs.postgresql.org/cvsweb.c

[COMMITTERS] pgsql: Add: > * Research use of signals and sleep wake ups > >

Log Message: --- Add: > * Research use of signals and sleep wake ups > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg3.php Modified Files: -- pgsql/doc: TODO (r1.2306 -> r1.2307) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r

[COMMITTERS] pgsql: Add: * Test to see if calling PreallocXlogFiles() from the

Log Message: --- Add: * Test to see if calling PreallocXlogFiles() from the background writer will help with WAL segment creation latency http://archives.postgresql.org/pgsql-patches/2007-06/msg00340.php Modified Files: -- pgsql/doc: TODO (r1.2305 -> r1.2306)

[COMMITTERS] pgsql: < * Consider adding buffers the BGW finds reusable to the free

Log Message: --- < * Consider adding buffers the BGW finds reusable to the free list > * Consider adding buffers the background writer finds reusable to the > free list > > * Consider wither increasing BM_MAX_USAGE_COUNT improves performance > > http://archives.postgresql.org/pgsql-

[COMMITTERS] pgsql: Add URL for: * Reduce storage space for small NUMERICs >

Log Message: --- Add URL for: * Reduce storage space for small NUMERICs > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00715.php Modified Files: -- pgsql/doc: TODO (r1.2303 -> r1.2304) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?

[COMMITTERS] pgsql: Add: > > * Change memory allocation for multi-byte functions so

Log Message: --- Add: > > * Change memory allocation for multi-byte functions so memory is > allocated inside conversion functions > > Currently we preallocate memory based on worst-case usage. Modified Files: -- pgsql/doc: TODO (r1.2299 -> r1.2300)

[COMMITTERS] pgsql: Make TransactionIdIsInProgress check transam.c's single-item XID

Log Message: --- Make TransactionIdIsInProgress check transam.c's single-item XID status cache before it goes groveling through the ProcArray. In situations where the same recently-committed transaction ID is checked repeatedly by tqual.c, this saves a lot of shared-memory searches. And i

[COMMITTERS] pgsql: Add: > o Consider normalizing fractions in postgresql.conf,

Log Message: --- Add: > o Consider normalizing fractions in postgresql.conf, perhaps > using '%' > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00550.php Modified Files: -- pgsql/doc: TODO (r1.2302 -> r1.2303) (http://an

[COMMITTERS] pgsql: Add: > > * Prefix command-line utilities like createuser with

Log Message: --- Add: > > * Prefix command-line utilities like createuser with 'pg_' > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00025.php Modified Files: -- pgsql/doc: TODO (r1.2300 -> r1.2301) (http://anoncvs.postgresql.org/cvsweb.cgi

[COMMITTERS] pgsql: Add: > * Consider sorting writes during checkpoint > >

Log Message: --- Add: > * Consider sorting writes during checkpoint > > http://archives.postgresql.org/pgsql-hackers/2007-06/msg00541.php Modified Files: -- pgsql/doc: TODO (r1.2301 -> r1.2302) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1

[COMMITTERS] pgsql: Add another URL for: * Consider increasing the number of default

Log Message: --- Add another URL for: * Consider increasing the number of default statistics target, and reduce statistics target overhead Also consider having a larger statistics target for indexed columns and expression indexes < > http://archives.postgresql.org/pgsql-general/2

[COMMITTERS] pgsql: Add URL for: * Consider increasing the number of default

Log Message: --- Add URL for: * Consider increasing the number of default statistics target, and reduce statistics target overhead Also consider having a larger statistics target for indexed columns and expression indexes > http://archives.postgresql.org/pgsql-general/2007-05/msg0

[COMMITTERS] pgsql: Add: > > * Consider increasing the number of default statistics

Log Message: --- Add: > > * Consider increasing the number of default statistics target, and > reduce statistics target overhead > > Also consider having a larger statistics target for indexed columns > and expression indexes Modified Files: -- pgsql/doc: T

[COMMITTERS] pgsql: Add: > > * Consider using a hash for joining to a large IN

Log Message: --- Add: > > * Consider using a hash for joining to a large IN (VALUES ...) list > > http://archives.postgresql.org/pgsql-hackers/2007-05/msg00450.php Modified Files: -- pgsql/doc: TODO (r1.2295 -> r1.2296) (http://anoncvs.postgresql.org/c

[COMMITTERS] pgsql: Add for VACUUM: > > * Consider a more compact data

Log Message: --- Add for VACUUM: > > * Consider a more compact data representation for dead tuples > > http://archives.postgresql.org/pgsql-patches/2007-05/msg00143.php Modified Files: -- pgsql/doc: TODO (r1.2294 -> r1.2295) (http://anoncvs.postgresql.

[COMMITTERS] pgsql: Add URL for: * Fix problem when multiple subtransactions of the

Log Message: --- Add URL for: * Fix problem when multiple subtransactions of the same outer transaction hold different types of locks, and one subtransaction aborts > http://archives.postgresql.org/pgsql-hackers/2007-05/msg00773.php Modified Files: -- pgsql/doc:

[COMMITTERS] pgsql: Add: > > * Add temporal versions of generate_series() > >

Log Message: --- Add: > > * Add temporal versions of generate_series() > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg01180.php Modified Files: -- pgsql/doc: TODO (r1.2292 -> r1.2293) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TOD

[COMMITTERS] prefix - prefix: First steps at implementing a prefix_range datatype

Log Message: --- First steps at implementing a prefix_range datatype Modified Files: -- prefix: prefix.c (r1.13 -> r1.14) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/prefix/prefix/prefix.c.diff?r1=1.13&r2=1.14) prefix.sql.in (r1.2 -> r1.3)

[COMMITTERS] npgsql - Npgsql2: Silly typo!

Log Message: --- Silly typo! Modified Files: -- Npgsql2/src/Npgsql: NpgsqlConnection.cs (r1.17 -> r1.18) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/NpgsqlConnection.cs.diff?r1=1.17&r2=1.18) -- Sent via pgsql-committers mailing

[COMMITTERS] pgsql: Add for pl/pgsql: o Review handling of MOVE and FETCH

Log Message: --- Add for pl/pgsql: o Review handling of MOVE and FETCH http://archives.postgresql.org/pgsql-patches/2007-04/msg00527.php Modified Files: -- pgsql/doc: TODO (r1.2291 -> r1.2292) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc

[COMMITTERS] pgsql: Add: > o Prevent pg_dump/pg_restore from being affected by >

Log Message: --- Add: > o Prevent pg_dump/pg_restore from being affected by > statement_timeout > > Using psql to restore a pg_dump dump is also affected. Modified Files: -- pgsql/doc: TODO (r1.2290 -> r1.2291) (http://anoncvs.postgr

[COMMITTERS] npgsql - Npgsql2: Redo merge.

Log Message: --- Redo merge. Modified Files: -- Npgsql2/testsuite/noninteractive/NUnit20: App.config (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/testsuite/noninteractive/NUnit20/App.config.diff?r1=1.2&r2=1.3) BaseClass

[COMMITTERS] pgsql: Add to documentation: + Setting

Log Message: --- Add to documentation: + Setting statement_timeout in + postgresql.conf is not recommended because it + affects all sessions. Backpatch to 8.3.X. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.172 -> r1.173)

[COMMITTERS] pgsql: Add to documentation: + Setting

Log Message: --- Add to documentation: + Setting statement_timeout in + postgresql.conf is not recommended because it + affects all sessions. Backpatch to 8.3.X. Tags: REL8_3_STABLE Modified Files: -- pgsql/doc/src/sgml: config.sgml (

[COMMITTERS] npgsql - Npgsql2: Redo merge.

Log Message: --- Redo merge. Modified Files: -- Npgsql2/src: .cvsignore (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/.cvsignore.diff?r1=1.2&r2=1.3) Npgsql.csproj (r1.10 -> r1.11) (http://cvs.pgfoundry.org/c

[COMMITTERS] pgsql: Add: > * Allow statistics last vacuum/analyze execution times to

Log Message: --- Add: > * Allow statistics last vacuum/analyze execution times to be displayed > without requiring stats_row_level to be enabled Modified Files: -- pgsql/doc: TODO (r1.2289 -> r1.2290) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/T

[COMMITTERS] pgsql: Back out doc addition that statement_timeout affects autovacuum.

Log Message: --- Back out doc addition that statement_timeout affects autovacuum. Tags: REL8_3_STABLE Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.164.2.2 -> r1.164.2.3) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgm

[COMMITTERS] pgsql: Back out doc addition that statement_timeout affects autovacuum.

Log Message: --- Back out doc addition that statement_timeout affects autovacuum. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.171 -> r1.172) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml?r1=1.171&r2=1.172) -- Sent via

[COMMITTERS] pgsql: Remove item, per Alvaro: < < o Set up autovacuum to ignore

Log Message: --- Remove item, per Alvaro: < < o Set up autovacuum to ignore statement_timeout set in < postgresql.conf < < http://archives.postgresql.org/pgsql-hackers/2007-03/msg01753.php Modified Files: -- pgsql/doc: TODO (r1.2288 -> r1.22

[COMMITTERS] pgsql: Add: > > * Consider adding buffers the BGW finds reusable to

Log Message: --- Add: > > * Consider adding buffers the BGW finds reusable to the free list > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00781.php > > * Automatically tune bgwriter_delay based on activity rather then using a > fixed interval > > http://archives.po

[COMMITTERS] pgsql: Document that statement_timeout is not recommended in

Log Message: --- Document that statement_timeout is not recommended in postgresql.conf because it affects all sessions, including autovacuum. Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.170 -> r1.171) (http://anoncvs.postgresql.org/cvsweb.cgi/pgs

[COMMITTERS] pgsql: Document that statement_timeout is not recommended in

Log Message: --- Document that statement_timeout is not recommended in postgresql.conf because it affects all sessions, including autovacuum. Tags: REL8_3_STABLE Modified Files: -- pgsql/doc/src/sgml: config.sgml (r1.164.2.1 -> r1.164.2.2) (http://ano

[COMMITTERS] pgsql: Add: > > o Set up autovacuum to ignore statement_timeout set

Log Message: --- Add: > > o Set up autovacuum to ignore statement_timeout set in > postgresql.conf > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01753.php Modified Files: -- pgsql/doc: TODO (r1.2286 -> r1.2287) (http:/

[COMMITTERS] pgsql: Add URL for: * Optimize referential integrity checks >

Log Message: --- Add URL for: * Optimize referential integrity checks > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00744.php Modified Files: -- pgsql/doc: TODO (r1.2285 -> r1.2286) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1

[COMMITTERS] pgsql: Add URL for: * Allow administrators to safely terminate

Log Message: --- Add URL for: * Allow administrators to safely terminate individual sessions either via an SQL function or SIGTERM > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00218.php Modified Files: -- pgsql/doc: TODO (r1.2284 -> r1.2285)

[COMMITTERS] npgsql - Npgsql2: Merge in RELEASE_2_0_ALPHA3

Log Message: --- Merge in RELEASE_2_0_ALPHA3 Modified Files: -- Npgsql2/src: Npgsql.build (r1.11 -> r1.12) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql.build.diff?r1=1.11&r2=1.12) Npgsql.csproj (r1.9 -> r1.10) (htt

[COMMITTERS] npgsql - Npgsql2: Check for NpgsqlInterval value in caching reader's

Log Message: --- Check for NpgsqlInterval value in caching reader's GetValue() Tags: RELEASE_2_0_ALPHA3 Modified Files: -- Npgsql2/src/Npgsql: NpgsqlDataReader.cs (r1.7.2.2 -> r1.7.2.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/N