>How do you expect someone to reproduce without using your tables?
Crash occurs in odbc driver before query is sent to Postgres.
Those tables or database are not required to reproduce, simply run query using postgres odbc official driver.
>But I have a question - are you using a CROSS JOIN of your 2 first tables? Can you remove one of them? Using FROM t1, t2 and then normal JOIN conditions looks very weird to me.
I removed prpalk and changed code it but problem persists. Maybe $ signs in query cause this.
prpalk table used in query in cross join contains company paramaters used in query.
It has always single record. So it it normat to use prpalk in this way.
Andrus