Good night, Thank you very much for the answer. Excuse me please just answered, I was at my job. And yes, I get the results of the list with SPI_exec. And I am also using SPI_finish (). But I save the results of the previous query in the array idxcd-> varattnnames. And in the second foreach it should print me the values that I got in the query, since I print the values of idxcd-> varattnnames, but it is printing null. And I think the memory context switch is fine too, so I really don't know why it prints null to me. I will greatly appreciate a help please. I can't really understand why it prints null in the second foreach, even though I already tried various changes. Best regards, Yessica Brinkmann
El mié., 16 sept. 2020 a las 9:16, Pavel Stehule (<pavel.steh...@gmail.com>) escribió: > > > st 16. 9. 2020 v 15:09 odesílatel Yessica Brinkmann < > brinkmann.yess...@gmail.com> napsal: > >> Well, the fact is that I have a function called get_columnnames, which in >> the second foreach, is printing the values of idxcd-> varattnnames [i] the >> null value. This is the error. > > > How you get this list? It is result of SPI_exec*** ? > > There is SPI_finish(), that cleaning a memory used by SPI interface, and > theoretically it can clean result of previous query. > > Regards > > Pavel > > >> >> -------- Mensaje original -------- >> Asunto: Re: Problems with MemoryContextSwitchTo () >> De: Pavel Stehule >> Para: Yessica Brinkmann >> CC: pgsql-general >> >> >> >> >> st 16. 9. 2020 v 13:32 odesílatel Yessica Brinkmann < >> brinkmann.yess...@gmail.com> napsal: >> >>> Good Morning. >>> I will greatly appreciate a help please on this subject. I actually did >>> several tests already and tried a lot to fix it myself. But I am not >>> able to. And I really need to know this in order to finish my >>> university thesis. If someone can help me please. >>> Best regards, >>> Yessica Brinkmann >>> >> >> please, can you attach your code, and can you show the error message? >> >> It is hard to say what is the problem from your mail? >> >> Regards >> >> Pavel >> >> >> >>> >>> El mié., 16 sept. 2020 a las 0:42, Yessica Brinkmann (< >>> brinkmann.yess...@gmail.com>) escribió: >>> >>>> >>>> >>>> Hello. >>>> I think several of you will already remember me. I'm the one with the >>>> IndexAdviser topic. Only that I changed my email address. >>>> As you may recall, I am doing my thesis on the subject of IndexAdviser >>>> modifications. >>>> I really appreciate the help they have given me in various Postgresql >>>> groups. >>>> Well, I was really nearing the end of the programming part of the >>>> thesis, when I had a problem to be able to compile my program in a moment, >>>> and by accident some lines of source code were moved. >>>> And for this reason, I think I have problems again with the context >>>> switch issue, since at some point my context switch stopped working for me, >>>> I think because of the issue that some lines of source code were moved. >>>> Well, the fact is that I have a function called get_columnnames, which >>>> in the second foreach, is printing the values of idxcd-> varattnnames [i] >>>> the null value. >>>> This second foreach, I only do it to test if the data is really saved >>>> well and if I can recover it properly. >>>> And since the data is not retrieved properly, or is not saved properly, >>>> in the following functions of my program, the value of idxcd-> varattnnames >>>> [i] continues to appear as null. >>>> I will appreciate a lot please help, if you can tell me please why the >>>> function prints null in the values of idxcd-> varattnnames [i], in the >>>> second foreach, if it is due to an error in the context switch, or why it >>>> could be . >>>> >>>> I send my function as an attachment. >>>> >>>> >>>> Best regards, >>>> Yessica Brinkmann. >>>> >>>
