I just experienced the same problem using "app" on Google App Engine,
which wasted some time - it will be neat when the new DAL takes care
of these problems! (It will, right?)
On Feb 2, 8:48 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Hi Andreas,
>
> you have
>
> Field("date", 'date', unique = True)
>
> "date" is a reserved keyword and cannot be the name of a field/
> column.
>
> Massimo
>
> On Feb 1, 3:37 pm, baloan <balo...@googlemail.com> wrote:
>
> > Hello,
>
> > I'm using PostgreSQL. Changing db.py from
>
> > db.define_table('position',
> > Field("day", 'date', unique = True),
> > Field("quantity", "double"),
> > )
>
> > to
>
> > db.define_table('position',
> > Field("date", 'date', unique = True),
> > Field("quantity", "double"),
> > )
>
> > causes:
>
> > Traceback (most recent call last):
> > File "D:\Home\web\web2py\gluon\restricted.py", line 173, in
> > restricted
> > exec ccode in environment
> > File "applications\invest\models/db.py", line 95, in <module>
> > Field("quantity", "double"),
> > File "D:\Home\web\web2py\gluon\sql.py", line 1247, in define_table
> > t._create(migrate=migrate, fake_migrate=fake_migrate)
> > File "D:\Home\web\web2py\gluon\sql.py", line 1703, in _create
> > fake_migrate=fake_migrate)
> > File "D:\Home\web\web2py\gluon\sql.py", line 1757, in _migrate
> > self._db._execute(sub_query)
> > File "D:\Home\web\web2py\gluon\sql.py", line 950, in <lambda>
> > self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> > ProgrammingError: column "date" does not exist
> > LINE 1: UPDATE position SET date__tmp=date;
> > ^
>
> > I expected those changes to be migrated automatically. What is wrong?
> > How to fix?
>
> > Regards, Andreas
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
