I made double check (both Win and Linux).
This time everything is OK - schema name is included in script.
This is a little strange for me, because previous script has been copied from script output (without schema name). Right now I cannot reproduce this bug(?) again.
Thanks for Your time.
Regards,
Bartek
2011/9/26 Guillaume Lelarge
<guillaume@lelarge.info>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.