This, BTW, is a great example why many filesystems are case sensitive -- ignoring case requires collation support, and this can change all the time. Treating filenames as opaque byte strings, on the other hand, makes the filesystems, databases and so on Always Work.

Of course, PostgreSQL is one the few programs which actually cares about collation and case-insensitivity, so it has to work the hard way.