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

From Kalai R
Subject Problem in "Set search path"
Date
Msg-id CAGxuanOqm90PmnjeJPntjr=_fTJD5i3cpWX=3F1YHA8G9XcnnQ@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


---------- Forwarded message ----------
From: Kalai R <softlinne.kv@gmail.com>
Date: Fri, Mar 22, 2013 at 9:36 AM
Subject: Re: [GENERAL] Problem in "Set search path"
To: Alban Hertroys <haramrae@gmail.com>


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


pgsql-general by date:

Previous
From: Roberto Scattini
Date:
Subject: Re: streaming replication question
Next
From: "Umashanker, Srividhya"
Date:
Subject: Alphanumeric natural order sorting : need generic solution