Have a situation where a table with column defined as:
INTEGER GENERATED BY DEFAULT AS IDENTITY. A duplicate condition was raised in test. this happened after the production database was copied to test. Again, the dupe condition happened while inserting rows in the test/qa environment. the application program is not altering the identity column!!.

Any comments on this.

Thanks!