On Thu, Aug 20, 2026 at 09:29:36AM +0100, Zsolt Parragi wrote:
> Right, I thought you can't implement soft delete with triggers but of
> course you can. Except that RETURNING doesn't work at all in that
> case, unless I make it a delete+insert or also introduce a helper
> view, but even with the view I can only get out the old xmin, not the
> new.
For now I have applied your patch on HEAD as of d39762b8c79a,
qualifying as a life improvement thing with a better message. I have
never really seen somebody complain about that limitation, as well..
--
Michael