Hi guys,
I've been trying to use legacy postgres databases that uses a custom
sequence name.
I'm able to read and write a table, by specifying the sequence_name
parameter when declaring the Table object

lets say:

table_name = 'table'
db.define_table(table_name,
            Field('%s_id'%table_name,'id'),
            Field('filed1','string'),
            Field('field2','string'),
            migrate=True,
            sequence_name = '%s_pk_seq'%tablename)

It the table is created before using web2py everything goes smooth,
and I can add values and fields to the table.
However I the Table do not exist, web2py creates it without setting
the given sequence name.
Is this the supposed behavior?  or am I mistaken?

If this is currently not supported, maybe I can try to implement it.
In that case which file should I work on? sql.py or dal.py?
Is still not clear to me which one is the currently developed one...

Reply via email to