Problem with DBD::Pg last_insert_id

Hi,

I have a problem the DBD::Pg (version 1.49 and 1.43) when I try to call 
$dbh->last_insert_id it returns the error

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

The postgres log files has a matching message of:

ERROR:  relation "transaction_transaction_id_seq" does not exist

It appears that this error only occurs after inserting into a table that 
is not in the postgres schema search_path (ie does not add the schema to 
the sequence name). Also this error occurs when I use PostgreSQL 8.1.4 
but not when I use PostgreSQL 8.0.5 on other wise similar systems.

Any help would be greatly appreciated.

Thanks

Ivan

Versions
Perl  v5.8.6 built for i386-linux-thread-multi
PostgreSQL  8.1.4
DBI  1.48
DBD::Pg 1.49 & 1.43