In the spirit of my blog post last week, I've created a new page that shows a couple of the more common error messages that confuse newer PostgreSQL users. It is my intention to expand this over time as I see people having trouble.
If you have any error messages you feel should be included or you find any technical inaccuracies please post a comment and I'll include it on the page.