Re: Missing schema name - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: Missing schema name
Date
Msg-id 1313096474.6322.26.camel@laptop
Whole thread Raw
In response to Missing schema name  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
Responses Re: Missing schema name
List pgadmin-support
On Thu, 2011-08-11 at 15:26 -0500, Little, Douglas wrote:
> That worked, but I'm confused why it worked.
> On the new machine, I'm using gpadmin which does have different search_path.  
> When I switch to my regular id, the schema name shows up. 
> 
> In pgadmin, is it even possible to change the search_path?
> 

Nope, I don't think you can.

> Seems like it should be a server/db option.
> 

Could be a a good way to fix this.

> Thanks. 
> --- old
> current_user=dlittle
> show search_path 
> "$user",public,pg_catalog,dba_work
> 
> -- new
> current_user=gpadmin
> dba_work, pg_catalog, public
> 
> 
> current_user=gpadmin
> "$user",public,pg_catalog,dba_work


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: pgAdmin III 3-1.14.0-beta3 crash
Next
From: Guillaume Lelarge
Date:
Subject: Re: Timing out.