[HACKERS] Vacuum from within a function crashes backend

2002-09-28 Thread Magnus Naeslund(f)
Hello, I did a vacuum from within a function, and it went sig11 on me. Is it illegal to do that? The function: drop function xorder1_cleanup(); create function xorder1_cleanup() RETURNS integer AS ' declare x record; c integer; begin c:=0; FOR x IN SELECT order_id,count(*) as cnt FROM

Re: [HACKERS] Vacuum from within a function crashes backend

2002-09-28 Thread Alvaro Herrera
Magnus Naeslund(f) dijo: Hello, I did a vacuum from within a function, and it went sig11 on me. Is it illegal to do that? Huh... what version is this? In current sources, VACUUM cannot be run inside a function (it will throw an ERROR). In 7.2[.1] I see there is no protection against

Re: [HACKERS] Vacuum from within a function crashes backend

2002-09-28 Thread Magnus Naeslund(f)
Alvaro Herrera [EMAIL PROTECTED] wrote: Magnus Naeslund(f) dijo: Hello, I did a vacuum from within a function, and it went sig11 on me. Is it illegal to do that? Huh... what version is this? In current sources, VACUUM cannot be run inside a function (it will throw an ERROR). In