Re: Catching query cancelations in PLPython3u

2025-01-17 Thread Adam Brusselback
Bumping this, because I am genuinely interested if there is a better way to do this. I'd really like to know if there is a better way than executing dummy queries...it feels dirty. I've seen plenty of extensions not handle query cancellation / exceptions gracefully. Also seems like something to t

Catching query cancelations in PLPython3u

2024-11-15 Thread Mat Arye
Hi All, We've been using plpython3u in our pgai project recently and recently got a PR[1] that uses some async code to communicate with openAI. That code uses async to be able to respond in a timely manner to queries being cancelled. Right now it uses a timed loop to test for query cancellations u