I wrote: > I'd venture that we should try to get rid of the restriction, but I'm > unsure whether removing the error check is sufficient or whether there > are real problems it's preventing.
I did a little experimentation and it seems that DECLARE CURSOR, FETCH, and CLOSE work perfectly fine when executed through SPI (after diking out the error check). So I see no reason to have that prohibition in place --- we may as well just take it out and save a few lines of code. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster