SPI memory managment issue - Mailing list pgsql-general

From bsimon@loxane.com
Subject SPI memory managment issue
Date
Msg-id OF539ADD90.E493F3D8-ONC1256E4C.00449B72-C1256E4C.00449C9C@beauchamp.loxane.fr
Whole thread Raw
Responses Re: SPI memory managment issue
List pgsql-general

I've read in the doc that every memory allocation done in a spi memory context was freed at the end of the context (after spi_finish)
What happens if the context is is initialized inside another one ?

Here is my function :

spi_connect()

        execute query1;
        ...
        execute query10;

spi_finish()

The thing is that I do another spi_connect inside all subqueries (query1 ... query10) and the memory allocated inside all "subcontext"  doesn't seems  to be freed until the last call of spi_finish. (the one of the "big" function).

Hopefully I was clear enough :)
Any help ?

Benjamin.

pgsql-general by date:

Previous
From: Will Newton
Date:
Subject: Selecting reals into doubles
Next
From: Lincoln Yeoh
Date:
Subject: Re: Moving from MySQL to PGSQL....some questions