[svn:DBD-Pg] r9257 - DBD-Pg/trunk

[turnstep]

Author: turnstep
Date: Thu Mar 15 19:04:23 2007
New Revision: 9257

Modified:
   DBD-Pg/trunk/Pg.pm

Log:
Use prepare_cached in last_insert_id where appropriate (rt #24313)


Modified: DBD-Pg/trunk/Pg.pm
==============================================================================
--- DBD-Pg/trunk/Pg.pm  (original)
+++ DBD-Pg/trunk/Pg.pm  Thu Mar 15 19:04:23 2007
@@ -259,7 +259,7 @@
                                push @args, $schema;
                        }
                        $SQL = "SELECT c.oid FROM 
${DBD::Pg::dr::CATALOG}pg_class c $schemajoin\n WHERE relname = ?$schemawhere";
-                       $sth = $dbh->prepare($SQL);
+                       $sth = $dbh->prepare_cached($SQL);
                        $count = $sth->execute(@args);
                        if (!defined $count or $count eq '0E0') {
                                $sth->finish();
@@ -306,7 +306,7 @@
                        $dbh->{private_dbdpg}{$cachename} = $sequence;
                }
 
-               $sth = $dbh->prepare("SELECT currval(?)");
+               $sth = $dbh->prepare_cached("SELECT currval(?)");
                $sth->execute($sequence);
                return $sth->fetchall_arrayref()->[0][0];