On Thu, 2006-01-12 at 19:51 -0500, Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings