[fdo-trac] #647: Use default dbname=postgres

[FDO]

#647: Use default dbname=postgres
-----------------------------------+----------------------------------------
   Reporter:  mwtoews              |       Owner:  badreddinekaroui
       Type:  defect               |      Status:  new             
   Priority:  major                |   Milestone:  3.6.0           
  Component:  PostgreSQL Provider  |     Version:  3.4.0           
   Severity:  3                    |    Keywords:                  
External_id:                       |  
-----------------------------------+----------------------------------------
 When attempting to connect to an OSGeo FDO Provider for PostgreSQL with a
 role without a self-named database, for example:
 {{{
 CREATE ROLE foouser LOGIN PASSWORD 'foopass' CREATEDB;
 }}}
 any attempt to make a connection in AutoCAD Map 3D 2011 has an error:
  * Login Failed: The specified credentials are not valid or the provider
 is unable to establish a connection
 while the database log has the errors:
 {{{
 2010-05-10 18:38:21 PDT FATAL:  database "foouser" does not exist
 2010-05-10 18:38:21 PDT FATAL:  database "foouser" does not exist
 }}}

 This type of error has a similar appearance as trying to connect from
 command-line using {{{psql}}}:
 {{{
 $ psql -U foouser
 Password for user foouser:
 psql: FATAL:  database "foouser" does not exist
 }}}
 since if no database is specified, then it is assumed to be self-named.

 With libpq, the default database should be "postgres", since it exists and
 anyone can connect to it. Although I have not inspected the FDO code in
 detail, I suspect a default dbname is not supplied. See
 http://www.postgresql.org/docs/8.4/static/libpq-connect.html

 An example: http://www.postgresql.org/docs/8.4/static/libpq-example.html

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