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

[Karsten Hilbert]

On Fri, Jul 06, 2012 at 05:55:47PM +0000, Jim Busser wrote:

> > The more interesting thing is why the corresponding audit
> > table does not exist (IOW hasn't been created during
> > upgrading). I'll check that tonight.
> 
> ... this table needs to exist even for the *addition* of
> records to ref.billable unless ... wait ... perhaps triggers
> operate in such a way that even when an active trigger is
> irrelevant to a transaction, it must nevertheless be
> evaluated in order to decide that it is irrelevant, and for
> that to happen the trigger must be 'evaluable'

On INSERT/UPDATE the row version is incremented and
modfied_when/modified_by are set on the table. Since the
table did not inherit from audit.audit_fields it did not
have those columns which made the trigger fail.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346