Re: "SET search_path" clause ignored during function creation

Поиск
Список
Период
Сортировка
Искать
От
Takahiro Itagaki
Тема
Re: "SET search_path" clause ignored during function creation
Дата
в 03:33:59
Msg-id
20100510153419.9C58.52131E4D@oss.ntt.co.jp
Ответ на
Список
Дерево обсуждения
"SET search_path" clause ignored during function creation Erwin Brandstetter <brsaweda@gmail.com>
Re: "SET search_path" clause ignored during function creation Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: "SET search_path" clause ignored during function creation Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] "SET search_path" clause ignored during function creation Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>

Erwin Brandstetter  wrote:

> Function bodies are checked using the _current_ search_path instead of
> the search_path supplied by the "SET search_path" clause.
> 
> Proposed solution: Function bodies should be checked with the
> search_path provided by "SET search_path" an _not_ with the current
> search path at the time pof creation.

Thanks for the report!  Please check whether the attached patch
is the correct fix. An additional regression test is included.

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center

В списке pgsql-bugs по дате отправления
От: Peter Eisentraut
Дата:
FAQ