Thanks for confirming my suspicions, I'm working on a plan B to deal with
this as best I can.
--
Mike Nolan
On Mon, Apr 4, 2022 at 9:23 AM Laurenz Albe
wrote:
> On Mon, 2022-04-04 at 09:18 -0500, Michael Nolan wrote:
> > Is it not recommended to use a FDW table in a trigger function?
>
> Yes, I
On Mon, 2022-04-04 at 09:18 -0500, Michael Nolan wrote:
> Is it not recommended to use a FDW table in a trigger function?
Yes, I would say that is not recommended. While a lag of a few seconds,
like you describe, should not be the normal case (you should investigate that),
it is hard to exclude i
Background: About two years ago the membership system I developed for a
client was moved from our in-house postgresql app to civi-CRM, which uses
MySQL. (I'm semi-retired, the move to civi-CRM is part of a long term
technology change.)
We have a FDW that simulates the old membership table that c
