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