Re: [Gnumed-devel] psql complains when trying to insert into ref.billables

[Busser, Jim]

On 2012-07-06, at 2:16 AM, Karsten Hilbert wrote:

> That is the same bug as with the failing DELETE. I'm
> checking up on this one but haven't pinned it down just yet.

Does a complaint such as

        ERROR:  record "new" has no field "row_version"
        CONTEXT:  PL/pgSQL function "ft_ins_billable" line 2 at assignment

relate to the trigger given by

        \d+ ref.billable

        Triggers:
        zt_ins_billable BEFORE INSERT ON ref.billable FOR EACH ROW EXECUTE 
PROCEDURE audit.ft_ins_billable()

which, looking up in

        
http://publicdb.gnumed.de/~ncq/gnumed/schema/gnumed_v17/gnumed-schema.html#ref.schema

gives

BEGIN
        NEW.row_version := 0;
        NEW.modified_when := CURRENT_TIMESTAMP;
        NEW.modified_by := SESSION_USER;
        return NEW;
END;

which puzzlement on my part -- as to what this does -- desires better 
understanding. Is this somehow meaning that the insertion of records into the 
reference table is intended to invoke some kind of auditing?

-- Jim