Postgres is case-sensitive for non-quoted table/column names

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Create ELMAH_Error table with correct capitalisation in a Postgres database
2. Try and access an ELMAH page

What is the expected output? What do you see instead?

ERROR: 42P01: relation "elmah_error" does not exist

This is because Postgres is case-sensitive for non-quoted table and column 
names. If you create the tables with the Pgsql.sql, they're also non-quoted and 
so therefore they get stored in the database as lower-case names.

Original issue reported on code.google.com by palfrey on 30 Apr 2014 at 1:42

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

https://code.google.com/r/palfrey-elmah/source/list?name=363_Postgres_CaseSensit
ive fixes this

Original comment by palfrey on 30 Apr 2014 at 2:12

[GoogleCodeExporter]

Assigning to Laimonas Simutis, who is the owner/maintainer of PgsqlErrorLog, 
for review.

Original comment by azizatif on 1 May 2014 at 4:51

• Added labels: Component-Persistence

[GoogleCodeExporter]

There is a very specific reason why Pgsql.sql and source code does not quote 
the names of tables and sequences: the best way to deal with case sensitivity 
issue is not to deal with it and store everything lower case.

In step 1 you state that you create table with "correct capitalization" and I 
would like to emphasize that that introduces lower/non-lowercase issues. Let's 
not complicate things and keep all the names all lowercase.

Also your proposed patch would break the existing installations as well.

Original comment by lai...@gmail.com on 14 Jun 2014 at 4:41

• Changed state: WontFix