PgSql

MySQL-ism help patch for psql
On Tue, 2010-01-19 at 12:44 -0600, David Christensen wrote: Hey -hackers, I whipped up a quick patch for supporting some of the common mysql- based "meta" commands; this is different than some things which have been discussed in the past, in that it provides just a quick direction to the approp... 6 Feb 2010 07:29

Helping the CommitFest re PL/Perl changes
Tim Bunce wrote: What can I do to help the CommitFest, especially in relation to the PL/Perl changes? Tim. p.s. I've sent an email to the dbi-users and dbi-announce lists http://www.mail-archive.com/dbi-users(a)perl.org/msg32649.html in the hope of encouraging some more people to review and te... 20 Jan 2010 00:45

[HACKERS] Helping the CommitFest re PL/Perl changes
What can I do to help the CommitFest, especially in relation to the PL/Perl changes? Tim. p.s. I've sent an email to the dbi-users and dbi-announce lists http://www.mail-archive.com/dbi-users(a)perl.org/msg32649.html in the hope of encouraging some more people to review and test the patches, and hopefully contr... 19 Jan 2010 14:39

ECPG patch 4.1, out-of-scope cursor support in nativemode
Michael Meskes írta: Zoltan, while testing your patch I went through the test cases and found this in outofscope.pgc: + #include <inttypes.h> As we know by now this won't work. :-) Okay, I will fix it. :-) I forgot it's in there as well. Besides, would you mind simplif... 26 Jan 2010 05:27

[HACKERS] Bug ? different behaviour between 8.3 and 8.4 won IS NULL with subarrays of nulls
Hi, I found a difference of behaviour between 8.3 and 8.4 on IS NULL with multi-level arrays with NULL values. I looked at the Changelog between 8.3 and 8.4, but I didn't find something really clear about this. Is this a bug or a known issue or a normal, documented, difference of behaviour ? See the f... 19 Jan 2010 11:15

[HACKERS] create composite type error message
When you create a composite type that already exists, the error message you get is about 'relation "foo" already exists'. While true, this can be confusing, as you didn't plan to create a relation. Therefore, I propose that we insert a snippet of code that is already used by the other forms of type creation to ch... 18 Jan 2010 19:55

Build farm tweaks
Greg Sabino Mullane wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 I mentioned earlier that buildfarm member jaguar (that's the one that builds with CLOBBER_CACHE_ALWAYS) was showing suspicious intermittent failures. Tom, this brings up another question: is there any f... 18 Jan 2010 10:52

Streaming replication, and walsender during recovery
Fujii Masao <masao.fujii(a)gmail.com> writes: When I configured a cascaded standby (i.e, made the additional standby server connect to the standby), I got the following errors, and a cascaded standby didn't start replication. ERROR: timeline 0 of the primary does not match recovery target timeline 1 ... 16 Mar 2010 22:06

[HACKERS] Bloom filters bloom filters bloom filters
Another idea of how to make use of bloom filters: It should be possible to implement a gist opclass over a bloomfilter data type which implements the operation int membership in int[]. All you need is a function which takes an int[] and returns a bloom filter. Then your union operation is to just bitwise or the... 18 Jan 2010 08:38

[HACKERS] Bloom filters bloom filters
So the other thread on bloom filter indexes got a discussion going in real space about other neat things you can do with them and there were two that seemed useful for Postgres. We could efficiently get an fairly accurate estimate of the number of distinct values when doing analyze if we scan the entire table. I'... 18 Jan 2010 07:31