Re: DBD::Pg 1.00

On Wed, 30 May 2001 08:07:11 -0400, newsreader@mediaone.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
whichall rows had been fetched from. 
The new behaviour is mre correct.

--
    Peter Haworth    pmh@edison.ioppublishing.com
"I'm just a mere programmer"
        -- James Counihan