sergio nogueira <sergiopnog@xxxxxxxxx> writes: > then i kill the process executing the truncate. > the result: > LOG: server process (PID 3421) was terminated by signal 9: > Killed > Any idea on how to prevent this? Don't do that. kill -9 is *never* the recommended way to terminate a query. Next time try kill -INT, if you must do something like this. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
