[COMMITTERS] pgsql: Update wording: < o Allow pre/data/post files when dumping a

2008-03-24 Thread Bruce Momjian
Log Message: --- Update wording: < o Allow pre/data/post files when dumping a single object, for < performance reasons > o Allow pre/data/post files when schema and data are dumped > separately, for performance reasons Modified Files: -- pgsql/d

[COMMITTERS] pgsql: Add to TODO: > * Improve reporting of UNION type mismatches > >

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > * Improve reporting of UNION type mismatches > > http://archives.postgresql.org/pgsql-hackers/2007-04/msg00944.php > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00597.php Modified Files: -- pgsql/doc: TODO (r1.2371 -

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

2008-03-24 Thread Bruce Momjian
Log Message: --- Add URL: * Allow statistics last vacuum/analyze execution times to be displayed without requiring stats_row_level to be enabled > > http://archives.postgresql.org/pgsql-docs/2007-04/msg00028.php > Modified Files: -- pgsql/doc: TODO (r1.2372 -

[COMMITTERS] pgsql: Add to TODO: > > * SMP scalability improvements > >

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * SMP scalability improvements > > http://archives.postgresql.org/pgsql-hackers/2007-07/msg00439.php Modified Files: -- pgsql/doc: TODO (r1.2373 -> r1.2374) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1

[COMMITTERS] pgsql: Add URL to: * SMP scalability improvements >

2008-03-24 Thread Bruce Momjian
Log Message: --- Add URL to: * SMP scalability improvements > http://archives.postgresql.org/pgsql-hackers/2008-03/msg00361.php Modified Files: -- pgsql/doc: TODO (r1.2374 -> r1.2375) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2374&r2

[COMMITTERS] pgsql: Add URL for: * SMP scalability improvements >

2008-03-24 Thread Bruce Momjian
Log Message: --- Add URL for: * SMP scalability improvements > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00206.php Modified Files: -- pgsql/doc: TODO (r1.2375 -> r1.2376) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r1=1.2375&r

[COMMITTERS] pgsql: Add a new ereport auxiliary function errdetail_log(), which works

2008-03-24 Thread Tom Lane
Log Message: --- Add a new ereport auxiliary function errdetail_log(), which works the same as errdetail except the string goes only to the server log, replacing the normal errdetail there. This provides a reasonably clean way of dealing with error details that are too security-sensitive o

[COMMITTERS] pgsql: Adjust the recent patch for reporting of deadlocked queries so

2008-03-24 Thread Tom Lane
Log Message: --- Adjust the recent patch for reporting of deadlocked queries so that we report query texts only to the server log. This eliminates the issue of possible leaking of security-sensitive data in other sessions' queries. Since the log is presumed secure, we can now log the quer

[COMMITTERS] pgsql: Add to TODO: > > * Research reducing deTOASTing in more places

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Research reducing deTOASTing in more places > > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00895.php Modified Files: -- pgsql/doc: TODO (r1.2376 -> r1.2377) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsq

[COMMITTERS] pgsql: Fix various infelicities that have snuck into usage of

2008-03-24 Thread Tom Lane
Log Message: --- Fix various infelicities that have snuck into usage of errdetail() and friends. Avoid double translation of some messages, ensure other messages are exposed for translation (and make them follow the style guidelines), avoid unsafe passing of an unpredictable message text a

[COMMITTERS] pgsql: Fix various infelicities that have snuck into usage of

2008-03-24 Thread Tom Lane
Log Message: --- Fix various infelicities that have snuck into usage of errdetail() and friends. Avoid double translation of some messages, ensure other messages are exposed for translation (and make them follow the style guidelines), avoid unsafe passing of an unpredictable message text a

[COMMITTERS] pgsql: Use new errdetail_log() mechanism to provide a less klugy way of

2008-03-24 Thread Tom Lane
Log Message: --- Use new errdetail_log() mechanism to provide a less klugy way of reporting large numbers of dependencies on a role that couldn't be dropped. Per a comment from Alvaro. Modified Files: -- pgsql/src/backend/catalog: pg_shdepend.c (r1.24 -> r1.25)

[COMMITTERS] pgsql: When a relation has been proven empty by constraint exclusion,

2008-03-24 Thread Tom Lane
Log Message: --- When a relation has been proven empty by constraint exclusion, propagate that knowledge up through any joins it participates in. We were doing that already in some special cases but not in the general case. Also, defend against zero row estimates for the input relations i

[COMMITTERS] pgsql: When a relation has been proven empty by constraint exclusion,

2008-03-24 Thread Tom Lane
Log Message: --- When a relation has been proven empty by constraint exclusion, propagate that knowledge up through any joins it participates in. We were doing that already in some special cases but not in the general case. Also, defend against zero row estimates for the input relations i

[COMMITTERS] pgsql: Add to TODO: > > * Allow xml arrays to be cast to other data

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Allow xml arrays to be cast to other data types > > http://archives.postgresql.org/pgsql-hackers/2007-09/msg00981.php > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00231.php > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00

[COMMITTERS] pgsql: Add to TODO: > > * Fix regular expression bug when using

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Fix regular expression bug when using complex back-references > > http://archives.postgresql.org/pgsql-bugs/2007-10/msg0.php Modified Files: -- pgsql/doc: TODO (r1.2378 -> r1.2379) (http://anoncvs.postgresql.org/

