> -----Original Message----- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > > Hiroshi Inoue <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
