Search Postgresql Archives

Re: Problem in "Set search path"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
Hello

2013/3/21 Kalai R <softlinne.kv@xxxxxxxxx>:
> 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.
>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux