On Sun, 2009-09-13 at 19:38 +0200, manaus wrote:
> If I set search_path to one of the schemas, I can use psql without
> writing the qualified names.
> In my application instead the server returns error if I dont use select
> * from myschema.mytable.
> Is this fixable?
There are several ways to deal with this.
1. To solve the problem for the current instance, do:
SET search_path TO schema1, schema2, ... ;
from you application as required.
2. For a permanent solution for that user only, do:
ALTER USER <username> SET search_path TO schema1, schema2, ... ;
for the username that your application connects as. The new settings
will take effect on the next login. There is no need to stop the
database server to make these changes.
In response to
pgsql-novice by date
|Next:||From: Harshad RJ||Date: 2009-09-14 04:34:22|
|Subject: Re: Reason for PG being seemingly I/O bound?|
|Previous:||From: raghu ram||Date: 2009-09-14 02:32:07|
|Subject: Re: qualified names|