| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com> |
| Cc: | pgadmin-support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Missing schema name |
| Date: | 2011-08-11 21:01:13 |
| Message-ID: | 1313096474.6322.26.camel@laptop |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2011-08-11 21:05:08 | Re: Timing out. |
| Previous Message | Guillaume Lelarge | 2011-08-11 20:19:58 | Re: pgAdmin III 3-1.14.0-beta3 crash |