Kevin Field <kevinjamesfield@gmail.com> writes:
> My guess is that it has something to do with the join to the table
> 'mandate'.
I was wondering about that too, but the error message is pretty clear
about which table it's complaining about.
Please see if you can put together a self-contained example.
regards, tom lane