Fixed the stupid thing. I worked out that when they transferred my stuff, they obviously didn’t check the tables very carefully. They forgot to make the postid field of the posts table AUTO INCREMENT in which case, the thing kept falling over when I was trying to post, because it went “oh, default value 0… but I have one of those already?”.

Yeah, take that stupid idiots. I just feel sorry for the people that say, don’t know about computers or databases and they would’ve been all upset that their thing borked.

In other news, I got my PL/pgSQL function WORKING today. YEAY!!!! It’s only a SMALL SMALL part of my thesis, but it makes me feel like I’ve accomplished something and that’s heaps good :D Hopefully this weekend will be filled with lots of writing of technical jargon and showing off cool pictures. I LOVE pgAdmin III’s “Explain” function. I mean, I know other programs have it, but I just like the way it visualises the query and makes this cool picture out of it. Very useful for seeing what’s going on, although the ’subquery’ icon isn’t useful – would be good if the subquery would also be explained and expanded to show the little graphics thing.