[Mailmanager-users] Cannot delete users, MM 2.0.5 -w- PostgreSQL 8.0.6

[Samuel J S. <sst...@dp...>]

I've recently migrated from MailManager 1.0 RC1 to 2.0.5 -w- PostgreSQL
8.0.6.  The performance increase is amazing, but I've hit a snag.  I cannot
delete users and reassign their tickets to another user.  Did some searching
on-line and it appears to be a PostgreSQL problem...  I'm hoping someone
here has had the same problem and resolved it.

The traceback of the error from event.log is as follows:

2006-01-10T11:29:48 ERROR Zope.SiteErrorLog http://jobe:8080/mm/delAgent
Traceback (most recent call last):
  File "/usr/local/zope/lib/python/ZPublisher/Publish.py", line 113, in
publish
    request, bind=1)
  File "/usr/local/zope/lib/python/ZPublisher/mapply.py", line 88, in mapply
    if debug is not None: return debug(object,args,context)
  File "/usr/local/zope/lib/python/ZPublisher/Publish.py", line 40, in
call_object
    result=apply(object,args) # Type s<cr> to step into published object.
  File "/usr/local/zope/mailManager/Products/MailManager/MailManager.py",
line 1448, in delAgent
    self.sql.deleteUser(username=username)
  File "/usr/local/zope/lib/python/Shared/DC/ZRDB/DA.py", line 454, in
__call__
    else: result=DB__.query(query, self.max_rows_)
  File "/usr/local/zope/mailManager/Products/ZPsycopgDA/db.py", line 246, in
query
    raise err
IntegrityError: ERROR:  update or delete on "mm_user" violates foreign key
constraint "mm_ticket_assigned_fkey" on "mm_ticket"
DETAIL:  Key (username)=(jsmith) is still referenced from table "mm_ticket".

DELETE FROM mm_user
WHERE username = 'jsmith'

Help??? Please??? Thanks!

Cheers,
Sam
 
Samuel J Stanaitis, Network Administrator
Decorative Product Source, Inc.