On Thursday 29 January 2009, Terry Fielder <te...@ashtonwoodshomes.com> wrote: > and that ties to: > 2) If I try to kill 1 postgres pid (e.g. to abort a bad query), the > whole backend shuts down and rolls back. > Can we get a way to look at and then kill a specific bad query?
select pg_cancel_backend(pid). Or kill pid from the shell, it only kills off one backend on 8.x anyway. -- Current Peeve: The mindset that the Internet is some sort of school for novice sysadmins and that everyone -not- doing stupid dangerous things should act like patient teachers with the ones who are. -- Bill Cole, NANAE -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
