Tag: view

cannot delete from view pg_replication_slots

In this article, we will see solution for the error “cannot delete from view 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.

cannot delete from view pg_replication_slots

Continue reading cannot delete from view pg_replication_slots

Related Posts:

  1. ERROR: cannot drop schema because other objects depend on it
  2. ERROR: cannot drop table because other objects depend on it
  3. How to uninstall PostgreSQL from Ubuntu

ERROR: cannot drop table because other objects depend on it

Following error received when tried to drop table from PostgreSQL server.

ERROR:  cannot drop table emp because other objects depend on it
DETAIL:  view customer_view depends on table emp
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

ERROR: cannot drop table because other objects depend on it

Continue reading ERROR: cannot drop table because other objects depend on it

Related Posts:

  1. How to check list of privileges on a table in PostgreSQL
  2. How to find the table size in PostgreSQL
  3. How to get the PostgreSQL table structure
  4. How to take backup and restore a PostgreSQL table