Re: [sqlalchemy] Support for Oracle 12c auto increment (IDENTITY) columns?

2016-04-13 Thread Mike Bayer
: *From: *"Piotr Dobrogost" <p...@2016.groups.google.dobrogost.net> *To: *"sqlalchemy" <sqlalchemy@googlegroups.com> *Sent: *Wednesday, April 13, 2016 1:50:19 PM *Subject: *Re: [sqlalchemy] Suppo

Re: [sqlalchemy] Support for Oracle 12c auto increment (IDENTITY) columns?

2016-04-13 Thread Mike Bayer
On 04/13/2016 07:50 AM, Piotr Dobrogost wrote: Mike, Thanks for your reply! On Wednesday, April 13, 2016 at 1:15:32 PM UTC+2, Mike Bayer wrote: We've not started supporting new oracle 12c features as of yet, in this case it might be possible to get it working with some dialect

Re: [sqlalchemy] Support for Oracle 12c auto increment (IDENTITY) columns?

2016-04-13 Thread David Moore
- Original Message - From: "Piotr Dobrogost" <p...@2016.groups.google.dobrogost.net> To: "sqlalchemy" <sqlalchemy@googlegroups.com> Sent: Wednesday, April 13, 2016 1:50:19 PM Subject: Re: [sqlalchemy] Support for Oracle 12c auto increment (IDENTIT

Re: [sqlalchemy] Support for Oracle 12c auto increment (IDENTITY) columns?

2016-04-13 Thread Piotr Dobrogost
Mike, Thanks for your reply! On Wednesday, April 13, 2016 at 1:15:32 PM UTC+2, Mike Bayer wrote: > > We've not started supporting new oracle 12c features as of yet, in this > case it might be possible to get it working with some dialect flags since > we already use "returning" to get at the

Re: [sqlalchemy] Support for Oracle 12c auto increment (IDENTITY) columns?

2016-04-13 Thread Michal Petrucha
On Wed, Apr 13, 2016 at 07:15:27AM -0400, Mike Bayer wrote: > We've not started supporting new oracle 12c features as of yet, in this > case it might be possible to get it working with some dialect flags since > we already use "returning" to get at the newly generated primary key, > although

Re: [sqlalchemy] Support for Oracle 12c auto increment (IDENTITY) columns?

2016-04-13 Thread Mike Bayer
We've not started supporting new oracle 12c features as of yet, in this case it might be possible to get it working with some dialect flags since we already use "returning" to get at the newly generated primary key, although testing would be needed and other assumptions in the dialect might get in

[sqlalchemy] Support for Oracle 12c auto increment (IDENTITY) columns?

2016-04-13 Thread Piotr Dobrogost
Hi all! At http://docs.sqlalchemy.org/en/latest/dialects/oracle.html#auto-increment-behavior we read that: "With the Oracle dialect, a sequence must always be explicitly specified to enable autoincrement." However, starting with version 12c Oracle supports autoincrement columns (see update