Did you get any operational error at all?
On Jan 6, 3:00 am, Michael Toomim <too...@gmail.com> wrote:
> I'm using hg tip and can't add a column to a table. It figures out
> what to do, but doesn't alter the postgresql database. Then any
> commands that need to use that column fail.
>
> It was able to create the table in the first place, but cannot add a
> column now that the table has been created. How should I debug this?
>
> Here's more detail:
>
> == Step 1 ==
>
> db.py:
>
> db.define_table('hits_log',
> db.Field('hitid', 'text'),
> db.Field('creation_time', 'datetime'))
>
> .table file:
>
> {'creation_time': 'TIMESTAMP', 'hitid': 'TEXT', 'id': 'SERIAL
> PRIMARY KEY'}
>
> postgresql schema:
>
> id | integer | not null default
> nextval('hits_log_id_seq'::regclass)
> hitid | text |
> creation_time | timestamp without time zone |
> Indexes:
> "hits_log_pkey" PRIMARY KEY, btree (id)
>
> == Step 2 ==
> Now I add a column "xmlbody":
>
> db.define_table('hits_log',
> db.Field('hitid', 'text'),
> db.Field('creation_time', 'datetime'),
> db.Field('xmlbody', 'text'))
>
> I re-run web2py with:
> python web2py.py -a 'foo' -i lovebox.local
>
> I load a controller function. But it hasn't updated my postgresql
> schema:
>
> id | integer | not null default
> nextval('hits_log_id_seq'::regclass)
> hitid | text |
> creation_time | timestamp without time zone |
> Indexes:
> "hits_log_pkey" PRIMARY KEY, btree (id)
>
> even though the .table file is updated:
>
> {'creation_time': 'TIMESTAMP',
> 'hitid': 'TEXT',
> 'id': 'SERIAL PRIMARY KEY',
> 'xmlbody': 'TEXT'}
>
> and sql.log now has:
> ALTER TABLE hits_log ADD xmlbody TEXT;
--
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.
