[SQL] Question about update syntaxt

[Michael M Friedel]

I am trying to use an application (Through ODBC) that uses the  
following update syntax

UPDATE MyTable SET MyTable.id=2 WHERE id=1
unfortunatly I get an error message
ERROR:  column "mytable" of relation "mytable" does not exist
Question is, is ther something I can configure that will make  
Postgresql accept these kind of statments ?


------------------------------------
Michael M Friedel
Research & Development

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faq