Bug #19997
closed
please support native postgres
0%
Description
please add support for native postgres
it should be implemented from base INSTALL (choose mysql or pgsql)
i don't want to use adodb and dbal.
every upgrade, through the wizzard fails (Update database tables and fields)
cause there are wrong sql queries.
eg. upgrade vom 4.1.5 to 4.2.5
ALTER TABLE sys_log ADD KEY recuidIdx (recuid,uid);
ERROR: syntax error at or near "("
LINE 1: ALTER TABLE sys_log ADD KEY recuidIdx (recuid,uid);
^
- Error ****
ERROR: syntax error at or near "("
SQL Status:42601
(issue imported from #M10409)
Updated by Franz Holzinger over 15 years ago
Does this mean that the files ext_tables.sql in the extensions do not work? This would make it necessary fo replace this with php and xml or a similar change.
Updated by Benni Mack over 14 years ago
Please try out the latest 4.4beta, which supports postgres out-of-the-box through the installer (yes, through DBAL). There won't be another way for postgres as through DBAL in the near future.
Updated by Chris topher over 14 years ago
Postgres is supported in 4.4.
If you have an error using DBAL, please open a new bug report in the DBAL section.