Grouper Users - Open Discussion List

[Francesco Malvezzi <>]

Il 28/05/2014 15:54, Chris Hyzer ha scritto:
> You want to get rid of entries in grouper_members which arent used anywhere 
> else (there are a ton of foreign keys to this table)?  I don't think we 
> have a utility to do that.  I guess you could backup your data, and write a 
> script that tries to delete each record in that table in its own 
> transaction and if a record fails due to foreign key, then ignore.  Or you 
> could look at all the foreign keys and write a delete script where the 
> record is not used in any foreign key (backup your data for this too 
> obviously).
> 
> Im not sure I recommend doing either of these though, up to you :)

I tried something like:

delete from grouper_members where subject_source='my-ldap-source' and id
not in (select distinct member_id from grouper_memberships);

but right now I realized the slowness of xmlexport was due to the log
entries (point in time?) so I think I didn't solve anything,

thank you,

Francesco