glossary
(postgres7): CREATE TABLE mdl_glossary ( id SERIAL, course int4 NOT NULL default '0', name varchar(255) NOT NULL default '', intro text NOT NULL default '', studentcanpost int2 NOT NULL default '0', allowduplicatedentries int2 NOT NULL default '0', displayformat varchar(50) NOT NULL default 'dictionary', mainglossary int2 NOT NULL default '0', showspecial int2 NOT NULL default '1', showalphabet int2 NOT NULL default '1', showall int2 NOT NULL default '1', allowcomments int2 NOT NULL default '0', usedynalink int2 NOT NULL default '1', defaultapproval int2 NOT NULL default '1', globalglossary int2 NOT NULL default '0', entbypage int NOT NULL default '10', editalways integer NOT NULL default '0', rsstype integer NOT NULL default '0', rssarticles integer NOT NULL default '0', assessed int4 NOT NULL default '0', assesstimestart int4 NOT NULL default '0', assesstimefinish int4 NOT NULL default '0', scale int4 NOT NULL default '0', timecreated int4 NOT NULL default '0', timemodified int4 NOT NULL default '0', PRIMARY KEY (id))
Warning: PostgreSQL query failed: ERROR: Relation 'mdl_glossary_id_seq' already exists in /var/www/moodle/lib/adodb/drivers/adodb-postgres64.inc.php on line 687
-5: ERROR: Relation 'mdl_glossary_id_seq' already exists
Error
(postgres7): CREATE INDEX mdl_glossary_course_idx ON mdl_glossary (course)
Warning: PostgreSQL query failed: ERROR: index named "mdl_glossary_course_idx" already exists in /var/www/moodle/lib/adodb/drivers/adodb-postgres64.inc.php on line 687
-1: ERROR: index named "mdl_glossary_course_idx" already exists
Error
(postgres7): CREATE TABLE mdl_glossary_entries ( id SERIAL, glossaryid int4 NOT NULL default '0', userid int4 NOT NULL default '0', concept varchar(255) NOT NULL default '', definition text NOT NULL, format int2 NOT NULL default '0', attachment VARCHAR(100) NOT NULL default '', timecreated int4 NOT NULL default '0', timemodified int4 NOT NULL default '0', teacherentry int2 NOT NULL default '0', sourceglossaryid int4 NOT NULL default '0', usedynalink int2 NOT NULL default '1', casesensitive int2 NOT NULL default '0', fullmatch int2 NOT NULL default '1', approved int2 NOT NULL default '1', PRIMARY KEY(id))
Warning: PostgreSQL query failed: ERROR: Relation 'mdl_glossary_entries_id_seq' already exists in /var/www/moodle/lib/adodb/drivers/adodb-postgres64.inc.php on line 687
-5: ERROR: Relation 'mdl_glossary_entries_id_seq' already exists
Error
(postgres7): CREATE INDEX mdl_glossary_entries_glossaryid_idx ON mdl_glossary_entries (glossaryid)
Warning: PostgreSQL query failed: ERROR: index named "mdl_glossary_entries_glossaryid" already exists in /var/www/moodle/lib/adodb/drivers/adodb-postgres64.inc.php on line 687
-1: ERROR: index named "mdl_glossary_entries_glossaryid" already exists
Error
I have many warnings like this when I try install moodle on Debian + PostgreSQL. It is something with indexes but I don't know what. Moodle version 1.4.4
Could you help me???
Thanks for help.