Re: Missing schema name

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