claroline / Claroline

Learning management system
https://www.claroline.com
Other
315 stars 188 forks source link

pgsql incompatibilitie(s) #614

Closed dgeo closed 9 years ago

dgeo commented 10 years ago

In those files:

There are four 'DROP CONSTRAINT IF EXISTS' that won't work under postgresql (8.4 at least)

  [Doctrine\DBAL\DBALException]                                                          
  An exception occurred while executing '                                                
              ALTER TABLE claro_widget_home_tab_config                                   
              DROP CONSTRAINT IF EXISTS FK_D48CC23EFBE885E2                              
          ':                                                                             

  SQLSTATE[42601]: Syntax error: 7 ERREUR:  erreur de syntaxe sur ou près de « EXISTS »  
  LINE 3:             DROP CONSTRAINT IF EXISTS FK_D48CC23EFBE885E2

Didnt't check forward to see if there are others…

ngodfraind commented 9 years ago

We're not supporting pgsql for now. Everyone works on Mysql/MariaDb. Doctrine is supposed to be able to handle it, but in practice, it doesn't work like that.