Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> I see. However my main problem is that the schema of unqualified
> vs1 is affected by the existence of yamada.vs1. I don't think
> it's a useful behavior.
Well, if you don't like it, you could set the search_path to be just
public, or public and then the user's personal namespace. But I think
personal namespace before public should be the default behavior.
regards, tom lane