As far as I can tell, there isn't a way to get postgresql to accept column
qualifiers (e.g. tablenames). A 'parse error at or near "."' gets returned.
I'm using a closed source application that has successfully handled a number
of other sql92 compatible datasources via odbc. The problem is the app
insists on qualifying column names all the time, even in Insert and Update
statements. That is not incorrect according to sql92, even though one could
assume that a qualifier is never required with update and insert.
Is it possible to get Postgres to accept these statements? Anyone have a hack
to let this stuff through the parser?
Tia,
Jim
