PosgreSQL has its share of annoyances, like case preserving case insensitivity and inconsistent naming of its tools/config files.

Nothing like trying to do a select on a table/column that you know is there and getting an error...becuase the table/column was created with quotes by your ORM so it doesn't automagically get case in-sensitized.

It's maddening.