I removed the not null contraint on members.admin and "update items set active
= false where
member_id=38" results in the count columns in members getting updated AND
members.admin getting
set to NULL. Really bizarre.
I dropped the trigger function and the trigger, then recreated both, and now
I have a members table and an items table. Every time items.member_id or
items.active gets
changed, members.items_submitted and members.items_approved gets updated by a
trigger on items. I
added an "admin" column to members, and now this happens:
=> update items set active = false where member_i
