D0aQBj9y

1db/similarity.py:142: in submit_similarity_by_id
2    metric.create()
3similarity/operations.py:22: in create
4    db.similarity.create_similarity_metric(self.name, clear)
5db/similarity.py:201: in create_similarity_metric
6    connection.execute(query, {"metric": metric})
7/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py:988: in execute
8    return meth(self, multiparams, params)
9/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py:287: in _execute_on_connection
10    return connection._execute_clauseelement(self, multiparams, params)
11/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1107: in _execute_clauseelement
12    distilled_params,
13/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1248: in _execute_context
14    e, statement, parameters, cursor, context
15/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1466: in _handle_dbapi_exception
16    util.raise_from_cause(sqlalchemy_exception, exc_info)
17/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py:383: in raise_from_cause
18    reraise(type(exception), exception, tb=exc_tb, cause=cause)
19/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py:1244: in _execute_context
20    cursor, statement, parameters, context
21_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
22
23self = <sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2 object at 0x7f689fb0be10>, cursor = <cursor object at 0x7f68a1c32a50; closed: -1>
24statement = '\n            ALTER TABLE similarity\n             ADD COLUMN\n          IF NOT EXISTS %(metric)s DOUBLE PRECISION[]\n        ', parameters = {'metric': 'instruments'}
25context = <sqlalchemy.dialects.postgresql.psycopg2.PGExecutionContext_psycopg2 object at 0x7f68b25d6e10>
26
27    def do_execute(self, cursor, statement, parameters, context=None):
28>       cursor.execute(statement, parameters)
29E       ProgrammingError: (psycopg2.ProgrammingError) syntax error at or near "'instruments'"
30E       LINE 4:           IF NOT EXISTS 'instruments' DOUBLE PRECISION[]
31E                                       ^
32E       
33E       [SQL: 
34E                   ALTER TABLE similarity
35E                    ADD COLUMN
36E                 IF NOT EXISTS %(metric)s DOUBLE PRECISION[]
37E               ]
38E       [parameters: {'metric': 'instruments'}]
39E       (Background on this error at: http://sqlalche.me/e/f405)
40
41/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py:552: ProgrammingError