PgSql

Proposal: Add JSON support
On Sun, Mar 28, 2010 at 4:48 PM, Joseph Adams <joeyadams3.14159(a)gmail.com> wrote: I'm wondering whether the internal representation of JSON should be plain JSON text, or some binary code that's easier to traverse and whatnot.  For the sake of code size, just keeping it in text is probably best. +1 for t... 6 Apr 2010 20:58

[HACKERS] Proposal: Add JSON support
I introduced myself in the thread "Proposal: access control jails (and introduction as aspiring GSoC student)", and we discussed jails and session-local variables. But, as Robert Haas suggested, implementing variable support in the backend would probably be way too ambitious a project for a newbie like me. I deci... 28 Mar 2010 17:52

[HACKERS] Alpha release this week?
All, We've got two locations and some individuals signed up for a test-fest this weekend. Would it be possible to do an alpha release this week? It would really help to be testing later code than Alpha4. -- -- Josh Berkus PostgreSQL Expe... 28 Mar 2010 16:46

plpgsql's case bug?
On Sat, Mar 27, 2010 at 10:08 PM, Jaime Casanova <jcasanov(a)systemguards.com.ec> wrote: Hi, [...] this is based on General Rules case 1 of chapter 13.6 (case statement) but i don't think that behaviour is the meaning of that Rule. Even if it is, the exception should be: "case not found for case state... 28 Mar 2010 02:32

pgsql: Augment WAL records for btree deletewith GetOldestXmin() to
On Sat, 2010-03-27 at 19:15 +0000, Greg Stark wrote: On Sat, Mar 27, 2010 at 10:10 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: It appears that in practice many of the index items point to heap items that are LP_DEAD. So for the purposes of accessing a heap tuple's xmin, then we're both right. To th... 28 Mar 2010 05:43

pgsql: Augment WAL records for btree delete with GetOldestXmin() to
On Sat, Mar 27, 2010 at 10:10 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: It appears that in practice many of the index items point to heap items that are LP_DEAD. So for the purposes of accessing a heap tuple's xmin, then we're both right. To the current purpose the tuple has been removed, though you ar... 27 Mar 2010 18:50

changes to documentation build
On Sat, Mar 27, 2010 at 5:23 AM, Peter Eisentraut <peter_e(a)gmx.net> wrote: Per thread starting here http://archives.postgresql.org/pgsql-bugs/2010-03/msg00049.php and ending here http://archives.postgresql.org/pgsql-bugs/2010-03/msg00110.php and earlier discussions of similar nature, here is ... 27 Mar 2010 17:40

[HACKERS] changes to documentation build
Per thread starting here http://archives.postgresql.org/pgsql-bugs/2010-03/msg00049.php and ending here http://archives.postgresql.org/pgsql-bugs/2010-03/msg00110.php and earlier discussions of similar nature, here is a patch that separates the documentation build and installation into separate top-level ... 27 Mar 2010 09:36

[HACKERS] More idle thoughts
The Linux kernel had a big push to reduce latency, and one of the tricks they did was they replaced the usual interrupt points with a call which noted how long it had been since the last interrupt point. It occurs to me we could do the same for CHECK_FOR_INTERRUPTS() by conditionally having it call a function which... 26 Mar 2010 15:36

Postgres 9.0 Alpha, GIN indexes, and intarray contrib module, and SQL Functions
Mike Lewis <mikelikespie(a)gmail.com> writes: I'm using the intarray contrib module[1] gin indexes on arrays (obviously) with postgres 9 alpha 4. I am querying to see the existence of an element. When I do the query normally, it performs as I'd expect (very fast). The explain plan looks like what I'd expec... 26 Mar 2010 11:58