[NCUC E-team] Database Error

[Maryam Bakoshi]

Dear All,

Please I need your help.

I tried to delete a row from the NCUC database, but it was throwing up the errors below.

I would really appreciate your help/advise on this.


SQL error:

ERROR:  update or delete on table "ncucers" violates foreign key constraint "ncucer_verified_ncucerid_fkey" on table "ncucer_verified"
DETAIL:  Key (id)=(2) is still referenced from table "ncucer_verified".

In statement:
DELETE FROM "public"."ncucers" WHERE "id"='2'


Many thanks,
--
Maryam Bakoshi
Secretariat ­Support - NCSG, NCUC, NPOC
Internet Corporation for Assigned Names and Numbers (ICANN)

Email:  maryam.bakoshi at icann.org<mailto:maryam.bakoshi at icann.org>
Mobile:  +44 7737 698036
Skype:  maryam.bakoshi.icann
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ncuc.org/pipermail/e-team/attachments/20150605/eb0c0885/attachment.html>