DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15064>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15064 [PATCH] (Chris) Postgresql 7.3: LIMIT x,y no longer supported Summary: [PATCH] (Chris) Postgresql 7.3: LIMIT x,y no longer supported Product: Cocoon 2 Version: Current CVS Platform: PC OS/Version: Linux Status: NEW Severity: Normal Priority: Other Component: general components AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] since postgresql 7.3, the syntax "LIMIT x,y" has changed to "LIMIT x OFFSET y" This must be reflected in EsqlQuery.java This works also for pre 7.3 postgres (I have 7.2.3) but I don't know since when. EsqlQuery.java simplifies to: case EsqlConnection.LIMIT_METHOD_POSTGRESQL: if (maxRows > -1) query = query + " LIMIT " + maxRows; if (skipRows > 0) query = query + " OFFSET " + skipRows; case EsqlConnection.LIMIT_METHOD_MYSQL: ... --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
