Re: [HACKERS] Views update ?

2005-05-22 Thread Jaime Casanova
On 5/18/05, LAMBEAU Bernard <[EMAIL PROTECTED]> wrote: > Hi, > > On the TODO list, if found the following information : > Automatically create rules on views so they are updateable, per SQL99 > > Does anyone already work on such a tool inside PostgreSQL ? I'm > interessed by giving some contribut

[HACKERS] SO_KEEPALIVE

2005-05-22 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I understood that noone will add that option to pglib, is it correct ? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCkOh27Up

Re: [HACKERS] Views update ?

2005-05-22 Thread LAMBEAU Bernard
Hi. I have already read previous discussion in the archives about views update. I have also taked a look on the patch code. I will try it as soon as possible. P.S. I'm a beginner in the postgresql development and I have many things to learn before being able to give real help ... but I will try.

Re: [HACKERS] PseudoPartitioning and agregates

2005-05-22 Thread Tom Lane
Sokolov Yura <[EMAIL PROTECTED]> writes: > I think, postgres can perfoms aggregate on each table in union first, > and then merge results. I looked into this because it did not make a lot of sense to me. The aggregates you are testing with (count, sum, max) are all perfectly linear in the number