Re: 7.2 crash...

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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026