title: How to delete replication slot in postgres 9.4
body: <p>I have replication slot which I want to delete but when I do delete I got an error that I can't delete from view. Any ideas?</p>
  
  <pre><code>postgres=# SELECT * FROM pg_replication_slots ;
    slot_name   |    plugin    | slot_type | datoid | database | active | xmin | catalog_xmin | restart_lsn
  --------------+--------------+-----------+--------+----------+--------+------+--------------+-------------
   bottledwater | bottledwater | logical   |  12141 | postgres | t      |      |       374036 | E/FE8D9010
  (1 row)
  
  postgres=# delete from pg_replication_slots;
  ERROR:  cannot delete from view "pg_replication_slots"
  DETAIL:  Views that do not select from a single table or view are not automatically updatable.
  HINT:  To enable deleting from the view, provide an INSTEAD OF DELETE trigger or an unconditional ON DELETE DO INSTEAD rule.
  postgres=#
  </code></pre>