After also adding migrate=False to the table definition, I now get this
error:
ProgrammingError: relation "globalsettings" does not exist
LINE 1: ...ngs.settingName, GlobalSettings.settingValue FROM GlobalSett...
On Thursday, March 10, 2011 3:02:25 PM UTC-5, Richard wrote:
>
> remove the " from
remove the " from web2py model and add the sequence name that postgres
create by default with a different name then web2py expect like this :
db.define_table('GlobalSettings',
Field('settingName', length=255, unique=True),
Field('settingValue', 'text'),
Field('settingID', 'id'),
se
I have a legacy PostgreSQL database that has its tables and field names
created using a case-sensitive means. Whenever I try to do a select(), it
returns no rows, and an insert() fails. This is the error that web2py gives:
ProgrammingError: relation "globalsettings_id_seq" does not exist
LINE 1:
3 matches
Mail list logo
