Re: Big 7.1 open items

"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
>> A database corresponds to a catalog and a schema corresponds to nothing
>> yet.

> Oh I see your point. However I've thought that current PostgreSQL's
> database is an imcomplete SCHEMA and still feel so in reality.
> Catalog per database has been nothing but needless for me from
> the first.

It may be needless for you, but not for everybody ;-).

In my mind the point of the "database" concept is to provide a domain
within which custom datatypes and functions are available.  Schemas
will control the visibility of tables, but SQL92 hasn't thought about
controlling visibility of datatypes or functions.  So I think we will
still want "database" = "span of applicability of system catalogs"
and multiple databases allowed per installation, even though there may
be schemas subdividing the database(s).
        regards, tom lane