Re: [Proposal] vacuumdb --schema only - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: [Proposal] vacuumdb --schema only
Date
Msg-id 20220304105639.GJ27651@telsasoft.com
Whole thread Raw
In response to [Proposal] vacuumdb --schema only  (Gilles Darold <gilles@migops.com>)
Responses Re: [Proposal] vacuumdb --schema only  (Gilles Darold <gilles@migops.com>)
Re: [Proposal] vacuumdb --schema only  (Gilles Darold <gilles@migops.com>)
List pgsql-hackers
On Fri, Mar 04, 2022 at 10:11:28AM +0100, Gilles Darold wrote:
> The attached patch implements that. Option -n | --schema can be used
> multiple time and can not be used together with options -a or -t.

Yes, thanks.

I suggest there should also be an --exclude-schema.

> I do not propose to extend the VACUUM and ANALYZE commands because their
> current syntax doesn't allow me to see an easy way to do that

I think this would be easy with the parenthesized syntax.
I'm not suggesting to do it there, though.

> +    /*
> +     * When filtereing on schema name, filter by table is not allowed.
> +     * The schema name can already be set in a fqdn table name.

set *to*

-- 
Justin



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Regression tests failures on Windows Server 2019 - on master at commit # d816f366b
Next
From: Dinesh Chemuduru
Date:
Subject: Re: [Proposal] vacuumdb --schema only