Re: [HACKERS] Re: [GENERAL] Query caching

2000-11-01 Thread Marc G. Fournier
On Wed, 1 Nov 2000, Karel Zak wrote: On Tue, 31 Oct 2000, The Hermit Hacker wrote: On Tue, 31 Oct 2000, Alfred Perlstein wrote: Karel Zak [EMAIL PROTECTED] Implemented stored proceedures for postgresql but still hasn't been approached to integrated them. someone has to

[HACKERS] list owner please help me get off the list.

2000-11-01 Thread Oelkers, Phil
tried the normal ways but your pos list software won't let me off. Help Please. -Original Message- From: Thomas Lockhart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 01, 2000 9:21 AM To: Lamar Owen; Hackers List; [EMAIL PROTECTED] Subject: [HACKERS] New RPMs for RedHat and

RE: [HACKERS] list owner please help me get off the list.

2000-11-01 Thread Jones, Colin
Title: RE: [HACKERS] list owner please help me get off the list. I want off this list immediately!!! If I am not off by the end of the day, I will go directly to the top! Thanks! -Original Message- From: Oelkers, Phil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 01,

RE: [HACKERS] WAL: postmaster won't start

2000-11-01 Thread Mikheev, Vadim
Did you turn XLOG_DEBUG off? With XLOG_DEBUG on there should be lines in log like REDO @ 0/434100; LSN 0/434252: . before control would reach btree_redo... Ok, anyway btree_xlog_delete is fixed. Thanks, Tatsuo! And please try again -:) Vadim It seems postmaster won't restart under

[HACKERS] status applications

2000-11-01 Thread Martin A. Marques
Are there any status and mode applications for postgres? I mean, an application that will tell me the status of the server at the moment, and an app to start and stop postgres. Does postgres have "administration mode" like a mode to make backups on, without threads connected? Thanks!!! --

[HACKERS] create function

2000-11-01 Thread Pam Withnall
I have installed plpgsql procedural language ok, I could not get any functions to work. I tried the most simple function as documented: CREATE FUNCTION sptest3 (int4) RETURNS int4 AS 'BEGIN RETURN $1+1; END;' LANGUAGE 'plpgsql'; When i call the function from sql

Re: [HACKERS] create function

2000-11-01 Thread Stephan Szabo
What version are you using? On a 7.0.2 freebsd machine, I cut and paste the below function and query and had no problems. Stephan Szabo [EMAIL PROTECTED] On Thu, 2 Nov 2000, Pam Withnall wrote: I have installed plpgsql procedural language ok, I could not get any functions to work. I

[HACKERS] More cvs branch problems (fwd)

2000-11-01 Thread Bruce Momjian
I have received no replies to this question, so I am assuming there is no way to do this in CVS. I will dump out the branch logs in date order and just grab the post-7.0.2 stuff. I will look at cvs2cl for 7.1. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

[HACKERS] How to check that I am in transaction inside backend

2000-11-01 Thread Denis Perchine
Hello, Having some expirience with catching errors with BLOBs, I realised, that it is really hard to understand that you forget to enclose BLOB operations in transaction... I would like to add a check for each BLOB operation which will check whether we are in transaction, and if not it will

RE: [HACKERS] list owner please help me get off the list.

2000-11-01 Thread The Hermit Hacker
ya know, I always love seeing email's like this ... what time do you consider to be the end of the day? and going directly to the top means talking to ... wow, me. and its the end of my day here, and I don't have you off yet, so now you are in a pickle, no? :) On Wed, 1 Nov 2000, Jones,

[HACKERS] New RPMs for RedHat and Mandrake

2000-11-01 Thread Thomas Lockhart
I've posted RPMs built for Mandrake at ftp://ftp.postgresql.org/pub/binary/Mandrake-7.1/{RPMS,SRPMS} which are exact copies of the RedHat RPMs (with the version changed from "21" to "21mdk") recently posted by Lamar Owens at ftp://ftp.postgresql.org/pub/binary/RedHat-6.x/{RPMS,SRPMS} I've