Peter Koczan wrote: > The main thing I'm worried about is the orphaned objects problem. It's not > adding users so much as removing them that I'm concerned about (I work at a > University and we remove inactive/non-enrolled users). These cases would > likely require a lot more in-depth intervention by myself and other staff.
Instead of deleting stuff from pg_authid directly, use DROP ROLE. If this doesn't work because the role owns something, you may use a combination of DROP OWNED and REASSIGN OWNED. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
