Re: What's the CURRENT schema ?

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>
> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)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