Re: patch to create system view that lists cursors
От | Neil Conway |
---|---|
Тема | Re: patch to create system view that lists cursors |
Дата | |
Msg-id | 1137365870.9145.60.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: patch to create system view that lists cursors (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: patch to create system view that lists cursors
|
Список | pgsql-patches |
On Thu, 2006-01-12 at 19:51 -0500, Tom Lane wrote: > Neil Conway <neilc@samurai.com> writes: > > It would also mean that this would produce unexpected results: > > "PREPARE foo AS SELECT * FROM pg_cursors; EXECUTE foo". > > Unexpected in what sense? "Unexpected" in the sense that the user would have no reason to expect an "<unnamed portal n>" row in the pg_cursors view, merely because we happen to create a portal internally to implement the EXECUTE command. I think the view should include the portals created by DECLARE CURSOR and "Bind" protocol messages, but should not include the unnamed portal or any other portals that are created internally as part of the implementation of other commands (e.g. EXECUTE). I'm not sure how to handle SPI: developers using SPI would expect to find their portals in the view, but those using SPI indirectly (e.g. via PL/foo) would probably find the clutter surprising. I'd say we need to include SPI portals in the view as well. -Neil
В списке pgsql-patches по дате отправления: