(postgres7): DELETE FROM mdl_log_display WHERE module = 'user'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation mdl_log_display in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(DELETE FROM mdl_log_display WHERE module = 'user', false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(DELETE FROM mdl_log_display WHERE module = 'user') % line 1094, file: datalib.php
delete_records(log_display, module, user) % line   28, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

(postgres7): SELECT * FROM mdl_log_display WHERE id = '-1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: column "id" does not exist LINE 1: SELECT * FROM mdl_log_display WHERE id = '-1' ^ in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(SELECT * FROM mdl_log_display WHERE id = '-1', false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(SELECT * FROM mdl_log_display WHERE id = '-1') % line 1140, file: datalib.php
insert_record(log_display, Object:stdClass) % line   33, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

(postgres7): DELETE FROM mdl_log_display WHERE module = 'course'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation mdl_log_display in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(DELETE FROM mdl_log_display WHERE module = 'course', false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(DELETE FROM mdl_log_display WHERE module = 'course') % line 1094, file: datalib.php
delete_records(log_display, module, course) % line   35, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

(postgres7): SELECT * FROM mdl_log_display WHERE id = '-1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: column "id" does not exist LINE 1: SELECT * FROM mdl_log_display WHERE id = '-1' ^ in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(SELECT * FROM mdl_log_display WHERE id = '-1', false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(SELECT * FROM mdl_log_display WHERE id = '-1') % line 1140, file: datalib.php
insert_record(log_display, Object:stdClass) % line   40, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

(postgres7): SELECT * FROM mdl_log_display WHERE id = '-1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: column "id" does not exist LINE 1: SELECT * FROM mdl_log_display WHERE id = '-1' ^ in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(SELECT * FROM mdl_log_display WHERE id = '-1', false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(SELECT * FROM mdl_log_display WHERE id = '-1') % line 1140, file: datalib.php
insert_record(log_display, Object:stdClass) % line   42, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

(postgres7): SELECT * FROM mdl_log_display WHERE id = '-1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: column "id" does not exist LINE 1: SELECT * FROM mdl_log_display WHERE id = '-1' ^ in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(SELECT * FROM mdl_log_display WHERE id = '-1', false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(SELECT * FROM mdl_log_display WHERE id = '-1') % line 1140, file: datalib.php
insert_record(log_display, Object:stdClass) % line   44, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

(postgres7): CREATE TABLE mdl_user_coursecreators ( id int8 SERIAL PRIMARY KEY, userid int8 NOT NULL default '0' )  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "SERIAL" LINE 2: id int8 SERIAL PRIMARY KEY... ^ in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(CREATE TABLE mdl_user_coursecreators (
                                  id int8 SERIAL PRIMARY KEY,
                           ..., false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(CREATE TABLE mdl_user_coursecreators (
                                  id int8 SERIAL PRIMARY KEY,
                           ...) % line   55, file: datalib.php
execute_sql(CREATE TABLE mdl_user_coursecreators (
                                  id int8 SERIAL PRIMARY KEY,
                           ...) % line   52, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): BEGIN  
Success


(postgres7): ALTER TABLE mdl_course_modules ADD COLUMN "visible_alter_column_tmp" INT  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_course_modules in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_modules ADD COLUMN "visible_alter_column_tmp" INT, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_modules ADD COLUMN "visible_alter_column_tmp" INT) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_modules ADD COLUMN "visible_alter_column_tmp" INT) % line  312, file: datalib.php
table_column(course_modules, , visible, integer, 1, unsigned, 1, not null, score) % line   56, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_course_modules SET "visible_alter_column_tmp"='1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_course_modules SET "visible_alter_column_tmp"='1', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_course_modules SET "visible_alter_column_tmp"='1') % line   55, file: datalib.php
   execute_sql(UPDATE mdl_course_modules SET "visible_alter_column_tmp"='1') % line  314, file: datalib.php
table_column(course_modules, , visible, integer, 1, unsigned, 1, not null, score) % line   56, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_course_modules SET "visible_alter_column_tmp"='1' WHERE "visible_alter_column_tmp" IS NULL  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_course_modules SET "visible_alter_column_tmp"='1' WHERE "visible_alter_column_tmp" IS NULL, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_course_modules SET "visible_alter_column_tmp"='1' WHERE "visible_alter_column_tmp" IS NULL) % line   55, file: datalib.php
   execute_sql(UPDATE mdl_course_modules SET "visible_alter_column_tmp"='1' WHERE "visible_alter_column_tmp" IS NULL) % line  321, file: datalib.php
table_column(course_modules, , visible, integer, 1, unsigned, 1, not null, score) % line   56, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_modules ALTER COLUMN "visible_alter_column_tmp" SET not null  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_modules ALTER COLUMN "visible_alter_column_tmp" SET not null, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_modules ALTER COLUMN "visible_alter_column_tmp" SET not null) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_modules ALTER COLUMN "visible_alter_column_tmp" SET not null) % line  322, file: datalib.php
table_column(course_modules, , visible, integer, 1, unsigned, 1, not null, score) % line   56, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_modules ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_modules ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_modules ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1') % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_modules ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1') % line  328, file: datalib.php
table_column(course_modules, , visible, integer, 1, unsigned, 1, not null, score) % line   56, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_modules RENAME COLUMN "visible_alter_column_tmp" TO "visible"  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_modules RENAME COLUMN "visible_alter_column_tmp" TO "visible", false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_modules RENAME COLUMN "visible_alter_column_tmp" TO "visible") % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_modules RENAME COLUMN "visible_alter_column_tmp" TO "visible") % line  353, file: datalib.php
table_column(course_modules, , visible, integer, 1, unsigned, 1, not null, score) % line   56, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): COMMIT  
Success

