Re: [Gnumed-bugs] [Gnumed-devel] Unhandled exception on Office > List bills

[Karsten Hilbert]

On Sat, Jul 21, 2012 at 10:41:59PM +0200, Karsten Hilbert wrote:

> >gnumed_v17=> select * from bill.bill ;
> >  pk_audit | row_version |         modified_when         | modified_by | pk 
> > |         invoice_id          |          close_date           | apply_vat | 
> > fk_receiver_identity | fk_receiver_address | fk_doc
> >----------+-------------+-------------------------------+-------------+----+-----------------------------+-------------------------------+-----------+----------------------+---------------------+--------
> >   1658952 |           0 | 2012-06-12 16:54:50.707435-07 | gm-dbo      |  1 
> > | address@hidden    |                               | t         |           
> >            |                     |
> >
> >and
> >
> >2) that I had deleted those items via psql as part of cleaning out such 
> >"demo" items and also cleaning out the reference table of billable items, 
> >and that I had deleted the items without deleting the bill to which they 
> >were attached.
> >
> >
> >For me to have been able to do so, does a referential integrity attribute or 
> >trigger warrant to be added to the table
> >
> >     bill.bill
> >
> >??
> Yes. Will add that. I remember considering adding this trigger but
> apparently did not actually do so.

Done.

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