On Fri, Jul 17, 2009 at 1:44 PM, Jaime
Casanova<jcasanov@systemguards.com.ec> wrote:
>
> i wasn't able to repeat this on a new instalation and of
> course i can't swear this is your patch fault...
>
this is not your patch fault but an existing bug, i repeat that
behaviour in an unpatched source tree...
with the steps in the previous mail i canceled 2 or 3 backend before
cancell the one with the explain analyze, i execute a second time that
pg_cancel_backend and if i try to re-run the query it gets cancelled
immediately, next time it runs normally...
pg_stat_activity reports that query as running no mather what...
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157