You do not have to define field type when referencing. Field('fieldname', db.referencetable)
No need to define as 'integer' http://zerp.ly/rochacbruno Em 08/08/2011 17:46, "Ramiro B. da Luz" <ramiro...@gmail.com> escreveu: > I asked this in the irc channel but as I was leaving I pasted it here: > > hello. > I am using web2py version Version 1.98.2 (2011-08-04 00:47:09) with a > legacy postgreql database. > When I do an insert using the databse administration or when I try to > update a record I get an strange error. > I notice that the error contains the name of the table. > > ValueError: invalid literal for int() with base 10: 't_fone' > > The database definition is here: http://pastie.textmate.org/2341175 > > I saw some similar issues but I have a different problem. In the > issues I saw that the > value was empty, in my case the values are table names. > > Thank you. > > -- > -- > -- Ramiro Batista da Luz > -- ramiro...@gmail.com > -- (41) 9173-2231 > -- http://www.ramiroluz.eti.br > -- Programador || Câmara Municipal de Curitiba