Hi!
What version of postgres are you using? Older versions don't understand SERIAL8.
If you can't upgrade postgres, I would suggest finding all instances of SERIAL8 and changing them to SERIAL.
If you have shell access you could do something like
cd /hsphere/local/home/skasztan/parentsagainstdrugs.com/AZVS
grep -r -i 'SERIAL8' *
That should give you a list of all the files that have SERIAL8.
You may also have problems with some index names being too long and getting truncated (which causes name conflicts) with pre 7.4 postgres.
Edit: forgot to mention, there are a few items in the bug tracker about compatibility with older versions of postgres -
http://moodle.org/bugs/bug.php?op=show&bugid=2326&pos=13
http://moodle.org/bugs/bug.php?op=show&bugid=2203&pos=17
http://moodle.org/bugs/bug.php?op=show&bugid=2326&pos=26
Installing and upgrading help
postgres7 install stuck on building mdl_block
This discussion has been locked so you can no longer reply to it.