Re: Patch to fix search_path defencies with pg_bench

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Patch to fix search_path defencies with pg_bench
Дата
Msg-id 27748.1241643897@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Patch to fix search_path defencies with pg_bench  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
> On Wed, 2009-05-06 at 17:42 -0300, Dickson S. Guedes wrote:
>> But, there is the possibility that someone are using an automated script
>> that could be broken by this change? 

> Only if the role pgbench is using as an explicit search_path set.

Even then, it's not a problem from the point of view of pgbench ---
the tables will still get created and used correctly.  The only problem
shows up if someone is ignoring the existing warning in the docs and
running pgbench in a database that has application tables named accounts
&etc.  If you're doing that you're at considerable risk anyway, no
matter *what* we do or don't do with pgbench's search path.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Dickson S. Guedes"
Дата:
Сообщение: Re: Patch to fix search_path defencies with pg_bench
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Patch to fix search_path defencies with pg_bench