Re: [GENERAL] Perl & DBI/DBD::Pg confusion with finish

2001-03-02 Thread David Wheeler
On Fri, 2 Mar 2001, John Madden wrote: > What are the consequences of not calling ->finish()? I have several apps > using DBD::Pg, and I don't think I've used it at all... It just means that the statement handle is marked finished, and if you use it again, it won't issue a warning saying that

Re: [GENERAL] Perl & DBI/DBD::Pg confusion with finish

2001-03-02 Thread David Lynn
> What are the consequences of not calling ->finish()? I have several apps > using DBD::Pg, and I don't think I've used it at all... There don't appear to be any fatal consequences - all queries appear to work fine. However, certain things such as the $sth->{'Active'} attribute cannot be relie

Re: [GENERAL] Perl & DBI/DBD::Pg confusion with finish

2001-03-01 Thread David Wheeler
On Thu, 1 Mar 2001, David Lynn wrote: > > Hello - > > When using DBD::Pg through DBI, can somebody tell me if it is necessary > to be calling the $sth->finish routine? The DBI.pm documentation states > that there is no need to call it if you call $sth->fetchrow_xxxref until > the rows are exha

[GENERAL] Perl & DBI/DBD::Pg confusion with finish

2001-03-01 Thread David Lynn
Hello - When using DBD::Pg through DBI, can somebody tell me if it is necessary to be calling the $sth->finish routine? The DBI.pm documentation states that there is no need to call it if you call $sth->fetchrow_xxxref until the rows are exhausted - finish should get called automatically, and $