Re: Problem in "Set search path"

On Thu, Mar 21, 2013 at 11:33 PM, Kalai R <softlinne.kv@gmail.com> wrote:
> Hi,
>
>    I am using postgresql 9.0.3.  In my application I change often schema
> name using set search path. Some times schema name set correctly.  But some
> time it does not set correctly and it takes the schema previously I set.  Is
> any possibilities to happen like this?

If you roll back the transaction in which you set it, it isn't set,
but if you commit that transaction, it'll stay set for future
transactions. At least, that's been my experience.

ChrisA