[rt.cpan.org #18597] DBD::Pg::db last_insert_id failed: no statement executing

Fri Apr 07 19:55:23 2006: Request 18597 was acted upon.
Transaction: Ticket created by guest
       Queue: DBD-Pg
     Subject: DBD::Pg::db last_insert_id failed: no statement executing
       Owner: Nobody
  Requestors: [email protected]
      Status: new
 Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=18597 >



Hello, 

following the example in the documentation, when I try and do a:

-----------
my $sth=$dbh->prepare("INSERT into foo (bar,blah,baz) VALUES (?,?,?);"); 

$sth->execute( 'XXX', 'XXX', 'XXX');

my $newid = $dbh->last_insert_id(undef,undef,"foo",undef);
print "Last insert id was $newid\n" if defined $newid; ;
-----------

I get the error message;

DBD::Pg::db last_insert_id failed: no statement executing

This is with Linux RHEL 3, DBI: 1.50, DBD::Pg 1.48, postgres 7.3.4, perl
5.6.1.