search

kvesteri / postgresql-audit

Audit trigger for PostgreSQL
BSD 2-Clause "Simplified" License
126 stars 28 forks source link

Column "actor_id" of relation "transaction" does not exist #28

Closed arnoo closed 6 years ago

arnoo commented 6 years ago

When I follow the flask example from the documentation, I get an error on the first insert of a versioned object : 

qlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) column "actor_id" of relation "transaction" does not exist
flask_1     | LINE 1: ...n (native_transaction_id, issued_at, client_addr, actor_id) ...
flask_1     |                                                              ^
flask_1     |  [SQL: 'INSERT INTO transaction (native_transaction_id, issued_at, client_addr, actor_id) VALUES (txid_current(), now(), %(client_addr)s, %(actor_id)s) RETURNING transaction.id'] [parameters: {'cli
ent_addr': '172.21.0.3', 'actor_id': 1}] (Background on this error at: http://sqlalche.me/e/f405)
arnoo commented 6 years ago

I tried again and can't reproduce the issue. I'm not really sure what happened. Sorry for the noise.