Attempting to update permissions for all files... ignore any errors./home/yourmcom/public_html/pd/moodledata/2/WebApps/DWTeamsTable.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/InsertTable.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/PagingDialog.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/PagingLinkTable.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/PagingMenu.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/PagingRS.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/PagingRptRegion.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/addstudentQ.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/blankmysqlconn.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/blanksitebox.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/captivMovie/WAMPInstall.htm
/home/yourmcom/public_html/pd/moodledata/2/WebApps/captivMovie/WAMPInstall.swf
/home/yourmcom/public_html/pd/moodledata/2/WebApps/creatingsessvarbl.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/defineaccesslvls.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/grademenu.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/insertStudRecord.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/locateTeachersQ.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/loginuser.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/logoutuser.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/mysqlconnsettings.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/namelookupQ.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/parameterWind.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/repeatregion.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/repeatregionbox.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/restrictaccesstopage.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/selectedTchrName.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/selectingrow.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/sessioncode.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/sshots.zip
/home/yourmcom/public_html/pd/moodledata/2/WebApps/teamsClassQAdv.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/teamsClassQAdv2.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/teamsClassQTest.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/teamsClassQfinished.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/teamsClassQstart.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/teamsMenuQuery.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/updateTchrQ.png
/home/yourmcom/public_html/pd/moodledata/2/WebApps/updaterecord.png
/home/yourmcom/public_html/pd/moodledata/2/WebAppsFiles/DB.zip
/home/yourmcom/public_html/pd/moodledata/2/WebAppsFiles/PHPClass.zip
/home/yourmcom/public_html/pd/moodledata/sessions/sess_01a9dcaf27dd42b748c20a69cce3dbbb
/home/yourmcom/public_html/pd/moodledata/sessions/sess_04c2e4c99ae336417b078c2ffc0473bf
/home/yourmcom/public_html/pd/moodledata/sessions/sess_054315298ef0038bdb0f6caa567a45ff
/home/yourmcom/public_html/pd/moodledata/sessions/sess_069b257052905be655a72497117bceac
/home/yourmcom/public_html/pd/moodledata/sessions/sess_08ed39d783dd1bce321e0d1db2fae5b6
/home/yourmcom/public_html/pd/moodledata/sessions/sess_09c31eb1cfb8fc093af68e1a6125fc6c
/home/yourmcom/public_html/pd/moodledata/sessions/sess_0b262c88807f073583be0ebd7f437107
/home/yourmcom/public_html/pd/moodledata/sessions/sess_0b29d3dec229e37a84a4f6fd6cc7bd21
/home/yourmcom/public_html/pd/moodledata/sessions/sess_0f8ffd498fd7575cd33c5f5c24951032
/home/yourmcom/public_html/pd/moodledata/sessions/sess_0fc6076543ae385ff15ed773fef0393c
/home/yourmcom/public_html/pd/moodledata/sessions/sess_1a7d7b7ef2cab92f542ac0121fd88a11
/home/yourmcom/public_html/pd/moodledata/sessions/sess_1cb6c91fe45be2156f242ba954ffd9d1
/home/yourmcom/public_html/pd/moodledata/sessions/sess_24605041068df02711d1abac415075bd
/home/yourmcom/public_html/pd/moodledata/sessions/sess_34f505be00623972074d0d8b07db780e
/home/yourmcom/public_html/pd/moodledata/sessions/sess_361ef9981c532a8300a16fe096b3cadb
/home/yourmcom/public_html/pd/moodledata/sessions/sess_365ea4187c49d4ee06d7b97fc64c8e62
/home/yourmcom/public_html/pd/moodledata/sessions/sess_37220e3b985e19f55fc0296b12c21395
/home/yourmcom/public_html/pd/moodledata/sessions/sess_3e7f1c931c6f9d1b9a8efc3a25d76ede
/home/yourmcom/public_html/pd/moodledata/sessions/sess_3eca09ac2d3e74778ac757944e617295
/home/yourmcom/public_html/pd/moodledata/sessions/sess_40ae6da543b3a4742e46c14d7ad12900
/home/yourmcom/public_html/pd/moodledata/sessions/sess_4169d08e21e0df3eb93e1d66c8615dc9
/home/yourmcom/public_html/pd/moodledata/sessions/sess_4c6492e2ce7d0df5bda58ee90288a735
/home/yourmcom/public_html/pd/moodledata/sessions/sess_51da31461f7ce53da231ac4796b1c8d3
/home/yourmcom/public_html/pd/moodledata/sessions/sess_527e3b3e163f15b6d49e6c242285e480
/home/yourmcom/public_html/pd/moodledata/sessions/sess_591afc735bc270f9e6d6509eccc7ff64
/home/yourmcom/public_html/pd/moodledata/sessions/sess_595f79d52c958664e447619aa884a5e2
/home/yourmcom/public_html/pd/moodledata/sessions/sess_66b0ec50af4651fb06d6ab8b2301e3f6
/home/yourmcom/public_html/pd/moodledata/sessions/sess_6b59afdf76531d826de03f2ac94a66f5
/home/yourmcom/public_html/pd/moodledata/sessions/sess_805f2135b76b16c56025828f6b817def
/home/yourmcom/public_html/pd/moodledata/sessions/sess_8ba666f9c9ce3af6c5cdc6dab5a656bc
/home/yourmcom/public_html/pd/moodledata/sessions/sess_8d787428ccf770d39db70c38a4f24955
/home/yourmcom/public_html/pd/moodledata/sessions/sess_95983949608856768836486f9cebc2f1
/home/yourmcom/public_html/pd/moodledata/sessions/sess_a16874795b7dce1f4f893f71abab5b0b
/home/yourmcom/public_html/pd/moodledata/sessions/sess_a92a6c3cf7eb766972bc65547acc86fc
/home/yourmcom/public_html/pd/moodledata/sessions/sess_ac47cb3712faf467438fbc47999d6e76
/home/yourmcom/public_html/pd/moodledata/sessions/sess_b07e70dad44a4e6ec9768d69e740e70a
/home/yourmcom/public_html/pd/moodledata/sessions/sess_b5a7e172deeb9f0f8582ad76df1f4438
/home/yourmcom/public_html/pd/moodledata/sessions/sess_c15e0da23fed5cfc2e25d974003c30e3
/home/yourmcom/public_html/pd/moodledata/sessions/sess_ce3b0e2440d15c30087f8acecd833ff1
/home/yourmcom/public_html/pd/moodledata/sessions/sess_d84e1ebeee0485ae88e5dec3f926d245
/home/yourmcom/public_html/pd/moodledata/sessions/sess_dcf3dd53d6fc09ed652325d3bb55f3a1
/home/yourmcom/public_html/pd/moodledata/sessions/sess_e658d0190bd5bb924db4a275de9994c9
/home/yourmcom/public_html/pd/moodledata/sessions/sess_f29f3caabe978e8f60f700bc45a3fbb1
/home/yourmcom/public_html/pd/moodledata/sessions/sess_f2df5e5f2a20d8b92c5603a8596c0989
/home/yourmcom/public_html/pd/moodledata/sessions/sess_fdcf3d312e569385d103986ed52c30f1
/home/yourmcom/public_html/pd/moodledata/users/19/f1.jpg
/home/yourmcom/public_html/pd/moodledata/users/19/f2.jpg
/home/yourmcom/public_html/pd/moodledata/users/2/f1.jpg
/home/yourmcom/public_html/pd/moodledata/users/2/f2.jpg

