Tim, Is there any thing I can provide that may help resolve this issue.
Now that I don't get perl dieing, would the DBI trace help ?
On Thu, 2002-09-26 at 10:11, Glen Eustace wrote:
> 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
> ^^-^^ |------------------------------------------------------------
--
.*. | 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
^^-^^ |------------------------------------------------------------
