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