Forum OpenACS Q&A: Re: Combining user accounts

Collapse
3: Re: Combining user accounts (response to 1)
Posted by Richard Hamilton on 02/10/03 04:59 PM

Thanks for the reply Don.

I think I might have a go at tackling the delete user completely bit first!. Maybe if I study the data model around users and find all tables where user_id appears I might be able to safely remove them

Once I have done that maybe it will be possible to simply allocate one user_id as the desired master user_id and re-write references to the other ids on all other tables

Any pointers much appreciated


Regards
Richard
Collapse
4: Re: Combining user accounts (response to 3)
Posted by Jeff Davis on 02/10/03 05:36 PM
I have something that pulls out all the foreign key references (without indexes, but just change the code to get them all) for postgresql at http://xarg.net/download/fk.tcl.txt and there is corresponding query for oracle at
http://osi.oracle.com/~tkyte/unindex/index.html
that will do it for oracle.  It would be great if we
could get some of this stuff cleaned up.