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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