(postgres7): SELECT * FROM mdl_course  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation mdl_course in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(SELECT * FROM mdl_course, false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(SELECT * FROM mdl_course) % line  812, file: datalib.php
get_records_sql(SELECT * FROM mdl_course) % line   71, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

(postgres7): SELECT id, username FROM mdl_user  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation mdl_user in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(SELECT id, username FROM mdl_user, false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(SELECT id, username FROM mdl_user) % line  812, file: datalib.php
get_records_sql(SELECT id, username FROM mdl_user) % line   85, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Warning: Invalid argument supplied for foreach() in /home/yourmcom/public_html/pd/moodle/lib/db/postgres7.php on line 89
Checking userdatabase:

Warning: Invalid argument supplied for foreach() in /home/yourmcom/public_html/pd/moodle/lib/db/postgres7.php on line 107

(postgres7): CREATE INDEX mdl_log_coursemoduleaction_idx ON mdl_log (course,module,action)  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_log in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute( CREATE INDEX mdl_log_coursemoduleaction_idx ON mdl_log (course,module,action) , false) % line  854, file: adodb.inc.php
   ADOConnection.Execute( CREATE INDEX mdl_log_coursemoduleaction_idx ON mdl_log (course,module,action) ) % line   55, file: datalib.php
execute_sql( CREATE INDEX mdl_log_coursemoduleaction_idx ON mdl_log (course,module,action) ) % line  130, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): CREATE INDEX mdl_log_courseuserid_idx ON mdl_log (course,userid)  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_log in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute( CREATE INDEX mdl_log_courseuserid_idx ON mdl_log (course,userid) , false) % line  854, file: adodb.inc.php
   ADOConnection.Execute( CREATE INDEX mdl_log_courseuserid_idx ON mdl_log (course,userid) ) % line   55, file: datalib.php
execute_sql( CREATE INDEX mdl_log_courseuserid_idx ON mdl_log (course,userid) ) % line  131, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): CREATE TABLE mdl_course_display ( id SERIAL PRIMARY KEY, course integer NOT NULL default '0', userid integer NOT NULL default '0', display integer NOT NULL default '0' )  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "mdl_course_display" already exists in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(CREATE TABLE mdl_course_display (
                         id SERIAL PRIMARY KEY,
                         course integer NOT NU..., false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(CREATE TABLE mdl_course_display (
                         id SERIAL PRIMARY KEY,
                         course integer NOT NU...) % line   55, file: datalib.php
execute_sql(CREATE TABLE mdl_course_display (
                         id SERIAL PRIMARY KEY,
                         course integer NOT NU...) % line  140, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): CREATE INDEX mdl_course_display_courseuserid_idx ON mdl_course_display (course,userid)  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_course_display in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute(CREATE INDEX mdl_course_display_courseuserid_idx ON mdl_course_display (course,userid), false) % line  854, file: adodb.inc.php
   ADOConnection.Execute(CREATE INDEX mdl_course_display_courseuserid_idx ON mdl_course_display (course,userid)) % line   55, file: datalib.php
execute_sql(CREATE INDEX mdl_course_display_courseuserid_idx ON mdl_course_display (course,userid)) % line  142, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): BEGIN  
Success


(postgres7): ALTER TABLE mdl_course_sections ADD COLUMN "visible_alter_column_tmp" INT  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_course_sections in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_sections ADD COLUMN "visible_alter_column_tmp" INT, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_sections ADD COLUMN "visible_alter_column_tmp" INT) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_sections ADD COLUMN "visible_alter_column_tmp" INT) % line  312, file: datalib.php
table_column(course_sections, , visible, integer, 1, unsigned, 1, , ) % line  146, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_course_sections SET "visible_alter_column_tmp"='1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_course_sections SET "visible_alter_column_tmp"='1', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_course_sections SET "visible_alter_column_tmp"='1') % line   55, file: datalib.php
   execute_sql(UPDATE mdl_course_sections SET "visible_alter_column_tmp"='1') % line  314, file: datalib.php
