Re: vacuumdb and new VACUUM options - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: vacuumdb and new VACUUM options
Date
Msg-id CAD21AoAv2XZCbOWQd-YrGmY_ioe-XACEW44JuvTGdKLzCiUaBA@mail.gmail.com
Whole thread Raw
In response to Re: vacuumdb and new VACUUM options  (Andres Freund <andres@anarazel.de>)
Responses Re: vacuumdb and new VACUUM options  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
On Wed, May 15, 2019 at 11:45 AM Andres Freund <andres@anarazel.de> wrote:
>
> Hi,
>
> On 2019-05-15 11:36:52 +0900, Masahiko Sawada wrote:
> > I might be missing something but if the frontend code doesn't check
> > arguments and we let the backend parsing logic do all the work then it
> > allows user to execute an arbitrary SQL command via vacuumdb.
>
> But, so what? The user could just have used psql to do so?

Indeed. It shouldn't be a problem and we even now can do that by
specifying for example --table="t(c1);select 1" but doesn't work.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: vacuumdb and new VACUUM options
Next
From: Michael Paquier
Date:
Subject: wal_consistency_checking clean on HEAD (f4125278)