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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2002-04-16 01:08:46 | Re: oh, i don't know did it is a bug or not. |
Previous Message | Nigel J. Andrews | 2002-04-15 23:16:07 | Re: Alter/update large tables - VERRRY annoying behaviour! |
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2002-04-16 00:55:29 | Re: Operators and schemas |
Previous Message | Bruce Momjian | 2002-04-16 00:47:39 | Re: ANSI Compliant Inserts |