Re: DBD::Pg 1.00

On Wed, 30 May 2001 08:07:11 -0400, newsreader(at)mediaone(dot)net wrote:
> DBD::Pg 1.00 won't allow me to use the following
> the code anymore
>
> ----------
> $s=$dbh->prepare('select * from table');
> $s->execute or die $dbh->errstr;
> while(my @a=$s->fetchrow_array())
> {
> ... do something
> }
> while(my @a=$s->fetchrow_array())
> {
> .. do something else
> }
> -----------
>
> It was fine before with 0.9?
>
> Now I need another execute statement before
> the second while statement.

That's because previous versions of DBD::Pg had a bug which didn't remove the Active attribute from statement handles which all rows had been fetched from.
The new behaviour is mre correct.

--
Peter Haworth pmh(at)edison(dot)ioppublishing(dot)com
"I'm just a mere programmer"
-- James Counihan