table_column(course_sections, , visible, integer, 1, unsigned, 1, , ) % line  146, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_sections ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_sections ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_sections ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_sections ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL) % line  324, file: datalib.php
table_column(course_sections, , visible, integer, 1, unsigned, 1, , ) % line  146, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_sections ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_sections ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_sections ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1') % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_sections ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1') % line  328, file: datalib.php
table_column(course_sections, , visible, integer, 1, unsigned, 1, , ) % line  146, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_sections RENAME COLUMN "visible_alter_column_tmp" TO "visible"  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_sections RENAME COLUMN "visible_alter_column_tmp" TO "visible", false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_sections RENAME COLUMN "visible_alter_column_tmp" TO "visible") % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_sections RENAME COLUMN "visible_alter_column_tmp" TO "visible") % line  353, file: datalib.php
table_column(course_sections, , visible, integer, 1, unsigned, 1, , ) % line  146, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): COMMIT  
Success


(postgres7): BEGIN  
Success


(postgres7): ALTER TABLE mdl_user ADD COLUMN "lang_alter_column_tmp" VARCHAR(5)  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_user in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_user ADD COLUMN "lang_alter_column_tmp" VARCHAR(5), false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_user ADD COLUMN "lang_alter_column_tmp" VARCHAR(5)) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_user ADD COLUMN "lang_alter_column_tmp" VARCHAR(5)) % line  312, file: datalib.php
table_column(user, , lang, VARCHAR, 5, , en, NOT NULL, ) % line  150, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_user SET "lang_alter_column_tmp"='en'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_user SET "lang_alter_column_tmp"='en', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_user SET "lang_alter_column_tmp"='en') % line   55, file: datalib.php
   execute_sql(UPDATE mdl_user SET "lang_alter_column_tmp"='en') % line  314, file: datalib.php
