Hello, your hack seems to be partially working, for those who need it I had to shorten even more your suggestion, so:
auth.settings.table_membership_name = 'auth_memb' auth.settings.table_permission_name = 'auth_perm' So far this worked. I'll let you know if anything else gives problems as I will be working heavily with Oracle in the next days. Grazie mille! G. On Nov 13, 6:11 pm, mdipierro <[email protected]> wrote: > For now I would just do in db.py > > auth=Auth() > auth.settings.table_membership_name = 'auth_membr' > auth.settings.table_permission_name = 'auth_perms' > > before > > auth.define_tables() > > Don't we all love Oracle quirks? > > Massimo > > On Nov 13, 9:59 am, Gabriele Alberti <[email protected]> > wrote: > > > Hi, > > it is 30 chars. I did not read the DAL code yet, but a simple > > temporary workaround would be to shorten the suffix string.. maybe a > > more definitive thing would be a simple checksum (shorter than 30 > > chars) against the long names ? > > > I'll be glad to give you any support to help. > > > Thanks, > > > G. > > > On Nov 13, 3:59 pm, mdipierro <[email protected]> wrote: > > > > There will not be a new DAL anytime soo because we have cleaned up the > > > current DAL a lot functionality already so the new DAL is already > > > obsolete in comparison. Let's try adress this specific problem for > > > now. > > > > What is the max length for a constraint name in oracle? > > > > On Nov 13, 5:29 am, Gabriele Alberti <[email protected]> > > > wrote: > > > > > Hello web2py users, > > > > recently using Oracle as DB I hit the notorious problem "ORA-00972: > > > > identifier is too long". I understood the problem, I modified my code > > > > to comply the Oracle limit, then I hit the same problem in "CONSTRAINT > > > > auth_membership_user_id__constraint", which is not my code :) > > > > I have noticed an old post stating soon a new DAL will be ready and it > > > > will address this issue. > > > > Any news about that? > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
