[NCUC E-team] E-team Digest, Vol 29, Issue 1

[Maryam Bakoshi]

Dear Tapani,

Thank you so much for your prompt reply. It makes sense now. 

Many thanks,

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

E: Maryam.bakoshi at icann.org
S: Maryam.bakoshi.icann
T: +44 7737698036


> On 5 Jun 2015, at 11:04, "e-team-request at lists.ncuc.org" <e-team-request at lists.ncuc.org> wrote:
> 
> Send E-team mailing list submissions to
>    e-team at lists.ncuc.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>    http://lists.ncuc.org/cgi-bin/mailman/listinfo/e-team
> or, via email, send a message with subject or body 'help' to
>    e-team-request at lists.ncuc.org
> 
> You can reach the person managing the list at
>    e-team-owner at lists.ncuc.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of E-team digest..."
> 
> 
> Today's Topics:
> 
>   1. Database Error (Maryam Bakoshi)
>   2. Re: Database Error (Tapani Tarvainen)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Fri, 5 Jun 2015 09:36:40 +0000
> From: Maryam Bakoshi <maryam.bakoshi at icann.org>
> To: "e-team at lists.ncuc.org" <e-team at lists.ncuc.org>
> Subject: [NCUC E-team] Database Error
> Message-ID: <D1972B98.B82D%maryam.bakoshi at icann.org>
> Content-Type: text/plain; charset="euc-kr"
> 
> 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-0001.html>
> 
> ------------------------------
> 
> Message: 2
> Date: Fri, 5 Jun 2015 12:47:52 +0300
> From: Tapani Tarvainen <ncuc at tapani.tarvainen.info>
> To: e-team at lists.ncuc.org
> Subject: Re: [NCUC E-team] Database Error
> Message-ID: <20150605094751.GA586 at roller.tarvainen.info>
> Content-Type: text/plain; charset=us-ascii
> 
>> On Jun 05 09:36, Maryam Bakoshi (maryam.bakoshi at icann.org) wrote:
>> 
>> I tried to delete a row from the NCUC database, but it was throwing
>> up the errors below.
> 
> In general you should not just delete rows from "ncucers" table.
> If you want to remove a member, change the "state" field
> value to 3 ("removed").
> 
> That will make them invisible in the web, member lists,
> voter lista, member counts &c - in effect, remove them
> from the set of members, which I presume you intended to do.
> 
> Actually removing the data requires taking care of various data
> dependencies, as you discovered, and it should happen automatically
> later (delay there is intentional, to provide easy "undo" in case
> someone is accidentally removed).
> 
> -- 
> Tapani Tarvainen
> 
> 
> ------------------------------
> 
> _______________________________________________
> E-team mailing list
> E-team at lists.ncuc.org
> http://lists.ncuc.org/cgi-bin/mailman/listinfo/e-team
> 
> 
> End of E-team Digest, Vol 29, Issue 1
> *************************************