PgSql

Proposed Patch - LDAPS support for servers on port636 w/o TLS
Tom Lane wrote: stephen layland <steve(a)68k.org> writes: I've written a quick patch against the head branch (8.4DEV, but it also works with 8.1.3 sources) to fix LDAP authentication support to work with LDAPS servers that do not need start TLS. I'd be interested to hear your opinions on this. ... 6 May 2008 22:25

statement timeout vs dump/restore
Do we want the following: 1. pg_dump issues "set statement_timeout = 0;" to the database prior to taking its copy of data (yes/no/default-but-switchable) 2. pg_dump/pg_restore issue "set statement_timeout = 0;" in text mode output (yes/no/default-but-switchable) 3. pg_restor... 6 May 2008 23:28

[badalex@gmail.com: Re: [BUGS] Problem identifying constraints which should not be inherited]
"Alex Hunsaker" <badalex(a)gmail.com> writes: [ patch to fix behavior of inherited constraints ] Looking over this patch, I see that it introduces a syscache on pg_constraint (conrelid, conname), which requires a unique index underlying it. This is not workable because domain constraint entries in pg_constraint... 6 May 2008 23:28

alter + preserving dependencies
Andrew Dunstan wrote: I have a client who is looking for a way to be able to alter objects without having to recreate (say, from a dump) all the objects in a possibly large dependency tree rooted at the object. Of course, if the alteration invalidates the dependency, than this operation should fail, ... 6 May 2008 22:25

Query Hints? No thanks. Data hints?
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi -hackers, In another thread about "GUC parameter cursors_tuple_fraction", the debate seems to drift onto query hints. About which the consensus here is pretty clear and strong, no query hints in PostgreSQL, thanks, or we're never gonna have a perfect gene... 6 May 2008 23:28

Protection from SQL injection
* Thomas Mueller: What do you think about it? Do you think it makes sense to implement this security feature in PostgreSQL as well? Can't this be implemented in the client library, or a wrapper around it? A simple approximation would be to raise an error when you encounter a query string that isn't contain... 6 May 2008 23:28

Proposed Patch - LDAPS support for servers on port 636 w/o TLS
stephen layland <steve(a)68k.org> writes: I've written a quick patch against the head branch (8.4DEV, but it also works with 8.1.3 sources) to fix LDAP authentication support to work with LDAPS servers that do not need start TLS. I'd be interested to hear your opinions on this. Not being an LDAP user, I'... 6 May 2008 23:28

column level privileges
Greetings, This really probably should have gone to -hackers rather than just back to -patches, so here it is. Comments welcome. * Tom Lane (tgl(a)sss.pgh.pa.us) wrote: I'm not sure where we go from here. Your GSOC student has disappeared, right? Is anyone else willing to take up the patch and work on it?... 6 May 2008 22:25

"could not open relation 1663/16384/16584: Nosuch file or directory" in a specific combination of transactionswith temp tables
Added to TODO: * Allow prepared transactions with temporary tables created and dropped in the same transaction, and when an ON COMMIT DELETE ROWS temporary table is accessed http://archives.postgresql.org/pgsql-hackers/2008-03/msg00047.php -----------------------------------------------------------... 24 Apr 2008 15:03

Standard metadata queries
I've been chatting with the Trolltech folks about the implementation of the Qt wrapper around libpq, and the issue of how to properly do metadata queries came up. That is things like "What are the column names and types of the primary key of this table, and what index enforces it?" or "What are the names an... 24 Apr 2008 18:15