-
Bug
-
Resolution: Fixed
-
Blocker
-
3.5.9, 3.6.7, 3.7.3, 3.8
-
PostgreSQL
-
MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE
-
MOODLE_37_STABLE, MOODLE_38_STABLE
-
m39_
MDL-67414_Add_PostgreSQL_12x_Support_v2 -
Easy
-
PostgreSQL since version 12.0 has removed the column pg_attrdef.adsrc. See the release notes.
This column is used in /lib/dml/pgsql_native_moodle_database.php. The installation of Moodle is halted with the message:
Default exception handler: Error reading from database Debug: ERROR: column d.adsrc does not exist
|
LINE 1: ...e, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, d.adsrc
|
^
|
SELECT a.attnum, a.attname AS field, t.typname AS type, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, d.adsrc |
FROM pg_catalog.pg_class c
|
JOIN pg_catalog.pg_namespace as ns ON ns.oid = c.relnamespace
|
JOIN pg_catalog.pg_attribute a ON a.attrelid = c.oid
|
JOIN pg_catalog.pg_type t ON t.oid = a.atttypid
|
LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = c.oid AND d.adnum = a.attnum)
|
WHERE relkind = 'r' AND c.relname = 'mdl_config' AND c.reltype > 0 AND a.attnum > 0 |
AND (ns.nspname = current_schema() OR ns.oid = pg_my_temp_schema())
|
ORDER BY a.attnum
|
[NULL]
|
Error code: dmlreadexception
|
* line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown |
* line 259 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end() |
* line 425 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end() |
* line 662 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_columns() |
* line 1619 of /lib/dml/moodle_database.php: call to moodle_database->where_clause() |
* line 1395 of /lib/moodlelib.php: call to moodle_database->get_field() |
* line 1506 of /lib/upgradelib.php: call to set_config() |
* line 1751 of /lib/upgradelib.php: call to upgrade_started() |
* line 479 of /lib/installlib.php: call to install_core() |
* line 813 of /admin/cli/install.php: call to install_cli_database() |
- duplicates
-
MDL-67220 Moodle does not support PostgreSQL 12
-
- Closed
-
- has a non-specific relationship to
-
MDL-52511 Add support for PostgreSQL 9.5
-
- Closed
-
-
MDL-67371 Upgrade ADODB to 5.20.15
-
- Closed
-
- has been marked as being related by
-
MDL-67415 Decide Moodle 3.10 requirements and push them to environment.xml (due date: 2020-07-24)
-
- Closed
-
- is duplicated by
-
MDL-67220 Moodle does not support PostgreSQL 12
-
- Closed
-
- will help resolve
-
MDL-65809 Decide Moodle 3.9 requirements and push them to environment.xml (due date: 2019-12-02)
-
- Closed
-