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