table_column(user, , lang, VARCHAR, 5, , en, NOT NULL, ) % line  150, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_user SET "lang_alter_column_tmp"='en' WHERE "lang_alter_column_tmp" IS NULL  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_user SET "lang_alter_column_tmp"='en' WHERE "lang_alter_column_tmp" IS NULL, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_user SET "lang_alter_column_tmp"='en' WHERE "lang_alter_column_tmp" IS NULL) % line   55, file: datalib.php
   execute_sql(UPDATE mdl_user SET "lang_alter_column_tmp"='en' WHERE "lang_alter_column_tmp" IS NULL) % line  321, file: datalib.php
table_column(user, , lang, VARCHAR, 5, , en, NOT NULL, ) % line  150, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_user ALTER COLUMN "lang_alter_column_tmp" SET NOT NULL  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_user ALTER COLUMN "lang_alter_column_tmp" SET NOT NULL, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_user ALTER COLUMN "lang_alter_column_tmp" SET NOT NULL) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_user ALTER COLUMN "lang_alter_column_tmp" SET NOT NULL) % line  322, file: datalib.php
table_column(user, , lang, VARCHAR, 5, , en, NOT NULL, ) % line  150, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_user ALTER COLUMN "lang_alter_column_tmp" SET DEFAULT 'en'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_user ALTER COLUMN "lang_alter_column_tmp" SET DEFAULT 'en', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_user ALTER COLUMN "lang_alter_column_tmp" SET DEFAULT 'en') % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_user ALTER COLUMN "lang_alter_column_tmp" SET DEFAULT 'en') % line  328, file: datalib.php
table_column(user, , lang, VARCHAR, 5, , en, NOT NULL, ) % line  150, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_user RENAME COLUMN "lang_alter_column_tmp" TO "lang"  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_user RENAME COLUMN "lang_alter_column_tmp" TO "lang", false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_user RENAME COLUMN "lang_alter_column_tmp" TO "lang") % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_user RENAME COLUMN "lang_alter_column_tmp" TO "lang") % line  353, file: datalib.php
table_column(user, , lang, VARCHAR, 5, , en, NOT NULL, ) % line  150, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): COMMIT  
Success


(postgres7): BEGIN  
Success


(postgres7): ALTER TABLE mdl_modules ADD COLUMN "visible_alter_column_tmp" INT  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_modules in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_modules ADD COLUMN "visible_alter_column_tmp" INT, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_modules ADD COLUMN "visible_alter_column_tmp" INT) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_modules ADD COLUMN "visible_alter_column_tmp" INT) % line  312, file: datalib.php
table_column(modules, , visible, integer, 1, unsigned, 1, , ) % line  154, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_modules SET "visible_alter_column_tmp"='1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_modules SET "visible_alter_column_tmp"='1', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_modules SET "visible_alter_column_tmp"='1') % line   55, file: datalib.php
   execute_sql(UPDATE mdl_modules SET "visible_alter_column_tmp"='1') % line  314, file: datalib.php
table_column(modules, , visible, integer, 1, unsigned, 1, , ) % line  154, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_modules ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_modules ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_modules ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_modules ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL) % line  324, file: datalib.php
table_column(modules, , visible, integer, 1, unsigned, 1, , ) % line  154, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_modules ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_modules ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_modules ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1') % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_modules ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1') % line  328, file: datalib.php
table_column(modules, , visible, integer, 1, unsigned, 1, , ) % line  154, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_modules RENAME COLUMN "visible_alter_column_tmp" TO "visible"  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_modules RENAME COLUMN "visible_alter_column_tmp" TO "visible", false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_modules RENAME COLUMN "visible_alter_column_tmp" TO "visible") % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_modules RENAME COLUMN "visible_alter_column_tmp" TO "visible") % line  353, file: datalib.php
table_column(modules, , visible, integer, 1, unsigned, 1, , ) % line  154, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): COMMIT  
Success


