q3 failing - 'courserecord' already exists

37 views
Skip to first unread message

Milena Davidson

unread,
May 15, 2018, 10:49:47 PM5/15/18
to COMP9311 Project Q&A
psql:proj2.sql:133: ERROR:  syntax error at or near "drop"
LINE 17: drop type if exists CourseRecord cascade;
         ^
psql:proj2.sql:134: ERROR:  type "courserecord" already exists
 
Has anyone else seen this error or have any tips on tracking it down?

Semisi Taufa

unread,
May 15, 2018, 11:49:50 PM5/15/18
to COMP9311 Project Q&A

It looks like your type CourseRecord was not dropped hence why it is still there. Try run drop statement only to see if it deletes it then try again
Reply all
Reply to author
Forward
0 new messages