Postgresql constraint
_handle_dbapi_exception ( -> 1317 e, statement, parameters, cursor, context 1318 ) 1319 /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/sqlalchemy/engine/base.py in _handle_dbapi_exception (self, e, statement, parameters, cursor, context) 1509 elif should_wrap : 1510 util.
![postgresql constraint postgresql constraint](https://sqlserverguides.com/wp-content/uploads/2021/07/PostgreSQL-ALTER-TABLE-DROP-CONSTRAINT-768x473.png)
_has_events : /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/sqlalchemy/engine/base.py in _execute_context (self, dialect, constructor, statement, parameters, *args) 1315 except BaseException as e : 1316 self. ObjectNotExecutableError ( self ) /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/sqlalchemy/engine/base.py in _execute_clauseelement (self, elem, multiparams, params) 1128 distilled_params, 1129 compiled_sql, -> 1130 distilled_params, 1131 ) 1132 if self. _execute_clauseelement ( self, multiparams, params ) 299 else : 300 raise exc. supports_execution : -> 298 return connection. feedback : /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/sqlalchemy/engine/base.py in execute (self, object_, *multiparams, **params) 1009 ) 1010 else : -> 1011 return meth ( self, multiparams, params ) 1012 1013 def _execute_function ( self, func, multiparams, params ): /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/sqlalchemy/sql/elements.py in _execute_on_connection (self, connection, multiparams, params) 296 def _execute_on_connection ( self, connection, multiparams, params ): 297 if self. execute ( txt, user_namespace ) 368 _commit ( conn = conn, config = config ) 369 if result and config. run ( conn, parsed, self, user_ns ) 218 219 if ( /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/sql/run.py in run (conn, sql, config, user_namespace) 365 else : 366 txt = sqlalchemy. 186 def magic_deco ( arg ): -> 187 call = lambda f, * a, ** k : f ( * a, ** k ) 188 189 if callable ( arg ): /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/sql/magic.py in execute (self, line, cell, local_ns) 215 216 try : -> 217 result = sql. 186 def magic_deco ( arg ): -> 187 call = lambda f, * a, ** k : f ( * a, ** k ) 188 189 if callable ( arg ): in execute (self, line, cell, local_ns) /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/IPython/core/magic.py in (f, *a, **k) 185 # but it's overkill for just that one bit of state. builtin_trap : -> 2326 result = fn ( * args, ** kwargs ) 2327 return result 2328 in execute (self, line, cell, local_ns) /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/IPython/core/magic.py in (f, *a, **k) 185 # but it's overkill for just that one bit of state. run_line_magic ( 'sql', 'DROP INDEX users_user_email_id_key' ) /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/IPython/core/interactiveshell.py in run_line_magic (self, magic_name, line, _stack_depth) 2324 kwargs = sys. The above exception was the direct cause of the following exception : InternalError Traceback (most recent call last)
![postgresql constraint postgresql constraint](https://i.ytimg.com/vi/MWps-ltOM0k/maxresdefault.jpg)
HINT: You can drop constraint users_user_email_id_key on table users instead. execute ( statement, parameters ) 594 DependentObjectsStillExist: cannot drop index users_user_email_id_key because constraint users_user_email_id_key on table users requires it
![postgresql constraint postgresql constraint](https://www.w3resource.com/w3r_images/postgresql-foreigny-key-constraint-items-table.gif)
do_execute ( -> 1277 cursor, statement, parameters, context 1278 ) /opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/sqlalchemy/engine/default.py in do_execute (self, cursor, statement, parameters, context) 592 def do_execute ( self, cursor, statement, parameters, context = None ): -> 593 cursor.
![postgresql constraint postgresql constraint](https://static.javatpoint.com/postgre/images/postgresql-not-null-constraint10.png)
opt/anaconda3/envs/beakerx/lib/python3.6/site-packages/sqlalchemy/engine/base.py in _execute_context (self, dialect, constructor, statement, parameters, *args) 1276 self. DependentObjectsStillExist Traceback (most recent call last)