Table simmapping has foreign key to msisdn on 2 columns msisdn and providerId.
Change key so you can do update on providerId
Database: postgres.
ALTER TABLE public.simmapping
DROP CONSTRAINT fk_simmapping_msisdn,
ADD CONSTRAINT fk_simmapping_msisdn
FOREIGN KEY (msisdn, msisdn_providerid)
REFERENCES msisdn(msisdn, providerid)
ON UPDATE CASCADE;
No comments:
Post a Comment