Fang,
This is not the right direction, altering the eperson2group relationship
will not impact this foreign key constraint.
The Eperson is set as the owner in the Item record they submitted. This is
the constraint and its in the item table. Its generally better to just
disable the login of the eperson. For database integrity and expected
behavior of DSpace I don't recommend removing the user.
Mark
On Fri, Apr 20, 2012 at 8:16 AM, Blanco, Jose <[email protected]> wrote:
> That table is part of the dspace installation, you would need to find
> the server where the postgres db is install and connect to it to query it
> and issue sql commands to it. The person that got your instance going
> should be able to do that.****
>
> ** **
>
> -Jose****
>
> ** **
>
> *From:* Wang, Fang [mailto:[email protected]]
> *Sent:* Friday, April 20, 2012 11:15 AM
>
> *To:* Blanco, Jose; [email protected]
> *Subject:* RE: [Dspace-general] Delete E-persons who have submitted items
> to DSpace****
>
> ** **
>
> Where is that epersongroup2eperson table located? I can only access and
> manage the front end of DSpace. ****
>
> ** **
>
> *Fang Wang*****
>
> Digital Information Management Librarian****
>
> Texas Tech University School of Law Library****
>
> 1802 Hartford Ave, Lubbock, TX 79409****
>
> 806-742-3990 ext. 290****
>
> [email protected]****
>
> ****
>
> *"Real knowledge is to know the extent of one's ignorance." -Confucius*
>
> * *
>
> [image: Description: Description: cid:[email protected]]****
>
> ** **
>
> *From:* Blanco, Jose [mailto:[email protected]]
> *Sent:* Friday, April 20, 2012 10:10 AM
> *To:* Wang, Fang; [email protected]
> *Subject:* RE: [Dspace-general] Delete E-persons who have submitted items
> to DSpace****
>
> ** **
>
> So that person’s eperson_id does not exists in epersongroup2eperson table?
> ****
>
> ** **
>
> *From:* Wang, Fang [mailto:[email protected]]
> *Sent:* Friday, April 20, 2012 11:06 AM
> *To:* Blanco, Jose; [email protected]
> *Subject:* RE: [Dspace-general] Delete E-persons who have submitted items
> to DSpace****
>
> ** **
>
> Hi Jose,****
>
> ** **
>
> Thanks for your reply! I did make sure to remove the submitters from the
> groups they belonged to. Now they only belong to anonymous but I still
> cannot delete them…****
>
> ** **
>
> *Fang Wang*****
>
> Digital Information Management Librarian****
>
> Texas Tech University School of Law Library****
>
> 1802 Hartford Ave, Lubbock, TX 79409****
>
> 806-742-3990 ext. 290****
>
> [email protected]****
>
> ****
>
> *"Real knowledge is to know the extent of one's ignorance." -Confucius*
>
> * *
>
> [image: Description: Description: cid:[email protected]]****
>
> ** **
>
> *From:* Blanco, Jose [mailto:[email protected]]
> *Sent:* Friday, April 20, 2012 10:01 AM
> *To:* Wang, Fang; [email protected]
> *Subject:* RE: [Dspace-general] Delete E-persons who have submitted items
> to DSpace****
>
> ** **
>
> I’m not sure this is the right answer to your question, but I suspect you
> still have that person assigned as a submitter to some collection, so get
> rid of them from that group, and then try to delete that eperson.****
>
> ** **
>
> -Jose****
>
> ** **
>
> *From:* Wang, Fang [mailto:[email protected]]
> *Sent:* Friday, April 20, 2012 10:56 AM
> *To:* [email protected]
> *Subject:* [Dspace-general] Delete E-persons who have submitted items to
> DSpace****
>
> ** **
>
> Hi All,****
>
> ** **
>
> I am sorry if this question has been asked a million times. Is there a way
> to delete E-persons who have submitted items to DSpace? It doesn’t seem
> like I have that option under the E-person Management tool when logged in
> as admin. I could delete any regular users but not the ones who were
> submitters before. I did search the archives of the DSpace mailinglist.
> Someone asked this question back in 2004 but there was no answer to his
> question. ****
>
> ** **
>
> I’d appreciate it if you could offer any help. Thank you so much! ****
>
> ** **
>
> *Fang Wang*****
>
> Digital Information Management Librarian****
>
> Texas Tech University School of Law Library****
>
> 1802 Hartford Ave, Lubbock, TX 79409****
>
> 806-742-3990 ext. 290****
>
> [email protected]****
>
> ****
>
> *"Real knowledge is to know the extent of one's ignorance." -Confucius*
>
> * *
>
> [image: Description: Description: cid:[email protected]]****
>
> ** **
>
>
> ------------------------------------------------------------------------------
> For Developers, A Lot Can Happen In A Second.
> Boundary is the first to Know...and Tell You.
> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
> http://p.sf.net/sfu/Boundary-d2dvs2
> _______________________________________________
> Dspace-general mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-general
>
>
--
[image: @mire Inc.]
*Mark Diggory *(Schedule a Meeting <https://tungle.me/markdiggory>)
*2888 Loker Avenue East, Suite 305, Carlsbad, CA. 92010*
*Esperantolaan 4, Heverlee 3001, Belgium*
http://www.atmire.com
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Dspace-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-general
