Re: - Mailing list pgsql-novice

From Tom Lane
Subject Re:
Date
Msg-id 20407.1135355339@sss.pgh.pa.us
Whole thread Raw
In response to  ("Lane Van Ingen" <lvaningen@esncc.com>)
List pgsql-novice
"Lane Van Ingen" <lvaningen@esncc.com> writes:
> Can anyone advise how to do this? I want to be able to fire off a VACUUM
> <tbl>
> command at my request.

You can't issue the VACUUM from inside a function, period.  It has to be
done from the client end, because it can't run inside a transaction.

            regards, tom lane

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re:
Next
From:
Date:
Subject: Re: 2 Questions