SPI memory managment issue

From: bsimon(at)loxane(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: SPI memory managment issue
Date: 2004-03-03 12:35:37
Message-ID: OF539ADD90.E493F3D8-ONC1256E4C.00449B72-C1256E4C.00449C9C@beauchamp.loxane.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Colin Fox 2004-03-03 12:39:38 Trigger using 'if NEW = OLD'
Previous Message satish satish 2004-03-03 12:27:33 Data Corruption in case of abrupt failure