Re: Connection.setCatalog()

Tom Lane writes:

> Peter E. has previously commented that Postgres databases correspond
> most closely to the SQL concept of "catalog cluster", not "catalog".

I most certainly did not.  According to my interpretation:

schema = schema
catalog = database
cluster = thing you get from initdb

This is also how we currently document it and it tends to be the practice
in other products as well.

> This agrees with my reading of SQL92 4.13:
>
>          A cluster is an implementation-defined collection of catalogs.
>          Exactly one cluster is associated with an SQL-session and it
>          defines the totality of the SQL-data that is available to that
>          SQL-session.

Yes, the stuff served by a single postmaster is the totality of the
SQL data available to that SQL session.  But note:

         The method of creation and destruction of
         catalogs is implementation-defined. The set of catalogs that
         can be referenced in any SQL-statement, during any particular
         SQL-transaction, or during the course of an SQL-session is also
         implementation-defined.

(just above your stuff)

which serves us just fine.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter