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

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Re: How to ensure a log-entry is created based on state of data in other tables
Дата
Msg-id VisenaEmail.6b.d76438498ddf3620.186371b8050@visena.app.internal.visena.net
обсуждение исходный текст
Ответ на Re: How to ensure a log-entry is created based on state of data in other tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-sql
Дерево обсуждения
På torsdag 09. februar 2023 kl. 17:44:25, skrev David G. Johnston <david.g.johnston@gmail.com>:
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.
 

Ah, this is what I'm looking for, I think.

 

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Вложения

В списке pgsql-sql по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: How to ensure a log-entry is created based on state of data in other tables
Следующее
От: michele curioni
Дата:
Сообщение: Could not serialize access due to read/write dependencies among transactions