QueryFailedError: relation “*” already exists

I was getting this error when debugging a resent NestJS application. All of my Google searched turned up nothing. After a bit of poking around in pgAdmin I found that there was a duplicate record under the sequences directory.

I was getting the following error:

QueryFailedError: relation 'car_id_seq' already exists. 

I found two records, one for ‘car_id_seq’ and one for ‘car_id_seq1’. The only thing that I can imagine is that somewhere along the way that duplicate record (car_id_seq1) was entered and even though I dropped the car table, when NextJS restarted their was a conflict.

So, if you get a similar error, check your sequences list to remove any duplicates. Hopefully this saves someone some time 😀