Get error when I connect to PostgreSQL database

[miguelcleon]

When I try to connect to an ODM2 database in PostgreSQL I get an error:

(ERROR) frmDBConfig:validateInput(104) - (psycopg2.ProgrammingError) relation "Variables" does not exist
LINE 1: Select "VariableCode" From "Variables" Limit 1

[SQL: Select "VariableCode" From "Variables" Limit 1']

This looks like a check that the ODM2 database is valid.

If the SQL was select variablecode from variables limit 1 it would work.

[miguelcleon]

This also works Select "variablecode" From "variables" Limit 1

I think this is a problem in that there is a mismatch between the table and column names this produces https://github.com/ODM2/ODM2/blob/master/src/blank_schema_scripts/postgresql/ODM2_for_PostgreSQL.sql and what is expected here.

[miguelcleon]

looks like the identifiers should just not be quoted so that PostgreSQL can ignore the case.

http://stackoverflow.com/questions/27434633/psycopg2-cannot-find-any-tables-after-connection

[miguelcleon]

@horsburgh This is the problem I'm still having that I mentioned at the meeting last month.