Re: [HACKERS] Need help in installing postgresql 8.1.2 on Windows

2006-01-23 Thread Gurjeet Singh
Hopefully your problem is solved by now; but if not, here's the link: do read the README expanded at the end of the file-list: http://www.postgresql.org/ftp/binary/v8.1.2/win32/ I could give you a long lecture on how to look for the things on your own a little bit before pestering these mailing

Re: [HACKERS] [PATCHES] postmaster/postgres merge for testing

2006-01-23 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Attached is a patch that merges postmaster and postgres into just a postmaster command. I had some second thoughts about this, specifically about which direction do we really want to go in. With this patch, it no longer really matters what the

Re: [HACKERS] [PATCHES] postmaster/postgres merge for testing

2006-01-23 Thread Andrew Dunstan
On Mon, 2006-01-23 at 11:13 -0500, Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: Attached is a patch that merges postmaster and postgres into just a postmaster command. I had some second thoughts about this, specifically about which direction do we really want to go in.

[HACKERS] ROLLBACK triggers?

2006-01-23 Thread Daisuke Maki
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

Re: [HACKERS] [PATCHES] postmaster/postgres merge for testing

2006-01-23 Thread Jim C. Nasby
On Mon, Jan 23, 2006 at 11:51:36AM -0500, Andrew Dunstan wrote: This is clearly better, IMNSHO. I did wonder about postgresqld or postgresd or some such - many server programs end in d or .d to distinguish them from client programs. But probably just postgres is best. Or postgresql if we want

Re: [HACKERS] ROLLBACK triggers?

2006-01-23 Thread Jonah H. Harris
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

Re: [HACKERS] ROLLBACK triggers?

2006-01-23 Thread Jim C. Nasby
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

Re: [HACKERS] ROLLBACK triggers?

2006-01-23 Thread Stef T
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

Re: [HACKERS] ROLLBACK triggers?

2006-01-23 Thread Jonah H. Harris
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

Re: [HACKERS] ROLLBACK triggers?

2006-01-23 Thread Greg Stark
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

Re: [HACKERS] Libpq COPY optimization

2006-01-23 Thread Bruce Momjian
Can I get an updated patch for this? --- Tom Lane wrote: Alon Goldshuv [EMAIL PROTECTED] writes: Please help me understand this better. It appears to me that when the client-backend pipe fills up, pqSendSome() consumes

[HACKERS] unsubscribe

2006-01-23 Thread Adnan HOTMAIL
unsubscribe

Re: [HACKERS] ROLLBACK triggers?

2006-01-23 Thread Jeroen T. Vermeulen
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

Re: [HACKERS] Libpq COPY optimization

2006-01-23 Thread Alon Goldshuv
I'll send it to -patches shortly Alon. On 1/23/06 10:20 PM, Bruce Momjian pgman@candle.pha.pa.us wrote: Can I get an updated patch for this? --- Tom Lane wrote: Alon Goldshuv [EMAIL PROTECTED] writes: Please

[HACKERS] Offer for PG Developers/Hackers

2006-01-23 Thread Tony Caduto
Hi, I want to give something back(I would give a donation but sales are poor :-( ,so I am offering to any verified Postgresql developer(by verified I mean your name shows up on this list a LOT ) a free copy of PG Lightning Admin. I know most of you guys don't use windows, but if you do your