[daisy] [JIRA] Created: (DSY-516) [PATCH] Fix PostgreSQL compatibility

[Andreas Deininger (JIRA)]

[PATCH] Fix PostgreSQL compatibility
------------------------------------

         Key: DSY-516
         URL: http://issues.cocoondev.org//browse/DSY-516
     Project: Daisy
        Type: Improvement
  Components: Repository - database support  
    Versions: 2.1    
 Environment: Latest SVN
 Reporter: Andreas Deininger
    Priority: Minor
 Attachments: postgresql.diff

The uploaded patch fixes the broken PostgreSQL compatibility of daisy

* renamed field name_ in table wf_pools to name_pool since it conflicts with name_ in table daisy_namespaces
* minor changes to query/model/SqlGenerationContext.java in order to make SQL statements work with PostgreSQL
* workflow/serverimpl/LocalWfPoolStrategy.java: adding users to workflow pool: PostgreSQL does not know INSERT IGNORE, so insert some logic to perform either an INSERT or an UPDATE, depending whether user record exists or not
* upgrading to latest postgreSQL JDBC driver: postgresql-7.4-216.jdbc3.jar (jdbc drivers for postgresql 8.x do not seem to work)

Also a small fix to <daisy-src>/README.txt is included

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira