Re: search_path improvements

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: search_path improvements
Дата
Msg-id 20090601185731.GF5716@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: search_path improvements  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: search_path improvements  (Greg Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Josh Berkus wrote:

>> Well I don't mind push but I still think pop is an error. What you
>> really want to do is restore it to the value you started with. You
>> don't want to remove the last element since that may not be the
>> element you added. Some function you called may have added an extra
>> element on the head.
>
> Yeah, "pop" is a misnomer; what I'd want is  
> search_path_del(search_path,'admin') ... that is, a way to remove a  
> specific schema from the list.

Except that "del" shouldn't delete if your "push" didn't add it because
it was already present.  So you actually want some sort of refcounting
there somehow.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: User-facing aspects of serializable transactions
Следующее
От: Greg Stark
Дата:
Сообщение: Re: search_path improvements