From: | Kalai R <softlinne(dot)kv(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem in "Set search path" |
Date: | 2013-03-22 04:07:12 |
Message-ID: | CAGxuanOqm90PmnjeJPntjr=_fTJD5i3cpWX=3F1YHA8G9XcnnQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
---------- Forwarded message ----------
From: Kalai R <softlinne(dot)kv(at)gmail(dot)com>
Date: Fri, Mar 22, 2013 at 9:36 AM
Subject: Re: [GENERAL] Problem in "Set search path"
To: Alban Hertroys <haramrae(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Umashanker, Srividhya | 2013-03-22 07:40:19 | Alphanumeric natural order sorting : need generic solution |
Previous Message | Roberto Scattini | 2013-03-22 03:27:09 | Re: streaming replication question |