Re: Connection.setCatalog() - Mailing list pgsql-jdbc

From Peter Eisentraut
Subject Re: Connection.setCatalog()
Date
Msg-id Pine.LNX.4.30.0107171446280.678-100000@peter.localdomain
Whole thread Raw
In response to Re: Connection.setCatalog()  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Connection.setCatalog()
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: "Dave Cramer"
Date:
Subject: RE: [PATCH] setTimestamp(int, Timestamp) fails on null timestamp
Next
From: Tom Lane
Date:
Subject: Re: Connection.setCatalog()