The following bug has been logged online:

Bug reference: 2353
Logged by: Alexander Kirpa
Email address: postgres (AT) bilteks (DOT) com
PostgreSQL version: 8.1.3
Operating system: FreeBSD 6.0
Description: Temporary tables created within trigger function still
exist after abend
Details:

In case abnormal exit (for instance 'ERROR: invalid UTF-8 byte sequence
detected near byte 0xc3') from application based on Perl (5.8.8) with access
to Postgres over DBD::Pg (1.47) temporary tables still unremoved.

Temporary tables created within trigger function (PL/PgSQL) not removed, but
temporary tables created within self perl application removed by Postgres
engine w/o problem.

Best regards,
Alexander Kirpa

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

"Alexander Kirpa" <postgres (AT) bilteks (DOT) com> writes:
Please provide a complete test case demonstrating this.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match