Postgres Pro
Downloads
Home   >   mailing lists

Order of generated keys during inserts - Mailing list pgsql-jdbc

From Andrei Tsibets
Subject Order of generated keys during inserts
Date
Msg-id D923B02B-8CE1-407A-9629-7802B644FDAA@geomotiv.com
Whole thread Raw
Responses Re: Order of generated keys during inserts  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view
Hello,

I’m doing multiple inserts into PostgreSQL using executeBatch, and then retrieving generated primary keys via getGeneratedKeys().
The question is: is it save to match inserts with retuned keys by order? Is it guaranteed that generated keys are ordered according
to the order in which commands were added to the batch?

PostgreSQL 11
JDBC driver 42.2.5

Thank you,
Andrei

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Configure Apache Tomcat’s JNDI to return a `DataSource` of class `PGSimpleDataSource`
Next
From: Dave Cramer
Date:
Subject: Re: Order of generated keys during inserts