[TYPO3-dev] the core's missing dbal/postgresql compatibility

[Michael Greiner]

Hello,

thank you very much for your answer, Masi. I wish there would be more
PostgreSQL users within the typo3 community. Today I reported the main
bugs on http://bugs.typo3.org/. In addition here is my list of "missing
compatibility"-issues:

1. If you have a clean installation of Typo3 source & dummy on PostgreSQL
   just look into Extension Manager:

   Some extensions show "A difference between the orginally installed version and the current was detected!" some others have a long list of "ALTER TABLE" expressions under "UPDATE NEEDED" in addition.

   typo3skin, t3editor, cssstyledcontent, adodb -> only show error
   dbal, htmlarea RTE, felogin -> show error and UPDATE NEEDED

2. In the INSTALL TOOL > Database Analyser "Compare" shows a very long
   list of ALTER TABLE expressions that cannot be applied. In a
   running installation with many extensions they are even more numerous.

3. In the INSTALL TOOL > Database Analyser "Compare with $TCA" there
   are many mismatches and the comparison of values are all
   mismatching, too.

4. The sysextension "indexed search engine" has a problem in
   ext_tables.sql, because it contains "ENGINE=InnoDB" and this still
   cannot be processed

It would be very kind of you, if you could help me understand the
problems and finding solutions.

Best regards,

Michael Greiner