(postgres7): SELECT * FROM mdl_modules WHERE name = 'pgassignment'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: permission denied for relation mdl_modules in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(SELECT * FROM mdl_modules WHERE name = 'pgassignment'  , false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(SELECT * FROM mdl_modules WHERE name = 'pgassignment'  ) % line  812, file: datalib.php
   get_records_sql(SELECT * FROM mdl_modules WHERE name = 'pgassignment'  ) % line  718, file: datalib.php
get_records(modules, name, pgassignment) % line  158, file: postgres7.php
main_upgrade(0) % line  193, file: index.php
Thanks for upgrading!

There are many changes since the last release. Please read the release notes carefully. If you are using CUSTOM themes you will need to edit them. You will also need to check your site's config.php file.


(postgres7): BEGIN  
Success


(postgres7): ALTER TABLE mdl_user ADD COLUMN "autosubscribe_alter_column_tmp" INT  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_user in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_user ADD COLUMN "autosubscribe_alter_column_tmp" INT, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_user ADD COLUMN "autosubscribe_alter_column_tmp" INT) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_user ADD COLUMN "autosubscribe_alter_column_tmp" INT) % line  312, file: datalib.php
table_column(user, , autosubscribe, integer, 1, unsigned, 1, , htmleditor) % line  168, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_user SET "autosubscribe_alter_column_tmp"='1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_user SET "autosubscribe_alter_column_tmp"='1', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_user SET "autosubscribe_alter_column_tmp"='1') % line   55, file: datalib.php
   execute_sql(UPDATE mdl_user SET "autosubscribe_alter_column_tmp"='1') % line  314, file: datalib.php
table_column(user, , autosubscribe, integer, 1, unsigned, 1, , htmleditor) % line  168, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_user ALTER COLUMN "autosubscribe_alter_column_tmp" DROP NOT NULL  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_user ALTER COLUMN "autosubscribe_alter_column_tmp" DROP NOT NULL, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_user ALTER COLUMN "autosubscribe_alter_column_tmp" DROP NOT NULL) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_user ALTER COLUMN "autosubscribe_alter_column_tmp" DROP NOT NULL) % line  324, file: datalib.php
table_column(user, , autosubscribe, integer, 1, unsigned, 1, , htmleditor) % line  168, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_user ALTER COLUMN "autosubscribe_alter_column_tmp" SET DEFAULT '1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_user ALTER COLUMN "autosubscribe_alter_column_tmp" SET DEFAULT '1', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_user ALTER COLUMN "autosubscribe_alter_column_tmp" SET DEFAULT '1') % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_user ALTER COLUMN "autosubscribe_alter_column_tmp" SET DEFAULT '1') % line  328, file: datalib.php
table_column(user, , autosubscribe, integer, 1, unsigned, 1, , htmleditor) % line  168, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_user RENAME COLUMN "autosubscribe_alter_column_tmp" TO "autosubscribe"  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_user RENAME COLUMN "autosubscribe_alter_column_tmp" TO "autosubscribe", false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_user RENAME COLUMN "autosubscribe_alter_column_tmp" TO "autosubscribe") % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_user RENAME COLUMN "autosubscribe_alter_column_tmp" TO "autosubscribe") % line  353, file: datalib.php
table_column(user, , autosubscribe, integer, 1, unsigned, 1, , htmleditor) % line  168, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): COMMIT  
Success


(postgres7): BEGIN  
Success


(postgres7): ALTER TABLE mdl_course ADD COLUMN "visible_alter_column_tmp" INT  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_course in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course ADD COLUMN "visible_alter_column_tmp" INT, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course ADD COLUMN "visible_alter_column_tmp" INT) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course ADD COLUMN "visible_alter_column_tmp" INT) % line  312, file: datalib.php
table_column(course, , visible, integer, 1, unsigned, 1, , marker) % line  172, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_course SET "visible_alter_column_tmp"='1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_course SET "visible_alter_column_tmp"='1', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_course SET "visible_alter_column_tmp"='1') % line   55, file: datalib.php
   execute_sql(UPDATE mdl_course SET "visible_alter_column_tmp"='1') % line  314, file: datalib.php
