PgSql

Time travel on the buildfarm
Tom Lane wrote: It is currently 22:21:59 EST here. At 21:50 I committed a fix to copydir.c that cleaned up a couple of thinkos by Greg, including a misspelling that had been making all the builds fail for several hours. I went to see if any of the buildfarm had gone green yet, and indeed half a doz... 22 Feb 2010 09:37

A thought on Index Organized Tables
Gokulakannan Somasundaram wrote: Hi, As you all know, Index Organized tables are a way by which we can automatically cluster the data based on the primary key. While i was thinking about an implementation for postgres, it looks like an impossible with the current ideologies. In an IOT, if a record ge... 2 Mar 2010 04:36

[COMMITTERS] pgsql: Oops, don't forget to rewind the directory before scanning it to
Fujii Masao <masao.fujii(a)gmail.com> writes: + Free(xldir); s/Free/FreeDir ? Yeah, that too. I think it's all good now, but please test. One thing I was wondering was whether the stat-wrong-file problem could explain the buildfarm failures that we thought were evidence of a portability issue. I was te... 22 Feb 2010 04:09

[HACKERS] Time travel on the buildfarm
It is currently 22:21:59 EST here. At 21:50 I committed a fix to copydir.c that cleaned up a couple of thinkos by Greg, including a misspelling that had been making all the builds fail for several hours. I went to see if any of the buildfarm had gone green yet, and indeed half a dozen members had --- but they are... 21 Feb 2010 22:43

[HACKERS] A thought on Index Organized Tables
Hi, As you all know, Index Organized tables are a way by which we can automatically cluster the data based on the primary key. While i was thinking about an implementation for postgres, it looks like an impossible with the current ideologies. In an IOT, if a record gets updated, we need to mark the old row as ... 21 Feb 2010 14:52

[HACKERS] WAL-support for Pluggable Indexes
We've just rejected Knn-gist indexes as "not enough time for 9.0", which is a considerable disappointment for many people. We already have a pluggable index API, but not one that supports recoverability. It is a simple patch to add recoverability to the index API, if we have the will to do so. Let's add t... 21 Feb 2010 13:45

[HACKERS] getting to beta
Now that PostgreSQL 9.0 alpha4 is bundled (though apparently not quite out the door yet), it seems like a good time to think about what we'll need to do to get to beta. Any thoughts? http://wiki.postgresql.org/wiki/PostgreSQL_8.5_Open_Items currently lists no open items, and the Hot Standby TODO page to which it... 21 Feb 2010 07:04

[HACKERS] Plans for 9.1, Grouping Sets, disabling multiqueries, contrib module for string, plpgpsm, preload dictionaries
Hello, * Now I am working on migration of plpgpsm to plpgsql 9.0 base. I hope so I understand SQL/PSM well so I am able to write production quality implementation. If you like, I can integrate it to core. It can share about 40-50% code with plpgpsm. The behave of plpgpsm is same as plpgsql - without some plpgsql... 21 Feb 2010 05:59

libpq PGresult object and encoding
Jeff Davis wrote: libpq has a PQclientEncoding() function that takes a connection object. However, the client encoding is, in some cases, a property of the result object. For instance, if your client_encoding changes, but you keep the result object around, you have no way to determine later what encodi... 21 Feb 2010 04:55

Using views for row-level access control isleaky
Simon Riggs wrote: On Fri, 2009-10-23 at 10:04 -0400, Tom Lane wrote: Simon Riggs <simon(a)2ndQuadrant.com> writes: On Fri, 2009-10-23 at 19:38 +0900, KaiGai Kohei wrote: Sorry, what is happen if function is marked as "plan security"? I was suggesting an intelligent default by which we... 20 Feb 2010 16:53