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 <gabriele.albe...@gmail.com>
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 <mdipie...@cs.depaul.edu> 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 <gabriele.albe...@gmail.com>
> > 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 web2py@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
-~----------~----~----~----~------~----~------~--~---

Reply via email to