FAQ
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

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 9 of 9 | next ›
Discussion Overview
grouppgsql-bugs @
categoriespostgresql
postedMar 17, '02 at 12:56a
activeApr 16, '02 at 12:54a
posts9
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase