Re: Command line session and running queries

2018-08-23 Thread Laurenz Albe
imp3 wrote: > 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" > fe

Command line session and running queries

2018-08-22 Thread imp3
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-c