On Mon, Sep 30, 2002 at 03:21:53PM +1200, Glen Eustace wrote:
> 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 ?
Uh, wasn't paying attention. Sorry. Yes. trace(9), just to me, not the list.
Can't promise to spend much time on it. You should also be talking to
the authors of the drivers.
Tim.
> 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
> ^^-^^ |------------------------------------------------------------
>
