Re: search_path improvements - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: search_path improvements
Date
Msg-id 20090601185731.GF5716@alvh.no-ip.org
Whole thread Raw
In response to Re: search_path improvements  (Josh Berkus <josh@agliodbs.com>)
Responses Re: search_path improvements  (Greg Stark <stark@enterprisedb.com>)
List 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 by date:

Previous
From: Greg Stark
Date:
Subject: Re: User-facing aspects of serializable transactions
Next
From: Greg Stark
Date:
Subject: Re: search_path improvements