Postgres Pro
Downloads
Home   >   mailing lists

Re: How to ensure a log-entry is created based on state of data in other tables - Mailing list pgsql-sql

From David G. Johnston
Subject Re: How to ensure a log-entry is created based on state of data in other tables
Date
Msg-id CAKFQuwYuYs0nmWpgLUwfTP5pF7zZgxJP+BqFj8gToZ4=RH89SQ@mail.gmail.com
Whole thread Raw
In response to How to ensure a log-entry is created based on state of data in other tables  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Re: How to ensure a log-entry is created based on state of data in other tables  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-sql
Tree view
On Thu, Feb 9, 2023 at 12:24 AM Andreas Joseph Krogh <andreas@visena.com> wrote:

Is there a better way, using some extra tables to do bookkeeping can the have constraints ensuring this business-requirement?



Every time an activity newly becomes "Not Done" increment a "not done seen counter" and likewise with a "done seen counter".  Whenever the former is greater than the later you have one or more not done activities.

David J.

pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: How to ensure a log-entry is created based on state of data in other tables
Next
From: Rob Sargent
Date:
Subject: Re: How to ensure a log-entry is created based on state of data in other tables