Re: Patch to fix search_path defencies with pg_bench

Greg Smith <gsmith@gregsmith.com> writes:
> I once did some pgbench testing on a system that included a real 
> "accounts" table in a named schema.  "pgbench -i" will execute "drop table 
> if exists accounts".  It had already accidentally wiped out the copy of 
> the accounts table on the system during an earlier test, before the schema 
> policy was in place, leaving everyone wary of it.

Seems like the right policy for that is "run pgbench in its own
database".  I doubt that either adding or removing the "set search_path"
command changes the risk of trouble very much.
        regards, tom lane