Обсуждение: BUG #2353: Temporary tables created within trigger function still exist after abend

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

"Alexander Kirpa" <postgres@bilteks.com> writes:
> 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.

Please provide a complete test case demonstrating this.

            regards, tom lane