Skip site navigation (1) Skip section navigation (2)

Re: 7.2 crash...

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)zort(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 7.2 crash...
Date: 2002-04-16 00:54:26
Message-ID: 200204160054.g3G0sQG15840@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
I have applied a patch based on Tom's suggestion that will disable
VACUUM in a function in 7.3.

---------------------------------------------------------------------------

Rod Taylor wrote:
> 7.2 crashes with the below function:
> 
> CREATE OR REPLACE FUNCTION runMaintenance()
> RETURNS BOOL AS '
>   VACUUM;
>   SELECT TRUE;
> ' LANGUAGE sql;
> 
> I was going to toss a bunch of system maintenance stuff in a database
> function to make administration for those who administer the boxes
> (not me -- I just tell how).
> 
> Anyway, any crash is a bad crash I suppose.
> --
> Rod Taylor
> 
> Your eyes are weary from staring at the CRT. You feel sleepy. Notice
> how restful it is to watch the cursor blink. Close your eyes. The
> opinions stated above are yours. You cannot imagine why you ever felt
> otherwise.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-hackers by date

Next:From: Hiroshi InoueDate: 2002-04-16 00:55:29
Subject: Re: Operators and schemas
Previous:From: Bruce MomjianDate: 2002-04-16 00:47:39
Subject: Re: ANSI Compliant Inserts

pgsql-bugs by date

Next:From: Tatsuo IshiiDate: 2002-04-16 01:08:46
Subject: Re: oh, i don't know did it is a bug or not.
Previous:From: Nigel J. AndrewsDate: 2002-04-15 23:16:07
Subject: Re: Alter/update large tables - VERRRY annoying behaviour!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group