Tom Lane writes:
> No, it doesn't work the same as today, because in that implementation
> both A and B can create the same tablename without complaint. It then
> becomes very unclear which instance other people will get (unless your
> "any" placeholder somehow implies a search order).
The "search any schema" switch is only intended for use with legacy
databases, where duplicate names don't occur anyway. If someone uses it
with a new schema-using database design, then he kind of ought to know
that the switch probably doesn't make a whole lot of sense. However, to
get reproduceable behaviour anyway we can just define a search order, such
as by schema name.
--
Peter Eisentraut peter_e@gmx.net