Hi
We've used SquirrelMail for a while to give us remote access to our IMAP server and have been looking for something more modern, then I noticed RoundCube and decided to give it a spin ... I like it :-)
We generally prefer postgres over mysql so I configured it to use pgsql:// in the db.inc.php file, I have found quite a few "niggles" with SQL which presumably works in mysql but doesn't in postgres
Had to add a unix_timestamp() function
Had to add default empty string values to columns in several tables which have not-null constraints but do not receive values from insert statements
Had to change the quoting around several field names from field
to
"field" in the php pages
Had to change a few "LIMIT x,y" clauses into "OFFSET x LIMIT y" syntax
Had to reverse the order of deletes at logout from the cache and session tables to satisfy foreign key constraint
I'm not sure if the changes I've made will break mysql/sqlite (and therefore need be made conditional on the database schema)
Have these type of fixes already been done in the current CVS or should I try to make a patch and submit it?