Update / change Request ID sequence
I ran query:
update workorder set WORKORDERID = 1650 where WORKORDERID = (select max(WORKORDERID) from workorder);
But getting this as a return:
update workorder set WORKORDERID = 1650 where WORKORDERID = (select max(WORKORDERID) from workorder);
But getting this as a return:
ERROR: update or delete on table "workorder" violates foreign key constraint "requestresolver_fk1" on table "requestresolver"
DETAIL: Key (workorderid)=(5) is still referenced from table "requestresolver".
Was I supposed to add something in (select max(WORKORDERID) from workorder);
Was I supposed to add something in (select max(WORKORDERID) from workorder);