table_column(course, , visible, integer, 1, unsigned, 1, , marker) % line  172, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course ALTER COLUMN "visible_alter_column_tmp" DROP NOT NULL) % line  324, file: datalib.php
table_column(course, , visible, integer, 1, unsigned, 1, , marker) % line  172, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1'  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1') % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course ALTER COLUMN "visible_alter_column_tmp" SET DEFAULT '1') % line  328, file: datalib.php
table_column(course, , visible, integer, 1, unsigned, 1, , marker) % line  172, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course RENAME COLUMN "visible_alter_column_tmp" TO "visible"  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course RENAME COLUMN "visible_alter_column_tmp" TO "visible", false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course RENAME COLUMN "visible_alter_column_tmp" TO "visible") % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course RENAME COLUMN "visible_alter_column_tmp" TO "visible") % line  353, file: datalib.php
table_column(course, , visible, integer, 1, unsigned, 1, , marker) % line  172, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): COMMIT  
Success


(postgres7): BEGIN  
Success


(postgres7): ALTER TABLE mdl_course_sections ADD COLUMN "sequence_alter_column_tmp" text  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_course_sections in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_sections ADD COLUMN "sequence_alter_column_tmp" text, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_sections ADD COLUMN "sequence_alter_column_tmp" text) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_sections ADD COLUMN "sequence_alter_column_tmp" text) % line  312, file: datalib.php
table_column(course_sections, sequence, sequence, text, , , , , ) % line  176, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_course_sections SET "sequence_alter_column_tmp"=''  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_course_sections SET "sequence_alter_column_tmp"='', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_course_sections SET "sequence_alter_column_tmp"='') % line   55, file: datalib.php
   execute_sql(UPDATE mdl_course_sections SET "sequence_alter_column_tmp"='') % line  314, file: datalib.php
table_column(course_sections, sequence, sequence, text, , , , , ) % line  176, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_sections ALTER COLUMN "sequence_alter_column_tmp" DROP NOT NULL  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_sections ALTER COLUMN "sequence_alter_column_tmp" DROP NOT NULL, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_sections ALTER COLUMN "sequence_alter_column_tmp" DROP NOT NULL) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_sections ALTER COLUMN "sequence_alter_column_tmp" DROP NOT NULL) % line  324, file: datalib.php
table_column(course_sections, sequence, sequence, text, , , , , ) % line  176, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_sections ALTER COLUMN "sequence_alter_column_tmp" SET DEFAULT ''  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_sections ALTER COLUMN "sequence_alter_column_tmp" SET DEFAULT '', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_sections ALTER COLUMN "sequence_alter_column_tmp" SET DEFAULT '') % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_sections ALTER COLUMN "sequence_alter_column_tmp" SET DEFAULT '') % line  328, file: datalib.php
table_column(course_sections, sequence, sequence, text, , , , , ) % line  176, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): SELECT "sequence" FROM mdl_course_sections LIMIT 0  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(SELECT "sequence" FROM mdl_course_sections LIMIT 0, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(SELECT "sequence" FROM mdl_course_sections LIMIT 0) % line  406, file: datalib.php
   column_type(course_sections, "sequence") % line  334, file: datalib.php
table_column(course_sections, sequence, sequence, text, , , , , ) % line  176, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

(postgres7): SELECT "sequence_alter_column_tmp" FROM mdl_course_sections LIMIT 0  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(SELECT "sequence_alter_column_tmp" FROM mdl_course_sections LIMIT 0, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(SELECT "sequence_alter_column_tmp" FROM mdl_course_sections LIMIT 0) % line  406, file: datalib.php
   column_type(course_sections, "sequence_alter_column_tmp") % line  335, file: datalib.php
table_column(course_sections, sequence, sequence, text, , , , , ) % line  176, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

(postgres7): UPDATE mdl_course_sections SET "sequence_alter_column_tmp" = "sequence"  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_course_sections SET "sequence_alter_column_tmp" = "sequence", false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_course_sections SET "sequence_alter_column_tmp" = "sequence") % line   55, file: datalib.php
   execute_sql(UPDATE mdl_course_sections SET "sequence_alter_column_tmp" = "sequence") % line  349, file: datalib.php
table_column(course_sections, sequence, sequence, text, , , , , ) % line  176, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_sections DROP COLUMN "sequence"  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE  mdl_course_sections DROP COLUMN "sequence", false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE  mdl_course_sections DROP COLUMN "sequence") % line   55, file: datalib.php
   execute_sql(ALTER TABLE  mdl_course_sections DROP COLUMN "sequence") % line  350, file: datalib.php
table_column(course_sections, sequence, sequence, text, , , , , ) % line  176, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_sections RENAME COLUMN "sequence_alter_column_tmp" TO "sequence"  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_sections RENAME COLUMN "sequence_alter_column_tmp" TO "sequence", false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_sections RENAME COLUMN "sequence_alter_column_tmp" TO "sequence") % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_sections RENAME COLUMN "sequence_alter_column_tmp" TO "sequence") % line  353, file: datalib.php
table_column(course_sections, sequence, sequence, text, , , , , ) % line  176, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): COMMIT  
Success

