in reply to Re^2: DBD message diagnostic?
in thread DBD message diagnostic?

The former defaults to making a tcp connection unless you set the host parameter to path,

Are you sure? The documentation for DBD::Pg says it defaults to using a local domain socket when the host isn't specified (which is what DBD::PgPP does).

Replies are listed 'Best First'.
Re^4: DBD message diagnostic?
by BrowserUk (Patriarch) on Apr 15, 2009 at 14:50 UTC
    Are you sure?

    Yes. Quite sure. This script (just userid & password obscured): 

    #! perl -sw
use 5.010;
use strict;
use threads;
use DBI;

my $dbh = DBI->connect("dbi:Pg:dbname=junk", '******', '********');
say $dbh;

my $sth = $dbh->prepare( 'Select * from fred' );
$sth->execute;
while( my @row = $sth->fetchrow_array ) {
    say "@row";
}

    [download]

    Produces this output: 

    c:\test>DB.pl
DBI::db=HASH(0x40ae870)
1 fred
2 bill
3 jack
4 joe

    [download]

    So, maybe PgPP followed Pg's POD and not it's behaviour?

    Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
    "Science is about questioning the status quo. Questioning authority".
    In the absence of evidence, opinion is indistinguishable from prejudice.
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom