DBI connect fails with DBD-Pg-2.12.0 but works with DBD-Pg-2.11.8

Gabriel Berriz <gberriz-nES/[email protected]>
Newsgroups gmane.comp.db.postgresql.dbdpg
Message-ID <[email protected]>

Hi.  I'd like to upgrade our version of DBD::Pg from 2.11.8 to 2.12.0  
(or higher), but 2.12.0 (the version I get when I upgrade DBD::Pg from  
CPAN) results in a connection error that did not occur with the  
earlier versions.  Specifically, when I attempt to run my test scripts  
all my connection attempts fail with error messages like:

DBI connect('dbname=postgres','dev',...) failed: FATAL:  role "dev"  
does not exist at t/read.t line 442

The source code line for referred to by this error message is

   my $pgh = DBI->connect(
                           'dbi:Pg:dbname=postgres',
                           'dev', '',
                           +{
                              AutoCommit => 1,
                              RaiseError => 1,
                              PrintError => 0,
                              PrintWarn  => 0,
                            }
                         );


As far as I know, there is only one Pg server running on localhost,  
and it uses the standard port.  For this server, contrary to what the  
error message above says, the "dev" role most definitely exists.  In  
fact, to get these errors to disappear (and all the tests to pass) all  
I need to do is ensure that the version of DBD::Pg that the code uses  
is 2.11.8 instead of 2.12.0, which confirms that role "dev" does exist  
as expected.

Does DBD-Pg-2.12.0 need a specific version of DBI?  I'm using 1.607.

How can I troubleshoot this further?

Thanks in advance,

Gabriel Berriz
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.