-
Bug
-
Resolution: Duplicate
-
Minor
-
None
-
2.0
-
None
-
pg 8.3
-
PostgreSQL
-
MOODLE_20_STABLE
1/ Run clean install from cvshead
2/ Run check defaults script.
3/ Table: forum_discussions. Field: groupid, Expected '-1' Actual '(-1)'
ALTER TABLE mdl_forum_discussions ADD groupid_alter_column_tmp BIGINT;
UPDATE mdl_forum_discussions SET groupid_alter_column_tmp = groupid;
ALTER TABLE mdl_forum_discussions DROP COLUMN groupid;
ALTER TABLE mdl_forum_discussions RENAME COLUMN groupid_alter_column_tmp TO groupid;
ALTER TABLE mdl_forum_discussions ALTER COLUMN groupid SET DEFAULT -1;
ALTER TABLE mdl_forum_discussions ALTER COLUMN groupid SET NOT NULL;
- duplicates
-
MDL-29567 Fix problem with negative defaults under PostgreSQL and associated tests
-
- Closed
-