I keep getting this error within my application
duplicate key value violates unique constraint "product_suppli erinfo_pkey" DETAIL: Key (id)=(409) already exists.
The actual next sequence number the key constraint needs to be is 5461 not 409.
It is a postgreSQL table called product_supplie rinfo and it has a constraint called product_supplie rinfo_pkey this number is updated everytime a record is added. HOwever I did a direct import into the database and it threw the constraint counter off. It thinks the next id number is 409 and it is supposed to be 5461
duplicate key value violates unique constraint "product_suppli erinfo_pkey" DETAIL: Key (id)=(409) already exists.
The actual next sequence number the key constraint needs to be is 5461 not 409.
It is a postgreSQL table called product_supplie rinfo and it has a constraint called product_supplie rinfo_pkey this number is updated everytime a record is added. HOwever I did a direct import into the database and it threw the constraint counter off. It thinks the next id number is 409 and it is supposed to be 5461