Doh! Turns out Cayenne already supports this for Postgres. Who knew! :-P 2621 [main] INFO org.apache.cayenne.log.JdbcEventLogger - INSERT INTO test (payload) VALUES (?)
2621 [main] INFO org.apache.cayenne.log.JdbcEventLogger - [bind: 1->payload:'test'] 2632 [main] INFO org.apache.cayenne.log.JdbcEventLogger - Generated PK: test.id = 1 On Tue, May 28, 2019 at 12:30 PM Andrus Adamchik <and...@objectstyle.org> wrote: > 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 <johnth...@gmail.com> 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 <and...@objectstyle.org> > > 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 > >
