Drop and create jsonb_substract function instead of replacing it

kvesteri / postgresql-audit

Audit trigger for PostgreSQL

BSD 2-Clause "Simplified" License

126 stars 28 forks source link

Closed AdamSelene closed 5 years ago

AdamSelene commented 6 years ago

This solves an issue we were running into after migrating our postgresql db from 9.6 to 10:

(psycopg2.ProgrammingError) cannot change name of input parameter "json"
HINT:  Use DROP FUNCTION jsonb_subtract(jsonb,jsonb) first.

kvesteri commented 5 years ago

Thanks for the PR! :train: