BUG #2353: Temporary tables created within trigger function still exist after abend

Started by Alexander Kirpaabout 20 years ago2 messagesbugs
Jump to latest
#1Alexander Kirpa
postgres@bilteks.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Alexander Kirpa (#1)
Re: BUG #2353: Temporary tables created within trigger function still exist after abend

"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