Sha256: 784eca721f62e4dc61209a22c42e0965a8e4ff08b16ae9fea7f091273fa16569

Contents?: true

Size: 197 Bytes

Versions: 25

Compression:

Stored size: 197 Bytes

Contents

/* Kill database connection by its pid */

SELECT pg_terminate_backend(pid) FROM pg_stat_activity
  WHERE pid = %{pid}
  AND query <> '<insufficient privilege>'
  AND datname = current_database();

Version data entries

25 entries across 25 versions & 1 rubygems

Version Path
ruby-pg-extras-5.6.1 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.6.0 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.5.1 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.5.0 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.4.5 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.4.4 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.4.3 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.4.2 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.4.1 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.4.0 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.3.1 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.3.0 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.2.5 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.2.4 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.2.3 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.2.2 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.2.1 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.2.0 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.1.0 lib/ruby_pg_extras/queries/kill_pid.sql
ruby-pg-extras-5.0.0 lib/ruby_pg_extras/queries/kill_pid.sql