Thread: BUG #2353: Temporary tables created within trigger function still exist after abend
BUG #2353: Temporary tables created within trigger function still exist after abend
From
"Alexander Kirpa"
Date:
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
Re: BUG #2353: Temporary tables created within trigger function still exist after abend
From
Tom Lane
Date:
"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