Re: What's the CURRENT schema ?

Hiroshi Inoue wrote:
> 
> 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.
> 

The unqualified one is there mainly for compatibility, so you can
still use your old database set ups without schema names.

Once you redo your database to use schemas, or even while you are 
converting it, there should not be tables with the same name in both 
places.

Anyway, as Tom said, you can change the search order if you prefer.

-- 
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9