On Fri, Sep 20, 2013 at 6:43 PM, James Sharrett <jsharr...@tidemark.net> wrote:
> ERROR: record "old" is not assigned yet > SQL state: 55000 > Detail: The tuple structure of a not-yet-assigned record is indeterminate. > > Is this what's happening? If so, how can I avoid the issue. If I get it right you are running the trigger also for an insert, which of course does not have an old value. You should either set the trigger to run only on update statements or enforce your check to see if the trigger has been invoked for something different than insert statements. Luca -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql