Re: Perl & DBI/DBD::Pg confusion with finish
От | John Madden |
---|---|
Тема | Re: Perl & DBI/DBD::Pg confusion with finish |
Дата | |
Msg-id | 01030209032465.13156@weez обсуждение исходный текст |
Ответ на | Re: Perl & DBI/DBD::Pg confusion with finish (David Wheeler <david@wheeler.net>) |
Ответы |
Re: Perl & DBI/DBD::Pg confusion with finish
|
Список | pgsql-general |
> > 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 $sth->{'Active'} should change to false. > > We've found that DBD::Pg doesn't do this. So we either have to call > $sth->finish every time, or prepare the statement with > $dbh->prepare_cached() and passing the active flag as true. It shouldn't > be this way, but it is. 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... John -- # John Madden weez@freelists.org ICQ: 2EB9EA # FreeLists, Free mailing lists for all: http://www.freelists.org # UNIX Systems Engineer, Ivy Tech State College: http://www.ivy.tec.in.us # Linux, Apache, Perl and C: All the best things in life are free!
В списке pgsql-general по дате отправления: