Schema Search Path Problem - Mailing list pgsql-general

From Kalai R
Subject Schema Search Path Problem
Date
Msg-id CAGxuanNn48faWq+J2+dgJn-oF3XxuQa6+Gh-ws1g=81RLEP11w@mail.gmail.com
Whole thread Raw
Responses Re: Schema Search Path Problem
List pgsql-general
Hi,

I am developing .Net application using PSQL. I am using npgsql to connect PSQL database. In single database I have more than one schemas. After I connect database I set search path using "Set Searchpath command" for the required schema. It works perfectly.

But after sometime, I need to change schema. so I set again search path   using "Set Searchpath command" . Now if I execute a single query the changed search path works correctly. But if I execute a pl/sql function written in background the changed search path does not work.

Help me to solve this issue.

Thanks.

pgsql-general by date:

Previous
From: Jesse Long
Date:
Subject: Re: Incorrect index being used
Next
From: Jesse Long
Date:
Subject: Re: Incorrect index being used