On Wed, Oct 7, 2026 at 12:09 AM Ron Johnson <[email protected]> wrote:
> On Tue, Oct 6, 2026 at 6:39 AM Stuart Campbell < > [email protected]> wrote: > [snip] > >> Would using temporary tables be a feasible solution? That seems to be >> functionally what I want, but maybe it's hard to write triggers that write >> to temp tables. >> >> Maybe a persistent log table is OK, and each transaction is >> responsible for deleting its own rows from it? Sounds like a lot of churn >> though... >> > > A recent email in > https://postgrespro.com/list/thread-id/2812560#[email protected] > mentioned this extension to create "persistent" temporary tables (where > each connection doesn't need to CREATE them every time. > > https://github.com/darold/pgtt > > Maybe that would be useful. I've never used them, though, so don't know > any gotchas. > Thanks for the suggestion. That seems semantically close to what I'm looking for. In my case we're working with Amazon RDS, so I don't think ad hoc extensions are permitted. -- This communication and any attachments may contain confidential information and are intended to be viewed only by the intended recipients. If you have received this message in error, please notify the sender immediately by replying to the original message and then delete all copies of the email from your systems.
