search

martinjt / elmah

Automatically exported from code.google.com/p/elmah
Apache License 2.0
0 stars 0 forks source link

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

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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 commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
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 commented 9 years ago 
Assigning to Laimonas Simutis, who is the owner/maintainer of PgsqlErrorLog, 
for review.

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

GoogleCodeExporter commented 9 years ago 
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