Hi there. My company is evaluating the development version of PGNP (1.3) and I discovered an issue with "for update" syntax. The following sql statement throws an exception in PGNP, but it IS valid sql for postgres:
"select * from sometable where sometableid=1 for update"
If you remove the "for update" the query executes successfully. Unfortunately, we depend on the "for update" clause quite often.