<p>(Sorry for top posting and for any typos -- typing on my phone)<p>In my earlier patch to do progress indicators for
arbitrarySQL queries I had envisioned a setup similar to how we handle query cancellation. Psql could support a key
likeSIGINFO which would make it request an update. Clients like pgadmin would either do that periodically or set some
gucor protocol option to request periodic updates in advance.<p>greg<p><blockquote type="cite">On 17 Aug 2010 19:07,
"StephenFrost" <<a href="mailto:sfrost@snowman.net">sfrost@snowman.net</a>> wrote:<br type="attribution"
/><p><fontcolor="#500050">* Alex Hunsaker (<a href="mailto:badalex@gmail.com">badalex@gmail.com</a>) wrote:<br /> >
OnTue, Aug 17, 2010 at 06:31, Stephen Frost <sfrost@sn...</font>If it was configurable via \set and I could drop it
inmy .psqlrc, and<br /> it knew not to only do it after a few seconds (otherwise it'd be far too<br /> much)...<br
/><br/> I don't like how the backend would have to send something NOTICE-like, I<br /> had originally been thinking
"gee,it'd be nice if psql could query<br /> pg_stat while doing something else", but that's not really possible...<br
/>So, I guess NOTICE-like messages would work, if the backend could be<br /> taught to do it.<br /><br />
Thanks,<br/><font color="#888888"><br /> Stephen<br /></font><br />-----BEGIN PGP SIGNATURE-----<br />
Version:GnuPG v1.4.9 (GNU/Linux)<br /><br /> iEYEARECAAYFAkxqzFwACgkQrzgMPqB3kijVbACfWkUc/A5+6NaViTf8f9yrN/vT<br />
Y3AAn1eDvj4meqxlr05r0L51j+OypNqs<br/> =f+ya<br /> -----END PGP SIGNATURE-----<br /><br /></blockquote>