On 12 June 2012 18:33, Richard Vézina <[email protected]> wrote:

> Not sure if it will answer your question, but to me if I need to do that I
> will do db.executesql for the SELECT INTO and reflect this change into a a
> dynamic table definition...
>
> db.define_table(..., migrate=True)
>
> The drawback is that the db.define_table will stay dynamic even if the
> table into postgres is permanent.
>
>
>
The problem is that such a table will not have a sequence-based id-field
because it is the result of a query.  As I understand it, web2py requires
such a field to be able to use DAL.

Regards
Johann
-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

Reply via email to