Sorry maybe i misled you the problem is with a foriegn key.
somelongtablename_longcoloumnname_FK > 30

how i tried using ForeignKeyConstraint
but with no luck =(.
On Sun, Sep 6, 2009 at 12:33 PM, Marko Springfeldt <[email protected]>wrote:

>
> Hi Yoav,
>
> as an example:
>
> using_table_options(UniqueConstraint('column_a', 'column_b', name='a_b'))
>
> The *name* argument changes the name of the constraint.
>
>
> http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/schema.html?#sqlalchemy.schema.UniqueConstraint
>
> Marko
>
> yoav glazner schrieb:
>  > Hi,
> >
> > I get this error "ORA-00972: identifier is too long " when creating my
> > tables on an oracle database.
> > It appears that the 30 chars limit is exceeded because elixir gives
> > the table name prefix to constaint name.
> >
> > is there any way to disable this?
> > is there a way to iterate over the names that elixir generate and
> > change them manually ?
> >
> > Thanks a lot,
> >
> > Yoav.
> >
> > P.S: already seen
> > http://osdir.com/ml/python.sqlelixir/2008-04/msg00062.html and it
> > wasn't helpful
> >
> > >
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"SQLElixir" 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/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to