Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it> writes:
> Tom Lane ha scritto:
>> Is it really the *exact* same query both ways, or are you doing
>> something like parameterizing the query in the application?
> Is it exactly the same, the query text is from the postgres log.
> I just try it in test environment and we have same situazione : psql it
> works, from application (odbc) do not.
Hm, there's got to be something different between the two cases.
Maybe the odbc application is issuing some SET commands that change
the chosen plan?
regards, tom lane