If you are using postgrest and you are getting an error of the form:
Column 'column_name' of relation 'table_name' does not exist
Restart postgrest. You will notice that it says
Schema cache loaded
Which means that if you changed the table definition after postgrest started, it will not be able to write to it, unless restarted and re-reading the table definition.
I found out about it while trying to send graylog alerts to a Postgres database using HTTP Alert Notifications.
You can do even more interesting stuff if instead of postgrest you use logstash.
Managing organized complexity 