> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>
> 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,
Yes I don't like it and probably I would do it for myself but
I couldn't force other people to do so. Well for example,
how could psqlodbc driver know the CURRENT schema ?
> or public and then the user's personal namespace.
The order isn't the problem at all. Would the *public*
be the CURRENT schema then ? If I recognize correctly,
neither is the CURRENT schema in the current spec.
regards,
Hiroshi Inoue