On Mon, 2011-09-26 at 09:33 +0200, bdmytrak@eranet.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