[COMMITTERS] pgsql: Decouple the values of TOAST_TUPLE_THRESHOLD and

2007-04-02 Thread Tom Lane
Log Message: --- Decouple the values of TOAST_TUPLE_THRESHOLD and TOAST_MAX_CHUNK_SIZE. Add the latter to the values checked in pg_control, since it can't be changed without invalidating toast table content. This commit in itself shouldn't change any behavior, but it lays some necessary gr

[COMMITTERS] pgsql: Update: < * Add transaction_idle_timeout GUC so locks are not

2007-04-02 Thread Bruce Momjian
Log Message: --- Update: < * Add transaction_idle_timeout GUC so locks are not held for long > * Add idle_in_transaction_timeout GUC so locks are not held for long Modified Files: -- pgsql/doc: TODO (r1.2154 -> r1.2155) (http://developer.postgresql.org/cvs

[COMMITTERS] pgsql: Update: < * Add idle_timeout GUC so locks are not held for log

2007-04-02 Thread Bruce Momjian
Log Message: --- Update: < * Add idle_timeout GUC so locks are not held for log periods of time > * Add transaction_idle_timeout GUC so locks are not held for long > periods of time Modified Files: -- pgsql/doc: TODO (r1.2153 -> r1.2154) (http://develope

[COMMITTERS] pgsql: Add: > * Allow all data types to cast to and from TEXT > >

2007-04-02 Thread Bruce Momjian
Log Message: --- Add: > * Allow all data types to cast to and from TEXT > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00017.php > > Modified Files: -- pgsql/doc: TODO (r1.2152 -> r1.2153) (http://developer.postgresql.org/cvsweb.cgi/pgsql/

[COMMITTERS] pgsql: Add: > > * Add idle_timeout GUC so locks are not held for log

2007-04-02 Thread Bruce Momjian
Log Message: --- Add: > > * Add idle_timeout GUC so locks are not held for log periods of time Modified Files: -- pgsql/doc: TODO (r1.2151 -> r1.2152) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.2151&r2=1.2152) pgsql/doc/src/F

[COMMITTERS] pgsql: Add URL for: o Allow UPDATE tab SET ROW (col, ...) =

2007-04-02 Thread Bruce Momjian
Log Message: --- Add URL for: o Allow UPDATE tab SET ROW (col, ...) = (SELECT...) < > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00865.php Modified Files: -- pgsql/doc: TODO (r1.2150 -> r1.2151) (http://developer.postgresql.or

[COMMITTERS] pgsql: Add URL for: o Allow commenting of variables in

2007-04-02 Thread Bruce Momjian
Log Message: --- Add URL for: o Allow commenting of variables in postgresql.conf to restore them to defaults > http://archives.postgresql.org/pgsql-patches/2007-03/msg00180.php Modified Files: -- pgsql/doc: TODO (r1.2149 -> r1.2150)

[COMMITTERS] pgsql: Add URL for: o Allow a warm standby system to also

2007-04-02 Thread Bruce Momjian
Log Message: --- Add URL for: o Allow a warm standby system to also allow read-only statements [pitr] > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00050.php Modified Files: -- pgsql/doc: TODO (r1.2148 -> r1.2149)

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

2007-04-02 Thread Bruce Momjian
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-03/msg00024

[COMMITTERS] pgsql: Add: > o Have timestamp subtraction not call justify_hours()? >

2007-04-02 Thread Bruce Momjian
Log Message: --- Add: > o Have timestamp subtraction not call justify_hours()? > > http://archives.postgresql.org/pgsql-sql/2006-10/msg00059.php > < o Add overflow checking to timestamp and interval arithmetic > o Add overflow checking to timestamp and inter

[COMMITTERS] pgsql: Allow NOTIFY/LISTEN/UNLISTEN to only take relation names, not

2007-04-02 Thread Bruce Momjian
Log Message: --- Allow NOTIFY/LISTEN/UNLISTEN to only take relation names, not schema.relation, because the notify code only honors the relation name. schema.relation will now generate a syntax error. Modified Files: -- pgsql/src/backend/parser: gram.y (r2.585 -> r2

[COMMITTERS] pgsql: Check length of enum literals on definition and input to make

2007-04-02 Thread Andrew Dunstan
Log Message: --- Check length of enum literals on definition and input to make sure they will fit in a name field and not cause syscache errors. Modified Files: -- pgsql/src/backend/catalog: pg_enum.c (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.

[COMMITTERS] pgsql: Pl/python -> Pl/PythonU: < o Add table function support to

2007-04-02 Thread Bruce Momjian
Log Message: --- Pl/python -> Pl/PythonU: < o Add table function support to pltcl, plpython > o Add table function support to pltcl, plpythonu < o Add PL/Python tracebacks > o Add PL/PythonU tracebacks < o Allow PL/Pytho

[COMMITTERS] pgsql: Add: > * Fix to_date()-related functions to consistently issue

2007-04-02 Thread Bruce Momjian
Log Message: --- Add: > * Fix to_date()-related functions to consistently issue errors > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg00915.php > Modified Files: -- pgsql/doc: TODO (r1.2144 -> r1.2145) (http://developer.postgresql.org/cvswe

[COMMITTERS] pgsql: Add: > > o Allow PL/Python to return boolean rather than 1/0

2007-04-02 Thread Bruce Momjian
Log Message: --- Add: > > o Allow PL/Python to return boolean rather than 1/0 > > > http://archives.postgresql.org/pgsql-patches/2007-01/msg00596.php > Modified Files: -- pgsql/doc: TODO (r1.2143 -> r1.2144) (http://develop

[COMMITTERS] pgsql: Add item: > > * Consider reducing memory used for shared buffer

2007-04-02 Thread Bruce Momjian
Log Message: --- Add item: > > * Consider reducing memory used for shared buffer reference count > > http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php Modified Files: -- pgsql/doc: TODO (r1.2142 -> r1.2143) (http://developer.postgresql.

[COMMITTERS] pgsql: Add URL for: o Allow RETURN to return row or record functions

2007-04-02 Thread Bruce Momjian
Log Message: --- Add URL for: o Allow RETURN to return row or record functions > o Allow RETURN to return row or record functions > > http://archives.postgresql.org/pgsql-patches/2006-08/msg00397.php > > http://archives.postgresql.or

[COMMITTERS] pgsql: Fix check_sql_fn_retval to allow the case where a SQL function

2007-04-02 Thread Tom Lane
Log Message: --- Fix check_sql_fn_retval to allow the case where a SQL function declared to return void ends with a SELECT, if that SELECT has a single result that is also of type void. Without this, it's hard to write a void function that calls another void function. Per gripe from Peter

[COMMITTERS] pgsql: Fix check_sql_fn_retval to allow the case where a SQL function

2007-04-02 Thread Tom Lane
Log Message: --- Fix check_sql_fn_retval to allow the case where a SQL function declared to return void ends with a SELECT, if that SELECT has a single result that is also of type void. Without this, it's hard to write a void function that calls another void function. Per gripe from Peter

[COMMITTERS] pgsql: Fix check_sql_fn_retval to allow the case where a SQL function

2007-04-02 Thread Tom Lane
Log Message: --- Fix check_sql_fn_retval to allow the case where a SQL function declared to return void ends with a SELECT, if that SELECT has a single result that is also of type void. Without this, it's hard to write a void function that calls another void function. Per gripe from Peter

[COMMITTERS] pgsql: Fix check_sql_fn_retval to allow the case where a SQL function

2007-04-02 Thread Tom Lane
Log Message: --- Fix check_sql_fn_retval to allow the case where a SQL function declared to return void ends with a SELECT, if that SELECT has a single result that is also of type void. Without this, it's hard to write a void function that calls another void function. Per gripe from Peter

[COMMITTERS] pgsql: Done: < * Support a data type with specific enumerated values

2007-04-02 Thread Bruce Momjian
Log Message: --- Done: < * Support a data type with specific enumerated values (ENUM) < < http://archives.postgresql.org/pgsql-hackers/2006-08/msg00979.php < > * -Support a data type with specific enumerated values (ENUM) Modified Files: -- pgsql/doc: TODO (r1.

[COMMITTERS] pgsql: > o Add PQexecf() that allows complex parameter substitution >

2007-04-02 Thread Bruce Momjian
Log Message: --- > o Add PQexecf() that allows complex parameter substitution > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01803.php Modified Files: -- pgsql/doc: TODO (r1.2139 -> r1.2140) (http://developer.postgresql.org/cvswe

[COMMITTERS] pginstaller - pginst: Add new kerberos dependency.

2007-04-02 Thread User Dpage
Log Message: --- Add new kerberos dependency. Modified Files: -- pginst/wxs: pginst.wxs (r1.192 -> r1.193) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/wxs/pginst.wxs.diff?r1=1.192&r2=1.193) ---(end of broadcast)-

[COMMITTERS] pginstaller - pginst: Fix some more hard coded paths.

2007-04-02 Thread User Dpage
Log Message: --- Fix some more hard coded paths. Pull library dependencies from the build dep tree. Split per-machine config stuff into a seperate template file for customisation. Modified Files: -- pginst: pginst.proj (r1.1 -> r1.2) (http://cvs.pgfoundry.o

[COMMITTERS] pgsql: xcopy can only deal with forward-slashed paths when it's quoted -

2007-04-02 Thread Magnus Hagander
Log Message: --- xcopy can only deal with forward-slashed paths when it's quoted - needed for "vcregress check" to work. Per report from Dave Page. Modified Files: -- pgsql/src/tools/msvc: Install.pm (r1.6 -> r1.7) (http://developer.postgresql.org/cvsweb.cg

[COMMITTERS] pgsql: Fix caching of unsuccessful initialization of parser or

2007-04-02 Thread Teodor Sigaev
Log Message: --- Fix caching of unsuccessful initialization of parser or configuration. Per report from Listmail <[EMAIL PROTECTED]> Tags: REL7_4_STABLE Modified Files: -- pgsql/contrib/tsearch2: ts_cfg.c (r1.5.2.2 -> r1.5.2.3) (http://developer.postg

[COMMITTERS] pgsql: Fix caching of unsuccessful initialization of parser or

2007-04-02 Thread Teodor Sigaev
Log Message: --- Fix caching of unsuccessful initialization of parser or configuration. Per report from Listmail <[EMAIL PROTECTED]> Tags: REL8_0_STABLE Modified Files: -- pgsql/contrib/tsearch2: ts_cfg.c (r1.11.4.2 -> r1.11.4.3) (http://developer.pos

[COMMITTERS] pgsql: Fix caching of unsuccessful initialization of parser or

2007-04-02 Thread Teodor Sigaev
Log Message: --- Fix caching of unsuccessful initialization of parser or configuration. Per report from Listmail <[EMAIL PROTECTED]> Tags: REL8_1_STABLE Modified Files: -- pgsql/contrib/tsearch2: ts_cfg.c (r1.15 -> r1.15.2.1) (http://developer.postgre

[COMMITTERS] pgsql: Fix caching of unsuccessful initialization of parser or

2007-04-02 Thread Teodor Sigaev
Log Message: --- Fix caching of unsuccessful initialization of parser or configuration. Per report from Listmail <[EMAIL PROTECTED]> Tags: REL8_2_STABLE Modified Files: -- pgsql/contrib/tsearch2: ts_cfg.c (r1.21 -> r1.21.2.1) (http://developer.postgre

[COMMITTERS] pgsql: Fix caching of unsuccessful initialization of parser or

2007-04-02 Thread Teodor Sigaev
Log Message: --- Fix caching of unsuccessful initialization of parser or configuration. Per report from Listmail <[EMAIL PROTECTED]> Modified Files: -- pgsql/contrib/tsearch2: ts_cfg.c (r1.22 -> r1.23) (http://developer.postgresql.org/cvsweb.cgi/pgsql/contr

[COMMITTERS] python - fe: Move tests to GreenTrunk.

2007-04-02 Thread James William Pye
Log Message: --- Move tests to GreenTrunk. Modified Files: -- fe/test: tracenull.py (r1.15 -> r1.16) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/fe/test/tracenull.py.diff?r1=1.15&r2=1.16) Removed Files: - fe/test: cio.py

[COMMITTERS] python - ip: Relocate some Proboscis tests into more general GreenTrunk

2007-04-02 Thread James William Pye
Log Message: --- Relocate some Proboscis tests into more general GreenTrunk tests. Added Files: --- ip/src/test: perf_copy_io.py (r1.1) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/python/ip/src/test/perf_copy_io.py?rev=1.1&content-type=text/x-cvsweb-markup)