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: [EMAIL PROTECTED] 2323 Yonge Street, Suite #300 Toronto, Ontario M4P 2C9 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
