The following bug has been logged online:
Bug reference: 2353
Logged by: Alexander Kirpa
Email address: postgres@bilteks.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