The following database index improves performance, but can be quite large - if you are upgrading and you have problems with a limited quota you may want to delete this index later from the 'mdl_log' table in your database

(postgres7): CREATE INDEX mdl_log_timecoursemoduleaction_idx ON mdl_log (time,course,module,action)  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_log in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute( CREATE INDEX mdl_log_timecoursemoduleaction_idx ON mdl_log (time,course,module,action) , false) % line  854, file: adodb.inc.php
   ADOConnection.Execute( CREATE INDEX mdl_log_timecoursemoduleaction_idx ON mdl_log (time,course,module,action) ) % line   55, file: datalib.php
execute_sql( CREATE INDEX mdl_log_timecoursemoduleaction_idx ON mdl_log (time,course,module,action) ) % line  182, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): CREATE INDEX mdl_user_students_courseuserid_idx ON mdl_user_students (course,userid)  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_user_students in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute( CREATE INDEX mdl_user_students_courseuserid_idx ON mdl_user_students (course,userid) , false) % line  854, file: adodb.inc.php
   ADOConnection.Execute( CREATE INDEX mdl_user_students_courseuserid_idx ON mdl_user_students (course,userid) ) % line   55, file: datalib.php
execute_sql( CREATE INDEX mdl_user_students_courseuserid_idx ON mdl_user_students (course,userid) ) % line  183, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): CREATE INDEX mdl_user_teachers_courseuserid_idx ON mdl_user_teachers (course,userid)  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_user_teachers in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
      ADOConnection._Execute( CREATE INDEX mdl_user_teachers_courseuserid_idx ON mdl_user_teachers (course,userid) , false) % line  854, file: adodb.inc.php
   ADOConnection.Execute( CREATE INDEX mdl_user_teachers_courseuserid_idx ON mdl_user_teachers (course,userid) ) % line   55, file: datalib.php
execute_sql( CREATE INDEX mdl_user_teachers_courseuserid_idx ON mdl_user_teachers (course,userid) ) % line  184, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): BEGIN  
Success


(postgres7): ALTER TABLE mdl_course_categories ADD COLUMN "description_alter_column_tmp" text  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: must be owner of relation mdl_course_categories in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_categories ADD COLUMN "description_alter_column_tmp" text, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_categories ADD COLUMN "description_alter_column_tmp" text) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_categories ADD COLUMN "description_alter_column_tmp" text) % line  312, file: datalib.php
table_column(course_categories, , description, text, , , ) % line  188, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_course_categories SET "description_alter_column_tmp"=''  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_course_categories SET "description_alter_column_tmp"='', false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_course_categories SET "description_alter_column_tmp"='') % line   55, file: datalib.php
   execute_sql(UPDATE mdl_course_categories SET "description_alter_column_tmp"='') % line  314, file: datalib.php
table_column(course_categories, , description, text, , , ) % line  188, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): UPDATE mdl_course_categories SET "description_alter_column_tmp"='' WHERE "description_alter_column_tmp" IS NULL  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(UPDATE mdl_course_categories SET "description_alter_column_tmp"='' WHERE "description_alter_column_tmp" IS NULL, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(UPDATE mdl_course_categories SET "description_alter_column_tmp"='' WHERE "description_alter_column_tmp" IS NULL) % line   55, file: datalib.php
   execute_sql(UPDATE mdl_course_categories SET "description_alter_column_tmp"='' WHERE "description_alter_column_tmp" IS NULL) % line  321, file: datalib.php
table_column(course_categories, , description, text, , , ) % line  188, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_categories ALTER COLUMN "description_alter_column_tmp" SET not null  

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /home/yourmcom/public_html/pd/moodle/lib/adodb/drivers/adodb-postgres7.inc.php on line 110
-1: ERROR: permission denied for relation mdl_log_display
         ADOConnection._Execute(ALTER TABLE mdl_course_categories ALTER COLUMN "description_alter_column_tmp" SET not null, false) % line  854, file: adodb.inc.php
      ADOConnection.Execute(ALTER TABLE mdl_course_categories ALTER COLUMN "description_alter_column_tmp" SET not null) % line   55, file: datalib.php
   execute_sql(ALTER TABLE mdl_course_categories ALTER COLUMN "description_alter_column_tmp" SET not null) % line  322, file: datalib.php
table_column(course_categories, , description, text, , , ) % line  188, file: postgres7.php
main_upgrade(0) % line  193, file: index.php

Error


(postgres7): ALTER TABLE mdl_course_categories ALTER COLUMN