Re: Trying to change data in a staging table.

Tim Lawton wrote:
>
> I have a problem where I am populating a staging table via triggers. During
> one transaction I updata a column for an email record, say email1.
HOLD it right there!
<snip>
  Within the same trigger,
> immediately after the insert of the user, I try and update the email1
> record,

Dreaded mutating table error? You update mail.email1, a trigger fires, does lots
of stuff, and updates mail again? No go.

-- 
Gtrz,

Frank van Bortel