Thanks Michael!
I'm getting this error "FlushError: Instance has NULL identity".
But the strange thing it is not happening every time my insert runs.
It looks like the sequence is generating the value after the commit, so ID
is null.
On Tuesday, February 19, 2013 12:42:04 AM UTC-3, Mauricio de Abreu Antunes
wrote:
>
> How to use Sequence with SQLAlchemy?
>
> Oracle does not support autoincrement, so I tried to use Sequence
> (sqlalchemy.schema) like:
>
> id = Column(Integer, Sequence("seq_customer_id"), primary_key=True)
>
> but it is not working.
>
> If you need more info to help me tell me then i back here to post it.
>
> Thanks in advance.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
