Create list of uuids in postgres?

Question

Its possible to generate uuids with postgres (https://www.postgresqltutorial.com/postgresql-uuid/) Now I need to update my table where uuids are missing. I am not able to figure out how to achieve it. The column individual_uuid has a unique constraint. Any ideas? ??? should be replaced with the syntax I need.

update foo_table set individual_uuid = ???? where individual_uuid is null

not working:

update foo_table set individual_uuid = (SELECT uuid_generate_v1()) where individual_uuid is null

Laurenz Albe · Accepted Answer · 2020-06-24 06:43:08Z

2

Usage of SELECT uuid_generate_v1() leads to the unexpected result that the same value gets used for every row, because the subselect is not correlated with values from the main query.

Use uuid_generate_v1() instead:

UPDATE foo_table 
SET    individual_uuid = uuid_generate_v1() 
WHERE  individual_uuid IS NULL;

edited Jun 24, 2020 at 6:43

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

answered Jun 24, 2020 at 6:11

Vivek S.

22.3k9 gold badges71 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create list of uuids in postgres?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related