[COMMITTERS] pgsql: Add to TODO: > > * Create three versions of libpgport to

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Create three versions of libpgport to simplify client code > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00154.php > Modified Files: -- pgsql/doc: TODO (r1.2379 -> r1.2380) (http://anoncvs.postgresql.or

[COMMITTERS] pgsql: Add to TODO: > * Remove old-style routines for manipulating

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > * Remove old-style routines for manipulating tuples > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00851.php Modified Files: -- pgsql/doc: TODO (r1.2380 -> r1.2381) (http://anoncvs.postgresql.org/cvsweb.cgi/p

[COMMITTERS] pgsql: Add to TODO: > > * Have /contrib/dblink reuse unnamed

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Have /contrib/dblink reuse unnamed connections > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg00895.php Modified Files: -- pgsql/doc: TODO (r1.2381 -> r1.2382) (http://anoncvs.postgresql.org/cvsweb.cgi/p

[COMMITTERS] pgsql: Add: > o Prevent concurrent CREATE TABLE table1 from sometimes

2008-03-24 Thread Bruce Momjian
Log Message: --- Add: > o Prevent concurrent CREATE TABLE table1 from sometimes returning > a cryptic error message > > http://archives.postgresql.org/pgsql-bugs/2007-10/msg00169.php Modified Files: -- pgsql/doc: TODO (r1.2382 -> r1.2383)

[COMMITTERS] pgsql: Add to TODO: > > * Be more aggressive about creating WAL files

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Be more aggressive about creating WAL files > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg01325.php Modified Files: -- pgsql/doc: TODO (r1.2383 -> r1.2384) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsq

[COMMITTERS] pgsql: Add to TODO: > > * Have resource managers report the duration

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Have resource managers report the duration of their status changes > > http://archives.postgresql.org/pgsql-hackers/2007-10/msg01468.php Modified Files: -- pgsql/doc: TODO (r1.2384 -> r1.2385) (http://anoncvs.postgre

[COMMITTERS] pgsql: Add to TODO: > > * Move pgfoundry's xlogdump to /contrib and

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Move pgfoundry's xlogdump to /contrib and have it rely more closely > on the WAL backend code > > http://archives.postgresql.org/pgsql-hackers/2007-11/msg00035.php > Modified Files: -- pgsql/doc: TODO (r1.2385 -> r1.2386)

[COMMITTERS] pgsql: Add to TODO: > > * Consider sorting entries before inserting

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Consider sorting entries before inserting into btree index > > http://archives.postgresql.org/pgsql-general/2008-01/msg01010.php Modified Files: -- pgsql/doc: TODO (r1.2387 -> r1.2388) (http://anoncvs.postgresql.org/

[COMMITTERS] pgsql: Add to TODO: > > * Improve detection of shared memory segments

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Improve detection of shared memory segments being used by other > FreeBSD jails > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00656.php Modified Files: -- pgsql/doc: TODO (r1.2386 -> r1.2387) (http://

[COMMITTERS] pgsql: Add to TODO: > > o Fix port/rint.c to be spec-compliant > >

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > o Fix port/rint.c to be spec-compliant > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00808.php Modified Files: -- pgsql/doc: TODO (r1.2388 -> r1.2389) (http://anoncvs.postgresql.org/cvsweb.cgi

[COMMITTERS] pgsql: Add to psql TODO: > > o Improve display if enums > >

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to psql TODO: > > o Improve display if enums > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00826.php > > Modified Files: -- pgsql/doc: TODO (r1.2389 -> r1.2390) (http://anoncvs.postgresql.org/cvsweb.cgi/p

[COMMITTERS] pgsql: Add to TODO: > * Detect deadlocks involving

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > * Detect deadlocks involving LockBufferForCleanup() > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00873.php Modified Files: -- pgsql/doc: TODO (r1.2390 -> r1.2391) (http://anoncvs.postgresql.org/cvsweb.cgi/p

[COMMITTERS] pgsql: Add to TODO: > > * Add more cross-data-type operators > >

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Add more cross-data-type operators > > http://archives.postgresql.org/pgsql-bugs/2008-01/msg00189.php Modified Files: -- pgsql/doc: TODO (r1.2391 -> r1.2392) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/TODO?r

Re: [COMMITTERS] pgsql: Add to TODO: > > * Add more cross-data-type operators > >

2008-03-24 Thread Bruce Momjian
Who is this 'momjian' who keeps spamming the lists. ;-) --- Bruce Momjian wrote: > Log Message: > --- > Add to TODO: > > > > > * Add more cross-data-type operators > > > > http://archives.postgresql.org/pgsql-b

[COMMITTERS] pgsql: Add to pl/pgsql TODO: > > o Consider invalidating the cache or

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to pl/pgsql TODO: > > o Consider invalidating the cache or keeping seperate cached > copies when search_path changes > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg01009.php Modified Files: -- pgsql/doc: TOD

[COMMITTERS] pgsql: Add to TODO: > > * Add SQL-standard array_agg() and unnest()

2008-03-24 Thread Bruce Momjian
Log Message: --- Add to TODO: > > * Add SQL-standard array_agg() and unnest() array functions > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg01017.php > Modified Files: -- pgsql/doc: TODO (r1.2393 -> r1.2394) (http://anoncvs.postgresql.org