| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Greg Stark <stark(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: search_path improvements |
| Date: | 2009-06-01 18:57:32 |
| Message-ID: | 20090601185731.GF5716@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2009-06-01 19:03:43 | Re: pg_standby -l might destory the archived file |
| Previous Message | Greg Stark | 2009-06-01 18:57:12 | Re: User-facing aspects of serializable transactions |