Re: create one function to let other user execute vacuum command. got such an error. - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: create one function to let other user execute vacuum command. got such an error.
Date
Msg-id 1332917066.2249.2.camel@localhost.localdomain
Whole thread Raw
In response to create one function to let other user execute vacuum command. got such an error.  (leaf_yxj <leaf_yxj@163.com>)
Responses Re: create one function to let other user execute vacuum command. got such an error.  (Greg Jaskiewicz <gryzman@gmail.com>)
List pgsql-general
On Tue, 2012-03-27 at 18:51 -0700, leaf_yxj wrote:
> create one function to let other user execute vacuum command. got such an
> error. Please help. Thanks. Regards . Grace
>
> rrp=> create function vacuum_f ( tablename char(100))
>  Returns char(100) AS $$
> vacuum tablename;
> $$ Language plpgsql security definer;
> ERROR:  syntax error at or near "vacuum"
> LINE 3:   vacuum tablename;
>           ^
> rrp=>
>

Well, first, it doesn't follow PL/pgsql guidelines. You need at least a
BEGIN at the beginning of the function, and an END at the end.

But even with this, you cannot use VACUUM in a function. Don't remember
the reason why right now, but all you'll get is this error:

ERROR:  VACUUM cannot be executed from a function or multi-command
string


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


pgsql-general by date:

Previous
From: leaf_yxj
Date:
Subject: Re: postgresql commit.
Next
From: Greg Jaskiewicz
Date:
Subject: Re: create one function to let other user execute vacuum command. got such an error.