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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
