Re: [sqlalchemy] Re: Bulk insert creating duplicate primary-keys

2019-06-12 Thread Mike Bayer
what's the default on the column? seems like that's the problem here. if this is an in-SQLAlchemy default, that won't work, you need to generate the uuids on the database side if you are using a SELECT. The functions are available through an extension on PG, there's background here:

[sqlalchemy] Re: Bulk insert creating duplicate primary-keys

2019-06-12 Thread Colton Allen
Also, I should mention the ID is not explicitly mentioned in the select query. I am relying on the column's "default" argument to supply the UUID. Also also, I made a typo. It should read "when the select only finds one row". On Wednesday, June 12, 2019 at 12:36:50 PM UTC-7, Colton Allen