18 Dec

pg_terminate_backend is invalid

71 views
0

gpadmin=# select datname,procpid,sess_id,current_query from pg_stat_activity ;
warehouse | 43828 | 343292 | copy syncman.tbl_user_account_201712 from stdin

gpadmin=# select pg_terminate_backend(43828);
pg_terminate_backend
———————-
t

gpadmin=# select datname,procpid,sess_id,current_query from pg_stat_activity ;
warehouse | 43828 | 343292 | copy syncman.tbl_user_account_201712 from stdin

In this example ,pg_terminate_backend() is a invalid order,why?

changed status