When an update is done to the package table, it appears that it
has actually done an insert of the new record but not deleted the
old record. So I end up with an extra record. If I define the tables
without the trigger, the updates execute correctly.
Danny Aldham
>
> Danny Aldham <danny(at)lennon(dot)postino(dot)com> writes:
> > I have migrated from 7.0.2 to 7.1.3 and the triggers are failing.
>
> Please define "fail". You didn't actually say what's going wrong.
>
> regards, tom lane
>