---------- Forwarded message ----------
From: Kalai R <softlinne.kv@xxxxxxxxx>
Date: Fri, Mar 22, 2013 at 9:36 AM
Subject: Re: Problem in "Set search path"
To: Alban Hertroys <haramrae@xxxxxxxxx>
From: Kalai R <softlinne.kv@xxxxxxxxx>
Date: Fri, Mar 22, 2013 at 9:36 AM
Subject: Re: Problem in "Set search path"
To: Alban Hertroys <haramrae@xxxxxxxxx>
Hi,
Is that the same connection object in ,NET or the same connection to a connection pool or the same database connection? That's not necessarily the same.
I use the same npgsql connection object in .net
Might try temporarily turning up the logging in postgresql.conf to 'all' and see what is actually being done on the server.
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.
I try to find out my problem by your ideas. Thanks guys.Regards
Kalai
