Since there are no record you do not need conversion of string to decimals. You can do it in two steps: 1) comment the line that defines the field and run appadmin 2) uncomment the line, change the type and run appadmin done
On Thursday, 12 April 2012 15:37:26 UTC-5, Carlos wrote: > > Hi, > > Is it possible (and how) to change a field type from string to decimal > without recreating the table?. > > There are no records in the table yet, but I would like to know if there's > a way to accomplish this from web2py (without recreating the database). > > The error I get: > > <class 'psycopg2.ProgrammingError'> column "xfield__tmp" is of type > numeric but expression is of type character varying LINE 1: UPDATE xtable > SET xfield__tmp=xfield; ^ HINT: You will need to rewrite or cast the > expression. > > I'm using latest web2py trunk with postgresql. > > Thanks, > > Carlos > >
