select for update broken

Report PGNP bugs.

select for update broken

Postby tylerburd » Wed Aug 05, 2009 2:36 pm

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.
tylerburd
 
Posts: 1
Joined: Wed Aug 05, 2009 2:31 pm

Re: select for update broken

Postby Moderator » Sat Aug 08, 2009 11:23 pm

We have added support for the syntax (build 1145). The fixed version is available at:
http://www.pgoledb.com/downloads/PGNP32-1.2.8.1145.exe
http://www.pgoledb.com/downloads/PGNP64-1.2.8.1145.exe

Here are examples of statements that are now supported:
select * from tbl for update; -- generic "for update" clause
select * from tbl for update of tbl nowait; -- complex "for update" clause
select * from tbl order by id for update limit 1 offset 100; -- "for update" can be before or after "limit" and "offset" clauses
select * from tbl, tbl2 limit 1 offset 100 for update of tbl, tbl2; -- and can have list of tables
select * from tbl order by id limit all for share; -- generic "for share" syntax
User avatar
Moderator
Site Admin
 
Posts: 293
Joined: Wed Oct 29, 2008 11:27 pm


Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest