Re: Problem in "Set search path" - Mailing list pgsql-general

From Kalai R
Subject Re: Problem in "Set search path"
Date
Msg-id CAGxuanPUJePAdTPdMLdTnecidtoGy0+7CNuiiTLH_MEEO2nD6g@mail.gmail.com
Whole thread Raw
In response to Re: Problem in "Set search path"  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Problem in "Set search path"
Re: Problem in "Set search path"
List pgsql-general
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.
>

pgsql-general by date:

Previous
From: Michael Orlitzky
Date:
Subject: Re: State of the art re: group default privileges
Next
From: Adrian Klaver
Date:
Subject: Re: Problem in "Set search path"