[fdo-trac] #647: Connection incorrectly requires a database named the same as the user name to exist

[FDO]

#647: Connection incorrectly requires a database named the same as the user name
to exist
---------------------------------+------------------------------------------
 Reporter:  mwtoews              |         Owner:  brentrobinson
     Type:  defect               |        Status:  closed       
 Priority:  major                |     Milestone:  3.6.0        
Component:  PostgreSQL Provider  |       Version:  3.4.0        
 Severity:  3                    |    Resolution:  fixed        
 Keywords:                       |   External_id:               
---------------------------------+------------------------------------------
Changes (by brentrobinson):

  * status:  assigned => closed
  * resolution:  => fixed


Comment:

 Revision: 5789
 Author: brentrobinson
 Date: 9:52:04 AM, Wednesday, November 03, 2010
 Message:
 Ticket#647: Changed PostgreSQL provider behaviour for connecting when
 datastore connection parameter is not specified. Previously, the
 connection to the PostgreSQL (via PQsetdbLogin) was done with
 database=NULL, meaning that the database defaulted to one named the same
 as the user. However, the connect fails if no such database exists.

 The fix was to connect to the postgres database when the datastore is not
 specified. In PostgreSQL 8.4, this database is always present and all
 users have access to it. However, to be on the safe side, if the connect
 fails, a 2nd connect with the original behaviour (database=NULL) is tried.
 ----
 Modified : /trunk/Providers/GenericRdbms/Src/PostGis/Driver/connect.c
 Modified : /trunk/Providers/GenericRdbms/Src/PostGis/Driver/connect.h

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/647#comment:5>
FDO <http://fdo.osgeo.org/>
Feature Data Objects