[Oledb-dev] [Win2k, Postgres 8.0.3] IOpenRowset interface crash

[Shachar Shemesh]

David Moore wrote:

>CPgSession::PQexec 1, "SELECT * FROM $1"
>CPgSession::PQerrorMessage ERROR:  syntax error at or near "$1" at
>
>I don't see why this statement should fail - it looks like a normal
>parameterised call.  Any ideas?
>  
>
You can't parametrize the "from". The parameters are run through the 
planner, and the planner cannot do anything if it doesn't know which 
table it takes the information from.

This bug is already solved in CVS and in the suggested release version I 
posted to the list a while back (search the archives). Unfortunately, I 
have not had time to properly sleep over the past two months, much less 
code on Ole DB. As such, no new release yet. Sorry. I hope to get things 
done next week.

>TIA,
>David Moore
>  
>
       Shachar

-- 
Shachar Shemesh
Lingnu Open Source Consulting ltd.
Have you backed up today's work? http://www.lingnu.com/backup.html