Re: Problems with MemoryContextSwitchTo ()

2020-09-16 Thread Pavel Stehule
čt 17. 9. 2020 v 6:09 odesílatel Pavel Stehule napsal: > > > čt 17. 9. 2020 v 3:16 odesílatel Yessica Brinkmann < > brinkmann.yess...@gmail.com> napsal: > >> 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

Re: Problems with MemoryContextSwitchTo ()

2020-09-16 Thread Pavel Stehule
čt 17. 9. 2020 v 3:16 odesílatel Yessica Brinkmann < brinkmann.yess...@gmail.com> napsal: > 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 t

Re: Problems with MemoryContextSwitchTo ()

2020-09-16 Thread Yessica Brinkmann
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 sho

Re: Problems with MemoryContextSwitchTo ()

2020-09-16 Thread Pavel Stehule
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 li

Re: Problems with MemoryContextSwitchTo ()

2020-09-16 Thread Yessica Brinkmann
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. Mensaje original Asunto: Re: Problems with MemoryContextSwitchTo ()De: Pavel Stehule Para: Yessica B

Re: Problems with MemoryContextSwitchTo ()

2020-09-16 Thread Yessica Brinkmann
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-

Re: Obvious data mismatch in View2 which basically SELECT * from View1

2020-09-16 Thread Ben
Hi Magnus, Thanks for the heads up. For the data posted in this email, the listed result is the full result set for that query. I have checked the data in view2 and view1 with various conditions. Both view has many difference in column wspan::float8. The condition in the shown query is intende

Re: Problems with MemoryContextSwitchTo ()

2020-09-16 Thread Pavel Stehule
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 o

Re: Problems with MemoryContextSwitchTo ()

2020-09-16 Thread Yessica Brinkmann
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

Re: Obvious data mismatch in View2 which basically SELECT * from View1

2020-09-16 Thread Magnus Hagander
On Wed, Sep 16, 2020 at 9:26 AM Ben wrote: > Dear list, > > Recently I am getting feedback, data in my analytic report is not > repeatable. From time to time they get different data for the same time > span. > (but IIRC previously it was OK). Therefore I started debuging the View > chain for that

Re: Obvious data mismatch in View2 which basically SELECT * from View1

2020-09-16 Thread Ron
On 9/15/20 10:40 PM, Ben wrote: Dear list, Recently I am getting feedback, data in my analytic report is not repeatable. From time to time they get different data for the same time span. (but IIRC previously it was OK). Therefore I started debuging the View chain for that report, during which

Obvious data mismatch in View2 which basically SELECT * from View1

2020-09-16 Thread Ben
Dear list, Recently I am getting feedback, data in my analytic report is not repeatable. From time to time they get different data for the same time span. (but IIRC previously it was OK). Therefore I started debuging the View chain for that report, during which I bumped into this issue/phenome

Re: multiple tables got corrupted

2020-09-16 Thread Vasu Madhineni
I could see block read I/O errors in /var/log/syslog. if those error fixed by OS team, will it require recovery. Also can i use LIMIT and OFFSET to locate corrupted rows? Thanks in advance Regards, Vasu Madhineni On Wed, Sep 16, 2020, 01:58 Magnus Hagander wrote: > Try reading them "row by ro