title: update or delete on table X violates foreign key constraint Y on table Z
body: <p>Hello I'm trying to run this: <code>DELETE FROM ds_airflow.ab_view_menu WHERE name = 'DAG:vl2_daily';</code>  (only once) however I'm seeing the below error:</p>
  <pre><code>ERROR:  update or delete on table &quot;ab_view_menu&quot; violates foreign key
   constraint &quot;ab_permission_view_view_menu_id_fkey&quot; on table
  &quot;ab_permission_view&quot; DETAIL: Key (id)=(191) is still referenced from
   table &quot;ab_permission_view&quot;.
  </code></pre>
  <p>I've tried <a href="https://stackoverflow.com/questions/14182079/delete-rows-with-foreign-key-in-postgresql/40110751">this</a> : <code>delete from ds_airflow.ab_permission_view WHERE name = 'DAG:vl2_daily';</code> from stack overflow, seecomment on the very bottom, but I'm get this error:</p>
  <pre><code>ERROR:  column &quot;name&quot; does not exist
  LINE 2: WHERE name = 'DAG:vl2_daily';
  </code></pre>
  <p>This is what <code>ds_airflow.ab_permission_view</code> table  has:</p>
  <pre><code>s_airflow=&gt; \d+ ds_airflow.ab_permission_view
              Table &quot;ds_airflow.ab_permission_view&quot;
      Column     |  Type   | Modifiers | Storage | Description 
  ---------------+---------+-----------+---------+-------------
   id            | integer | not null  | plain   | 
   permission_id | integer |           | plain   | 
   view_menu_id  | integer |           | plain   | 
  Indexes:
      &quot;ab_permission_view_pkey&quot; PRIMARY KEY, btree (id)
      &quot;ab_permission_view_permission_id_view_menu_id_key&quot; UNIQUE, btree (permission_id, view_menu_id)
  Foreign-key constraints:
      &quot;ab_permission_view_permission_id_fkey&quot; FOREIGN KEY (permission_id) REFERENCES ds_airflow.ab_permission(id)
      &quot;ab_permission_view_view_menu_id_fkey&quot; FOREIGN KEY (view_menu_id) REFERENCES ds_airflow.ab_view_menu(id)
  Referenced by:
      TABLE &quot;ds_airflow.ab_permission_view_role&quot; CONSTRAINT &quot;ab_permission_view_role_permission_view_id_fkey&quot; FOREIGN KEY (permission_view_id) REFERENCES ds_airflow.ab_permission_view(id)
  Has OIDs: no
  </code></pre>