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

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 i

Re: [HACKERS] Re: [CORE] 7.0.3 Release date?

Yes, sorry about the delay. Also, I will send a report to core about the summit. > > sounds great, then hopefully we get v7.0.3 out early next week :) thanks > ... > > > On Wed, 1 Nov 2000, Bruce Momjian wrote: > > > I am back, and will resolve the cvs and brand 7.0.3 tomorrow. > > > > >

[HACKERS] More cvs branch problems (fwd)

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 PROTEC

[HACKERS] Re: [CORE] 7.0.3 Release date?

sounds great, then hopefully we get v7.0.3 out early next week :) thanks ... On Wed, 1 Nov 2000, Bruce Momjian wrote: > I am back, and will resolve the cvs and brand 7.0.3 tomorrow. > > > > > > this week, once I hear from bruce that he's ready ... last I heard, he was > > back with his old

Re: [HACKERS] Re: [GENERAL] 7.0 vs. 7.1 (was: latest version?)

> > Well, we certainly don't want to make changes that make things harder or > > more confusing for non-RPM installs. How are they affected here? > > They wouldn't be. Peter E has seemingly done an excellent job in this > area. I say seemingly because I haven't built an RPM from the 7.1 branch

Re: [HACKERS] create function

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 tr

[HACKERS] create function

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] WAL: postmaster won't start

> > No. I just started up postmaster with -S (logs are forwarded to syslog > > in my settings). > > Oh. XLOG_DEBUG calls write(2,) - too big output for syslog I think. I see. Next time I will turn off -S so that I could send you XLOG_DEBUG outputs... -- Tatsuo Ishii

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

> > 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... > > No. I just started up postmaster with -S (logs are forwarded to syslog > in my settings). Oh. XLOG_DEB

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

> 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... No. I just started up postmaster with -S (logs are forwarded to syslog in my settings). > Ok, anyway btree_xlog_delete

[HACKERS] status applications

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!!! -- "

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

even better, of course, is the fact that you aren't even on this list: Majordomo>unsubscribe pgsql-hackers [EMAIL PROTECTED] Cannot unsubscribe [EMAIL PROTECTED]: no matching addresses. On Wed, 1 Nov 2000, Jones, Colin wrote: > I want off this list immediately!!! If I am not o

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

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, Colin

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

Get me off this list too The F interface does not work! [EMAIL PROTECTED] and [EMAIL PROTECTED] Franck Martin Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] Web sit

RE: [HACKERS] New RPMs for RedHat and Mandrake

In Mandrake 7.2 Postgresql 7.0 is included... Check it out on www.rpmfind.net Franck Martin Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] Web site: http://www.sopac.org/ This e-m

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

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 W

[HACKERS]

set digest

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

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,

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

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 Mandrak

[HACKERS] Fwd: Re: PSQL, Mosix is unuseful

Hello everyone, no hope to use PostgreSQL + Mosix, because PostgreSQL uses shared memory, as such it's not suitable for migration. Mosix isn't able now to give us a single system image, where a cluster of machine acts as a single transparent machine. I'm trying DIPC+GFS to do this, i've patch

[HACKERS] New RPMs for RedHat and Mandrake

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

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

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. > > > > some

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

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 approach him to integrate them? *raised eyebr

Re: [HACKERS] Query cache import?

On Tue, 31 Oct 2000, Alfred Perlstein wrote: > * Karel Zak <[EMAIL PROTECTED]> [001031 16:18] wrote: > > > > On Tue, 31 Oct 2000, Alfred Perlstein wrote: > > > > All what will doing next time not depend on me, *it's on code developers*.