When I Create a EnumType, it tips me that the old Pg_enum has exits. and I have had do it ago, but now I can't make a new type.
I have serach that but I still not konw how to do about it. I found I couldn't del the old type....
the message is :
Traceback (most recent call last):
File "manage.py", line 88, in <module>
manager.run()
File "E:\MyProgram\financeSystem\env\lib\site-packages\flask_script\__init__.py", line 412, in run
result = self.handle(sys.argv[0], sys.argv[1:])
File "E:\MyProgram\financeSystem\env\lib\site-packages\flask_script\__init__.py", line 383, in handle
res = handle(*args, **config)
File "E:\MyProgram\financeSystem\env\lib\site-packages\flask_script\commands.py", line 216, in __call__
return self.run(*args, **kwargs)
File "manage.py", line 85, in createdb
db.create_all()
File "E:\MyProgram\financeSystem\env\lib\site-packages\flask_sqlalchemy\__init__.py", line 972, in create_all
self._execute_for_all_tables(app, bind, 'create_all')
File "E:\MyProgram\financeSystem\env\lib\site-packages\flask_sqlalchemy\__init__.py", line 964, in _execute_for_all_tables
op(bind=self.get_engine(app, bind), **extra)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\sql\schema.py", line 3745, in create_all
tables=tables)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\engine\base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\engine\base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\sql\visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\sql\ddl.py", line 720, in visit_metadata
_ddl_runner=self)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\event\attr.py", line 256, in __call__
fn(*args, **kw)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\util\langhelpers.py", line 546, in __call__
return getattr(self.target, self.name)(*arg, **kw)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\sql\sqltypes.py", line 1040, in _on_metadata_create
t._on_metadata_create(target, bind, **kw)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\dialects\postgresql\base.py", line 1379, in _on_metadata_create
self.create(bind=bind, checkfirst=checkfirst)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\dialects\postgresql\base.py", line 1317, in create
bind.execute(CreateEnumType(self))
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\engine\base.py", line 914, in execute
return meth(self, multiparams, params)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\sql\ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\engine\base.py", line 968, in _execute_ddl
compiled
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\engine\base.py", line 1146, in _execute_context
context)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\engine\base.py", line 1341, in _handle_dbapi_exception
exc_info
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\util\compat.py", line 202, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\engine\base.py", line 1139, in _execute_context
context)
File "E:\MyProgram\financeSystem\env\lib\site-packages\sqlalchemy\engine\default.py", line 450, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) 閿欒: 閲嶅閿繚鍙嶅敮涓€绾︽潫"pg_enum_typid_label_index"
DETAIL: 閿€?(enumtypid, enumlabel)=(49248, equipment_fee)" 宸茬粡瀛樺湪
[SQL: "CREATE TYPE subject_name AS ENUM ('trans_fee', 'homeStay_fee', 'material_fee', 'checkNew_fee', 'hardware_fee', 'meeting_fee', 'agentMaterial_fee', 'equipment_fee', 'equipment_fee', 'services_fee', 'labor_fee', 'treat_fee', 'layout_fee', 'printing_fee', 'book_fee')"]
and how i could do now. thanks for your help...