In your post the error say:
ProgrammingError: column "update" specified more than once
is the column "update" or "updated". The former is a reserved keyword
and postgresql may not like it.
Massimo
On Jan 1, 2:26 am, Richard Baron Penman <richar...@gmail.com> wrote:
> v1.99.2
>
> I found I get no error when I change the database from postgres to sqlite.
>
> Richard
>
> On Sun, Jan 1, 2012 at 2:43 AM, Massimo Di Pierro
>
>
>
>
>
>
>
> <massimo.dipie...@gmail.com> wrote:
> > Your code works for me. What version of web2py? Try it is a newly
> > createted application.
>
> > On Dec 31, 6:37 am, Plumo <richar...@gmail.com> wrote:
> >> I found when I use the compute field I get this error when inserting via
> >> appadmin:
>
> >> ProgrammingError: column "update" specified more than once
>
> >> def now(record):
> >> return datetime.datetime.now()
>
> >> db.define_table('upload',
> >> Field('data', 'upload', required=True),
> >> Field('created', 'datetime', default=request.now),
> >> Field('updated', 'datetime', compute=now)
> >> )
>
> >> Any ideas?
>
> >> Richard
