[fdo-internals] Connection state and commands

[Mateusz Loskot]

Gavin Cramer wrote:
> I am not sure how many other providers don't support Pending or the
> "DataStores" commands, but ODBC Provider lacks these.  It goes straight
> from the Closed state to the Open state.  Since there is officially no
> "server" or other target to set in ODBC, calling Open() to get to the
> Pending state would not do much.

The PostGIS FDO I'm working on does support this feature.

The state pending means that user has connected to the database server
and one of databases available there (not FDO datastore).
The state open means that a user has specified and "connected to"
PostgreSQL schema - FDO datastore.

The FDO Provider for PostGIS does following mapping:
- PostgreSQL database to FDO service
- PostgreSQL schema to FDO datastore


Cheers
-- 
Mateusz Loskot
http://mateusz.loskot.net