Re: Auto-generated columns on Oracle

Thanks for the pointer. If PG passes generated PK back through the JDBC driver and we can read it after an INSERT, we most definitely should. Creating extraneous objects in DB for the sake of PK generation feels old.

Andrus

> On May 28, 2019, at 6:47 PM, John Huss <[email protected]> wrote:
> 
> Postgresql also recently improved their support in this area (in version
> 10). It's more like syntactic sugar on top of things you could already do,
> but I'd be interested to know if it can be used by Cayenne in the same way
> as the MySQL auto-increment columns.
> 
> The DDL syntax is supposedly an SQL standard:
> 
> CREATE TABLE test_new (
>    id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
>    payload text
> );
> 
> 
> On Mon, May 27, 2019 at 1:49 AM Andrus Adamchik <[email protected]>
> wrote:
> 
>> Looks like Oracle started supporting auto-increment columns since 12c:
>> 
>> 
>> https://www.arungudelli.com/tutorial/oracle/auto-increment-identity-column-in-oracle-table-primary-key/
>> 
>> We should try using that in the adapter.
>> 
>> Andrus