> If you need to disconnect and reconnect to see changes when using zhparser, that sounds like a bug in zhparser that they should fix.
Okay, anyway, i thought we identify the source of this issue finally. I even reproduce this from web, every time before i want to refresh stored generated column, i close puma, and restart it. this will create a new pg connection, refresh always work if follow this process. Thank you very much for you help. 在2021年11月23日星期二 UTC+8 上午3:46:41<Jeremy Evans> 写道: > On Mon, Nov 22, 2021 at 11:42 AM Billy Zheng <vil...@gmail.com> wrote: > >> >> Hi, Jeremy, i upload a .png attachment, please have a look, that is a >> screenshot on zhparser github repo. >> https://github.com/amutu/zhparser#%E8%87%AA%E5%AE%9A%E4%B9%89%E8%AF%8D%E5%BA%93-21 >> >> that may explain why Sequel not work with zhparser, i consider maybe this >> is not a issue of Sequel, because perhaps rarely happen, but, if consider >> add a option to run to allow >> not use connection pool, that is, is it possible run one SQL statement >> use a new connection ? >> > > There's not a public API for that. You can use the connection pool's > make_new, but make sure you close the connection after use so it doesn't > leak. > > If you need to disconnect and reconnect to see changes when using > zhparser, that sounds like a bug in zhparser that they should fix. > > Thanks, > Jeremy > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to sequel-talk+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/5ee31163-e77e-4e0e-b22d-33ef2716918fn%40googlegroups.com.