Re: Problem in "Set search path"

On 21 March 2013 16:59, Kalai R <softlinne(dot)kv(at)gmail(dot)com> wrote:

> 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.
>

Is that the same connection object in ,NET or the same connection to a
connection pool or the same database connection? That's not necessarily the
same.

Do you still have this problem if you set the search_path at the start of
your transaction?

Did you know you can set a search_path on user (role) objects and on
database objects in the database? That might just take out your need to
specify it in your ,NET application.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.