| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | "bdmytrak(at)eranet(dot)pl" <bdmytrak(at)eranet(dot)pl> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: ENUM type script in pgAdmin 1.14.0 |
| Date: | 2011-09-26 19:11:00 |
| Message-ID: | 1317064260.2085.6.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On Mon, 2011-09-26 at 09:33 +0200, bdmytrak(at)eranet(dot)pl wrote:
> My search_path is set to "$user", pg_temp
I tried, and it works for me. I see the public schema in the definition
of my type.
Best thing to do is open the query tool, and launch "show search_path".
And I'm pretty sure you'll find the public schema in it.
> so I think script should contain full definition regardles search_path settings (which could change during DB life cycle).
Yes and no. We could add an option to always view the schema, regardless
of the search_path setting. But one should be able to enable/disable
this behaviour.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2011-09-26 19:19:10 | Re: foreign table->properties->options |
| Previous Message | Willy-Bas Loos | 2011-09-26 10:02:29 | Re: pgadmin3 crash report |