gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] psql complains when trying to insert into ref.billables
Date: Sat, 7 Jul 2012 00:38:41 +0200
User-agent: Mutt/1.5.21 (2010-09-15)

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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]