Re: Vacuum from within a function crashes backend

From: Alvaro Herrera <alvherre(at)atentus(dot)com>
To: "Magnus Naeslund(f)" <mag(at)fbab(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Vacuum from within a function crashes backend
Date: 2002-09-28 15:09:24
Message-ID: Pine.LNX.4.44.0209281104490.11131-100000@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 this.

Maybe the fix for this should be backported to 7.2 also.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"Hay quien adquiere la mala costumbre de ser infeliz" (M. A. Evans)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Copeland 2002-09-28 15:44:02 Re: How to REINDEX in high volume environments?
Previous Message Tom Lane 2002-09-28 15:05:45 Re: making use of large TLB pages