How to update primary key of an existing object in Django (with PostgreSQL)?

Question

I need to change some objects primary keys in my django app, I wonder how can I achieve that?

Also my model has relations with other models.

AKX · Accepted Answer · 2020-05-11 12:51:33Z

2

Technically, it should be possible with an update query on the queryset:

MyModel.objects.filter(id=old_id).update(id=new_id)

The relations should cascade too if the constraints in the database have been set up correctly, but in general, I'd avoid updating PKs.

answered May 11, 2020 at 12:51

AKX

171k17 gold badges148 silver badges230 bronze badges

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

3 Comments

Vahid Al Over a year ago

Hey man, when I use you method, I got the following error: IntegrityError: update or delete on table "restaurants_restaurant" violates foreign key constraint "restaurants_item_restaurant_id_32e74c18_fk_restauran" on table "restaurants_item" DETAIL: Key (id)=(101494) is still referenced from table "restaurants_item".

J Spratt Over a year ago

@VahidAl That's because your update is not cascading to foreign keys. You'd need to update either the tables depending on the key you're updating first or apply cascading constraints on the keys so that when you update the primary key it updates all of the dependent tables also.

Vahid Al Over a year ago

Hey J Spratt, Thanks, I'm kindda new to django, can you explain a little more or do you new an implementation of it in codes?

Collectives™ on Stack Overflow

How to update primary key of an existing object in Django (with PostgreSQL)?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related