DO NOT REPLY [Bug 41181] - Problem in Postgres query

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41181>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=41181





------- Additional Comments From [email protected]  2007-02-25 12:52 -------
Hello Olivier,

I do not have a slide installation with a Postgres backend to test that.
I am relatively new in slide development. All the SQL statements in this class look weird, because they 
are all referencing columns of this URI table.

instead of :

delete from VERSION_HISTORY  
where VERSION_HISTORY.URI_ID = URI.URI_ID and URI.URI_STRING = ?"


I would expect

delete from VERSION_HISTORY  
where VERSION_HISTORY.URI_ID IN (SELECT URI_ID FROM URI where URI_STRING = ?)"

Could you try it ?

If this change works, then probably most or all the SQL statements in this class need a similar change.

Regards,

Antoine

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.