Re: Problem in "Set search path"

Hi,
Thanks for ur suggestions. I create connection from my .net application
and set search path by single query. After set search path I call psql
function from my .net application using the same connection. In this case
some time search path set but some times not. I didn't use prepare
statement.
Regards
kalai
On Thu, Mar 21, 2013 at 6:09 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>wrote:

> Hello
>
> 2013/3/21 Kalai R <softlinne(dot)kv(at)gmail(dot)com>:
> > 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?
>
> yes, it is possible - if you use prepared statement.
>
> Regards
>
> Pavel Stehule
>
> > Thank You.
> >
>