Daisuke Maki wrote:
Hi,
First, apologies if my question is a bit off-course. Please feel free to
direct me to a different mailing list if not appropriate.
I'm currently trying to embed Senna full text search engine
(http://qwik.jp/senna/) into postgres. I'm trying to achieve this by
My read is such that he is using Senna as follows (where external means outside of PostgreSQL):1. Create external FTI2. BEGIN TRANS3a. Insert record into PostgreSQL3b. Insert record into Senna4. Commit
His problem is that the PostgreSQL record (3a) *could* be rolled-back after he adds them to the
Hi,
First, apologies if my question is a bit off-course. Please feel free to
direct me to a different mailing list if not appropriate.
I'm currently trying to embed Senna full text search engine
(http://qwik.jp/senna/) into postgres. I'm trying to achieve this by
using triggers (implemented in
Daisuke,A patch was done for replication hooks which implements
global database-level triggers for connection startup and shutdown, and
transaction begin, commit, and rollback; they may help you out in this
situation.
http://gorda.di.uminho.pt/community/pgsqlhooks/-Jonah
On 1/23/06, Daisuke Maki
On Mon, Jan 23, 2006 at 06:35:18PM +0900, Daisuke Maki wrote:
A quick scan of the docs and the source code tree seems to indicate that
there is no such thing as a rollback trigger, short of hacking it.
Now, I'm wondering:
1. Is there a rollback/commit trigger? If not, is it planned to be
Hello Jonah,
Sorry for hi-jacking the thread (not my intent, I assure you)
however, is there any chance Jonah of expanding your work to include
'on user login/logout' ?
As an aside, a trigger on rollback seems... unlikely (at least to
my mind). What is the functionality if your rollback
Hey Stef,It's not my patch, it's Alfrânio Correia Júnior's. I don't think it would be too difficult to add a hook for authentication, but that is off-topic. If you would like to discuss it further, please create a new topic for it.
As for a rollback trigger, I don't really see too much of a use
Jim C. Nasby [EMAIL PROTECTED] writes:
On Mon, Jan 23, 2006 at 06:35:18PM +0900, Daisuke Maki wrote:
A quick scan of the docs and the source code tree seems to indicate that
there is no such thing as a rollback trigger, short of hacking it.
Now, I'm wondering:
1. Is there a
On Mon, January 23, 2006 16:35, Daisuke Maki wrote:
I'm currently trying to embed Senna full text search engine
(http://qwik.jp/senna/) into postgres. I'm trying to achieve this by
using triggers (implemented in C) to cause an update to senna's index at
various points.
This seemed to work