On Fri, Jul 17, 2009 at 1:44 PM, Jaime Casanova<jcasa...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers