[web2py] Re: Legacy PostgreSQL Database using case sensitive table and field names

2011-03-13 Thread Ross Peoples
I couldn't find anything in the PG docs. If I were to add another postgres adapter that specifically handles databases created like this, is that something you'd be interested in adding to web2py? On Friday, March 11, 2011 4:42:11 PM UTC-5, Massimo Di Pierro wrote: Then web2py cannot do this

[web2py] Re: Legacy PostgreSQL Database using case sensitive table and field names

2011-03-11 Thread Massimo Di Pierro
It cannot be Field('settingName', length=255, unique=True), must be Field('settingName', length=255, unique=True), you cannot have quotes in the file name. So it should be db.define_table('GlobalSettings', Field('settingName', length=255, unique=True), Field('settingValue', 'text'),

Re: [web2py] Re: Legacy PostgreSQL Database using case sensitive table and field names

2011-03-11 Thread Ross Peoples
I should have mentioned that I already did this, so now my table definition matches the one you gave. It was after correcting the definition that I get this message. Again, the tables and fields were created using double-quotes (e.g. CREATE TABLE GlobalSettings...), so PostgreSQL requires that

[web2py] Re: Legacy PostgreSQL Database using case sensitive table and field names

2011-03-11 Thread Massimo Di Pierro
Then web2py cannot do this (yet). You would need to create a view for your tables with lowercase table names or perhaps there is some obscure postgresql parameters to make the queries case sensitive (mysql has it). On Mar 11, 2:10 pm, Ross Peoples ross.peop...@gmail.com wrote: I should have

Re: [web2py] Re: Legacy PostgreSQL Database using case sensitive table and field names

2011-03-11 Thread pbreit
Note to self: never use capitals!