Re: Problem with accessing TOAST data in stored procedures

2021-02-19 Thread Pavel Stehule
pá 19. 2. 2021 v 16:19 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > > On 19.02.2021 11:12, Pavel Stehule wrote: > > > > pá 19. 2. 2021 v 9:08 odesílatel Konstantin Knizhnik < > k.knizh...@postgrespro.ru> napsal: > >> >> >> On 19.02.2021 10:47, Pavel Stehule wrote: >> >>

Re: Problem with accessing TOAST data in stored procedures

2021-02-19 Thread Konstantin Knizhnik
On 19.02.2021 11:12, Pavel Stehule wrote: pá 19. 2. 2021 v 9:08 odesílatel Konstantin Knizhnik mailto:k.knizh...@postgrespro.ru>> napsal: On 19.02.2021 10:47, Pavel Stehule wrote: pá 19. 2. 2021 v 8:39 odesílatel Konstantin Knizhnik mailto:k.knizh...@postgrespro.ru>> n

Re: Problem with accessing TOAST data in stored procedures

2021-02-19 Thread Pavel Stehule
pá 19. 2. 2021 v 9:08 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > > On 19.02.2021 10:47, Pavel Stehule wrote: > > > > pá 19. 2. 2021 v 8:39 odesílatel Konstantin Knizhnik < > k.knizh...@postgrespro.ru> napsal: > >> >> >> On 19.02.2021 10:14, Pavel Stehule wrote: >> >> >

Re: Problem with accessing TOAST data in stored procedures

2021-02-19 Thread Konstantin Knizhnik
On 19.02.2021 10:47, Pavel Stehule wrote: pá 19. 2. 2021 v 8:39 odesílatel Konstantin Knizhnik mailto:k.knizh...@postgrespro.ru>> napsal: On 19.02.2021 10:14, Pavel Stehule wrote: pá 19. 2. 2021 v 7:51 odesílatel Konstantin Knizhnik mailto:k.knizh...@postgrespro.ru>> n

Re: Problem with accessing TOAST data in stored procedures

2021-02-18 Thread Pavel Stehule
pá 19. 2. 2021 v 8:39 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > > On 19.02.2021 10:14, Pavel Stehule wrote: > > > > pá 19. 2. 2021 v 7:51 odesílatel Konstantin Knizhnik < > k.knizh...@postgrespro.ru> napsal: > >> >> >> On 18.02.2021 20:10, Pavel Stehule wrote: >> >> T

Re: Problem with accessing TOAST data in stored procedures

2021-02-18 Thread Pavel Stehule
pá 19. 2. 2021 v 8:17 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > I am sorry, maybe my reply was not (is not) correct - this issue was > reported four months ago, and now I think more about your words about ATX, > and I have no idea, how much it is related to community

Re: Problem with accessing TOAST data in stored procedures

2021-02-18 Thread Konstantin Knizhnik
On 19.02.2021 10:14, Pavel Stehule wrote: pá 19. 2. 2021 v 7:51 odesílatel Konstantin Knizhnik mailto:k.knizh...@postgrespro.ru>> napsal: On 18.02.2021 20:10, Pavel Stehule wrote: This has a negative impact on performance - and a lot of users use procedures without transacti

Re: Problem with accessing TOAST data in stored procedures

2021-02-18 Thread Konstantin Knizhnik
I am sorry, maybe my reply was not (is not) correct - this issue was reported four months ago, and now I think more about your words about ATX, and I have no idea, how much it is related to community pg or to pgpro. I am sure so implementation of autonomous transactions is pretty hard, but

Re: Problem with accessing TOAST data in stored procedures

2021-02-18 Thread Pavel Stehule
pá 19. 2. 2021 v 7:51 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > > On 18.02.2021 20:10, Pavel Stehule wrote: > > This has a negative impact on performance - and a lot of users use > procedures without transaction control. So it doesn't look like a good > solution. > >

Re: Problem with accessing TOAST data in stored procedures

2021-02-18 Thread Konstantin Knizhnik
On 18.02.2021 20:10, Pavel Stehule wrote: This has a negative impact on performance - and a lot of users use procedures without transaction control. So it doesn't look like a good solution. I am more concentrated on the Pg 14 release, where the work with SPI is redesigned, and I hope so thi

Re: Problem with accessing TOAST data in stored procedures

2021-02-18 Thread Pavel Stehule
čt 18. 2. 2021 v 18:10 odesílatel Pavel Stehule napsal: > > > čt 18. 2. 2021 v 16:01 odesílatel Konstantin Knizhnik < > k.knizh...@postgrespro.ru> napsal: > >> >> >> On 19.08.2020 22:20, Pavel Stehule wrote: >> >> >> >> st 19. 8. 2020 v 20:59 odesílatel Konstantin Knizhnik < >> k.knizh...@postgre

Re: Problem with accessing TOAST data in stored procedures

2021-02-18 Thread Pavel Stehule
čt 18. 2. 2021 v 16:01 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > > On 19.08.2020 22:20, Pavel Stehule wrote: > > > > st 19. 8. 2020 v 20:59 odesílatel Konstantin Knizhnik < > k.knizh...@postgrespro.ru> napsal: > >> >> >> On 19.08.2020 21:50, Pavel Stehule wrote: >> >>

Re: Problem with accessing TOAST data in stored procedures

2021-02-18 Thread Konstantin Knizhnik
On 19.08.2020 22:20, Pavel Stehule wrote: st 19. 8. 2020 v 20:59 odesílatel Konstantin Knizhnik mailto:k.knizh...@postgrespro.ru>> napsal: On 19.08.2020 21:50, Pavel Stehule wrote: Hi st 19. 8. 2020 v 19:22 odesílatel Konstantin Knizhnik mailto:k.knizh...@postgrespro.ru

Re: Problem with accessing TOAST data in stored procedures

2020-08-19 Thread Pavel Stehule
st 19. 8. 2020 v 20:59 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > > > On 19.08.2020 21:50, Pavel Stehule wrote: > > Hi > > st 19. 8. 2020 v 19:22 odesílatel Konstantin Knizhnik < > k.knizh...@postgrespro.ru> napsal: > >> Hi hackers, >> >> More than month ago I have sent

Re: Problem with accessing TOAST data in stored procedures

2020-08-19 Thread Konstantin Knizhnik
On 19.08.2020 21:50, Pavel Stehule wrote: Hi st 19. 8. 2020 v 19:22 odesílatel Konstantin Knizhnik mailto:k.knizh...@postgrespro.ru>> napsal: Hi hackers, More than month ago I have sent bug report to pgsql-bugs: https://www.postgresql.org/message-id/flat/5d335911-fb25-60cd-4a

Re: Problem with accessing TOAST data in stored procedures

2020-08-19 Thread Pavel Stehule
Hi st 19. 8. 2020 v 19:22 odesílatel Konstantin Knizhnik < k.knizh...@postgrespro.ru> napsal: > Hi hackers, > > More than month ago I have sent bug report to pgsql-bugs: > > > https://www.postgresql.org/message-id/flat/5d335911-fb25-60cd-4aa7-a5bd0954aea0%40postgrespro.ru > > with the proposed pa