On Wed, Oct 23, 2002 at 03:10:05PM +0200, Stephan Harren wrote:
> Hello All,
> 
>        $statement="SELECT device_id FROM devices WHERE monitor=true";
>        $st1=$db1->prepare($statement) or $err=$DBI::errstr;

>                $statement="SELECT 
> ip,probes,packetloss,duration,last_check,sms,mail FROM ip WHERE 
> device_id=$row1->[0]";
>                $st2=$db1->prepare($statement) or $err=$DBI::errstr;
> 
> gives me the error message:
> 
> _set_fbav(ARRAY(0x831217c)): array has 7 fields, should have 1X at 
> /usr/lib/perl5/site_perl/5.6.1/DBD/PgPP.pm line 336, <IN> line 6.
> 
> I think that this means that there is only memory reserved for one 
> field. Now, that the second fetch ends up with seven fields seems to 
> lead into problems. Shouldn't every handle be treated separately?

Yes.

> Am I doing something wrong or is there a problem with the driver?

Looks like a DBD::PgPP bug.

Tim.

Reply via email to