Re: [GENERAL] Creating a read/write virtual table?

2010-04-12 Thread Ben Martin
On Mon, 2010-04-12 at 13:15 +0800, Craig Ringer wrote: > On 12/04/10 11:34, Ben Martin wrote: > > >In my SQLite vtable both of the above restrictions don't apply. To > > mitigate (1) I was hopeful that there was a way to get the connection to > > PG on the serv

[GENERAL] Creating a read/write virtual table?

2010-04-11 Thread Ben Martin
Hi, I'm the author of the libferris virtual filesystem. Last year I created the ability to expose a ferris filesystem as a virtual table in SQLite [1] and would like to do much the same for PostgreSQL if possible. I was digging into where to get the whole libferris-as-vtable thing to happen wi

[GENERAL] Custom GIST getting ERROR: too many LWLocks taken

2005-11-19 Thread Ben Martin
Hi, Perhaps this post is better suited to another PG mailing list? If this is the cast then apologies up front :/ I've been playing around with improving some of the GiST code in PG 8.1 to better take advantage of domain knowledge where I am applying it. I am now getting "ERROR: too many LWLo

[GENERAL] C function taking a relation and returning a similar relation.

2005-01-03 Thread Ben Martin
Hi, Please CC me as I'm not on the list. I'm trying to write a closed frequent itemset data mining custom function for postgresql. The optimal interface for this function would be something like the following: CREATE OR REPLACE FUNCTION cfi( relation, integer ) RETURNS SETOF record AS 'dmf