Re: I think that my data is saved correctly, but when printing again, other data appears

2019-11-26 Thread Yessica Brinkmann
I understand. Thank you very much for clearing things up. It helps me a lot, especially point 3. "3. When you run SPI_connect () the memory context is switched transparently for you to a special SPI memory context. When you run SPI_finish () the original memory context (the one in effect be

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-11-26 Thread Joe Conway
On 11/25/19 4:38 PM, Yessica Brinkmann wrote: > Well, as I was told that I should save the > CurrentMemoryContext before starting the SPI, Let's say it would be > before doing SPI_connect (). Is this correct? And then I must use > MemoryContextStrdup. As you told me the MemoryContextStrdup It is >

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-11-25 Thread Yessica Brinkmann
Good afternoon, Well, I spent some time without implementing my thesis for a topic of mental fatigue, I had to go for a while. A few days ago I came back and was trying to implement the context change. But I really believe that, although I read the explanations and source codes that you indicated,

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-28 Thread Yessica Brinkmann
Thank you very much for the answer. Best regards, Yessica Brinkmann El lun., 28 oct. 2019 a las 8:03, Joe Conway () escribió: > On 10/27/19 8:01 PM, Yessica Brinkmann wrote: > > Thank you so much for the answers. > > By telling me this: "MemoryContextStrdup enables you to create a copy of > > a

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-28 Thread Joe Conway
On 10/27/19 8:01 PM, Yessica Brinkmann wrote: > Thank you so much for the answers. > By telling me this: "MemoryContextStrdup enables you to create a copy of > a string in an explicitly specified memory context." I better understood > the function of MemoryContextStrdup. > And thank you very much t

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-27 Thread Yessica Brinkmann
a Brinkmann (< >> yessica.brinkm...@gmail.com>) escribió: >> >>> Thank you so much for your answer. I will be testing the indicated and >>> then I give you return. >>> Best regards, >>> >>> Yessica Brinkmann >>> >>> >&g

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-27 Thread Jony Cohen
t. 2019 a las 12:24, Yessica Brinkmann (< > yessica.brinkm...@gmail.com>) escribió: > >> Thank you so much for your answer. I will be testing the indicated and >> then I give you return. >> Best regards, >> >> Yessica Brinkmann >> >> >> --

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-27 Thread Laurenz Albe
On Fri, 2019-10-25 at 22:06 -0300, Yessica Brinkmann wrote: > What I do not understand well is how to use CurrentMemoryContext and > MemoryContextStrdup For examples using memotry contexts, search the PostgreSQL source code. To make memory management easier and safer, PostgreSQL has implemented

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-26 Thread Yessica Brinkmann
I give you return. >> Best regards, >> >> Yessica Brinkmann >> >> >> ---- Mensaje original >> Asunto: Re: I think that my data is saved correctly, but when printing >> again, other data appears >> De: Tom Lane >> Para: Yessica Brin

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-25 Thread Yessica Brinkmann
ds, > > Yessica Brinkmann > > > Mensaje original -------- > Asunto: Re: I think that my data is saved correctly, but when printing > again, other data appears > De: Tom Lane > Para: Yessica Brinkmann > CC: pgsql-general@lists.postgresql.org > > > Yessic

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-25 Thread Yessica Brinkmann
Thank you so much for your answer. I will be testing the indicated and then I give you return.Best regards,Yessica Brinkmann Mensaje original Asunto: Re: I think that my data is saved correctly, but when printing again, other data appearsDe: Tom Lane Para: Yessica Brinkmann CC: pgsq

Re: I think that my data is saved correctly, but when printing again, other data appears

2019-10-25 Thread Tom Lane
Yessica Brinkmann writes: > I have a function called get_columnnames, which runs on a Postgresql server > and returns the names of the columns of a table in a Postgresql database. > In the first foreach, in the statement: idxcd-> varattnames [cont] = data; > column names are saved. Those column na

I think that my data is saved correctly, but when printing again, other data appears

2019-10-25 Thread Yessica Brinkmann
Good day, I am doing a thesis from the University. My thesis is the modification of the Gurjeet Index Adviser, to add some features. I have a function called get_columnnames, which runs on a Postgresql server and returns the names of the columns of a table in a Postgresql database. In the first for