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

From Pavel Stehule
Subject Re: Problem in "Set search path"
Date
Msg-id CAFj8pRAaDnC=Vuahpi-4XHi+Yzq5dMD8caY7Hn8pf6RNHv-haw@mail.gmail.com
Whole thread Raw
In response to Problem in "Set search path"  (Kalai R <softlinne.kv@gmail.com>)
Responses Re: Problem in "Set search path"
List pgsql-general
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: Chris Angelico
Date:
Subject: Re: Problem in "Set search path"
Next
From: Daniel Cristian Cruz
Date:
Subject: Re: Bad plan on a huge table query