Hi,
I've repatched the lesson module's db/postgres7.sql file. It now seems to work.
PostgreSQL didn't like the COMMENT = '...' things, so I moved those into real SQL92 comments.
File is attached.
Cheers,
Ulrik
Ulrik
Thanks for this. Yes, the comments are a bit of pain, not sure why we don't just use # and then the comment. Presumably PostgreSQL likes #'s as the file begins with them.
Also not sure why us MySQL people litter all the names up with back quotes, is there/was there a reason?
Also again, gone are those fiddly tinyints, int(3), int(10) just good old integers. Not sure just how much difference it makes performance and space wise using these partial integers instead of proper integers - not much I suspect
[Goes off to look for Martin database style notes....]
Thanks for this. Yes, the comments are a bit of pain, not sure why we don't just use # and then the comment. Presumably PostgreSQL likes #'s as the file begins with them.
Also not sure why us MySQL people litter all the names up with back quotes, is there/was there a reason?
Also again, gone are those fiddly tinyints, int(3), int(10) just good old integers. Not sure just how much difference it makes performance and space wise using these partial integers instead of proper integers - not much I suspect
[Goes off to look for Martin database style notes....]