Problem in "Set search path"

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

In response to

Responses

Browse pgsql-general by date

  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