Re: Problem in "Set search path"

Поиск
Список
Период
Сортировка
От Kalai R
Тема Re: Problem in "Set search path"
Дата
Msg-id CAGxuanPUJePAdTPdMLdTnecidtoGy0+7CNuiiTLH_MEEO2nD6g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problem in "Set search path"  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Problem in "Set search path"
Re: Problem in "Set search path"
Список 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 по дате отправления:

Предыдущее
От: Michael Orlitzky
Дата:
Сообщение: Re: State of the art re: group default privileges
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Problem in "Set search path"