Обсуждение: Ticket #6: Add a cursors list in the server status window
Hi, I was working on this tonight. It aims to display the contents of the pg_cursors view. Halfway through it, it occurs to me that this is not a great thing to do. AFAICT, the contents of this view only depends on your session. But the status window has its own session, so it won't be able to display anything but its own cursors (which really means nothing as it doesn't use cursors). Am I wrong? -- Guillaume. http://www.postgresqlfr.org http://dalibo.com
On Mon, Sep 14, 2009 at 22:02, Guillaume Lelarge <guillaume@lelarge.info> wrote: > Hi, > > I was working on this tonight. It aims to display the contents of the > pg_cursors view. Halfway through it, it occurs to me that this is not a great > thing to do. > > AFAICT, the contents of this view only depends on your session. But the status > window has its own session, so it won't be able to display anything but its > own cursors (which really means nothing as it doesn't use cursors). > > Am I wrong? Nope, you're right. Actually, by default, they go away at the end of a transaction even, so that's even worse. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
Le lundi 14 septembre 2009 à 22:07:24, Magnus Hagander a écrit : > On Mon, Sep 14, 2009 at 22:02, Guillaume Lelarge <guillaume@lelarge.info> wrote: > > Hi, > > > > I was working on this tonight. It aims to display the contents of the > > pg_cursors view. Halfway through it, it occurs to me that this is not a > > great thing to do. > > > > AFAICT, the contents of this view only depends on your session. But the > > status window has its own session, so it won't be able to display > > anything but its own cursors (which really means nothing as it doesn't > > use cursors). > > > > Am I wrong? > > Nope, you're right. Actually, by default, they go away at the end of a > transaction even, so that's even worse. > Well, I suppose the good part of this is it's one less ticket to take care of. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com