Spoke too soon :-(
With Perl5.8.0 instead of 5.6.0, I am no longer getting a SEGV, but
things are still broken.
The connects apparently succeed, but when I try to use the 2nd
connection, the first is used.
NB: the table, 'site' only exists in the second database.
DBD::Pg is using the Ingres database
-----------------------
use DBI;
$oDBase1 = DBI->connect( "dbi:Ingres:its-admin1::csadminp", 'dbguest',
'', {AutoCommit=>0})
or die "Cannot connect to first database: " .
$DBI::errstr;
$oDBase2 =
DBI->connect('dbi:Pg:dbname=netdbase;host=its-dev2.massey.ac.nz',
'netdbase', '')
or die "Cannot connect to second database: " . $DBI::errstr;
$oSql = $oDBase2->prepare( "select count(*) from site" ) or
die "Prep failed" . $DBI::errstr;
$oSql->execute() or
die "Exec failed" . $DBI::errstr;
( $iCnt ) = $oSql->fetchrow();
print "Sites = ", $iCnt, "\n";
T1.(its-dev1)work: /usr/local/bin/perl5.8.0 DBITest
E_LQ00BE Attempt to switch to a non-existent session.
DBD::Pg::db prepare failed: E_US0845 Table 'site' does not exist or is
not owned by you.
(Thu Sep 26 10:09:10 2002) at DBITest line 8.
Prep failedE_US0845 Table 'site' does not exist or is not owned by you.
(Thu Sep 26 10:09:10 2002) at DBITest line 8.
E_LQ00BE Attempt to switch to a non-existent session.
--
.*. | Glen Eustace, Systems Engineer - Networking.
/V\ | Information Technology Services PN460, Turitea,
(/ \) | Massey University, Palmerston North, New Zealand.
( ) | Ph: +64 6 350 5799 x 2707, Fax: +64 6 350 5607
^^-^^ |------------------------------------------------------------
