Hello,I've run an update query inside command line tool (psql) then I've exit 
the tool (closing the window).
When I re-logged in, I've noticed in pg_stat_activity that my query was still 
running.I used the command pg_cancel_backend with the right PID, but it 
returned "f" few seconds later.I re-checked pg_stat_activity and I was not able 
to see my query; there was only an autovacuum running on the table impacted by 
my query.Since my update query usually takes about one hour, I was wandering 
what happened.
Is postgres regularly checking command line session? If session has expired, 
would postgres stop the query and rollback it?

I'm using both client and server v10.1.
Thanks in advance.

Reply via email to