The first version of the new DAL is just a more modular version of the
current DAL. It will be easy to add this feature when done.
On Feb 1, 5:42 pm, Richard <richar...@gmail.com> wrote:
> 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.
