PgSql

Posting to hackers and patches lists
Folks, can we avoid posting an email to both hackers and patches lists? I understand why people do it, but it is best avoided, I think. If you feel the need to keep patch discussion on hackers, please post just the patch to patches and a summary to hackers. Or better yet, have a URL to the patch in an email to... 7 May 2008 15:04

Behaviour of MERGE with complex Rules
It seems there is strange behaviour coming from trying to apply complex Rules to the MERGE statement. My proposal from here is to allow MERGE to work with Rules, but only when the Rules are equivalent to simply updatable views. This would restrict MERGE somewhat, yet be entirely compatible with SQL Standard b... 7 May 2008 10:08

Testing pg_terminate_backend()
Magnus, others, how is the SIGTERM testing going? --------------------------------------------------------------------------- Bruce Momjian wrote: bruce wrote: Tom Lane wrote: Bruce Momjian <bruce(a)momjian.us> writes: Tom Lane wrote: The closest thing I can think of to an automa... 7 May 2008 10:58

encoding problems
On Wed, Mar 12, 2008 at 4:35 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: Martijn van Oosterhout <kleptog(a)svana.org> writes: The other alternative is to convert tabs to spaces on output. Can't remember why we didn't do that. Yeah. The idea I had was to invent a parameter specifying the number of s... 7 May 2008 05:53

alter + preserving dependencies
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, but adding a column to a view o... 7 May 2008 14:14

ecpg localization
On Fri, May 02, 2008 at 07:19:00PM -0400, Tom Lane wrote: Ultimately Michael's opinion is the one that matters most for ecpg stuff, anyway. Michael? Sorry for the late reply, real life constraints. I talked to Peter about the patched before he sent out his first email. In fact I agree with both of you, as s... 6 May 2008 23:28

Patch to update libpqxx's homepage in README
Magnus Hagander wrote: On Wed, Mar 05, 2008 at 12:04:30PM -0500, Bruce Momjian wrote: Gurjeet Singh wrote: libpqxx seems to have moved around quite a bit. The attached patch corrects libpqxx's homepage. Thanks, patch applied and back-patched to 8.3.X. Do we really need to keep th... 6 May 2008 23:28

psql \pset pager
Tom Lane wrote: Bruce Momjian <bruce(a)momjian.us> writes: So, I think the answer is that we have the current behavior because of backward compatibility. Perhaps we should be more strict in ParseVariableBool(), perhaps only allowing true/false and on/off. If we're going to change it, we should m... 6 May 2008 23:28

Exposing quals
Folks, I'd like to make it possible to see qualifiers from inside functions in PostgreSQL. For my particular case, and for dblink, it would allow user-space code to some remove bottlenecks which make currently make inter-DBMS communication extremely inefficient. The current code returns one (potentially) big ... 6 May 2008 22:25

Proposal of SE-PostgreSQL patches
On Tue, May 06, 2008 at 02:56:41PM -0400, Tom Lane wrote: AFAICS the only thing left that really needs to be discussed more during this commit-fest is the business about whether it's sane to be trying to apply selinux restrictions in simple_heap_update and friends. I don't have any opinion about the pat... 7 May 2008 14:14