Re: RFD: schemas and different kinds of Postgres objects

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(at)gmx(dot)net