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.stehule@gmail.com> wrote:
Hello
2013/3/21 Kalai R <softlinne.kv@gmail.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.
>