Re: Preventing some SQL commands

Tom Lane wrote:

>>... I would like to prevent the commands "begin [work or 
>>transaction]", "commit", and "rollback",  completely
>>
>If you are executing through SPI then those operations are disallowed
>already.
>  
>
Ah, yes I had forgotten that. One problem less to solve.

>The main problem with this proposal is the erroneous assumption that
>there can be only one command in a SPI plan.
>  
>
Ok, so let the function return a list of CmdType's terminated by the 
CMD_UNKNOWN (i assume that's an invalid value). The list should be 
pfree'd by the caller:

CmdType* SPI_get_command_types(void* executionPlan)

how about that?

Regards,
Thomas Hallgren