[jboss-jira] [JBoss JIRA] Created: (JBMESSAGING-525) postgresql-persistence-service.xml contains invalid SQL syntax

postgresql-persistence-service.xml contains invalid SQL syntax -------------------------------------------------------------- Key: JBMESSAGING-525 URL: http://jira.jboss.com/jira/browse/JBMESSAGING-525 Project: JBoss Messaging Issue Type: Bug Components: Configuration and Management Affects Versions: 1.0.1.CR4 Environment: JBoss 4.0.4.GA, JBoss Messaging 1.0.1.CR4, PostgreSQL 8.1 Reporter: Takayoshi Kimura Assigned To: Ovidiu Feodorov Attachments: postgresql-persistence-service.xml.patch The UPDATE_UNRELIABLE_CHANNELCOUNT SQL in postgresql-persistence-service.xml uses "UPDATE tablename alias" syntax but PostgreSQL does not support this syntax. http://www.postgresql.org/docs/8.1/static/sql-update.html http://www.postgresql.org/docs/7.4/static/sql-update.html To fix this, simply remove the aliases from the SQL. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira