[HACKERS] Re[2]: [HACKERS] Re[2]: [HACKERS] Connect from background worker thread to database

2013-11-24 Thread Alexey Vasiliev
Понедельник, 25 ноября 2013, 13:31 +09:00 от Michael Paquier : >On Mon, Nov 25, 2013 at 1:02 PM, Alexey Vasiliev < leopard...@inbox.ru > wrote: >> Thanks, I just try this. This work if I working with database in loop inside >> bgw_main function. But if I create threads inside bgw_main and try to

Re: [HACKERS] Re[2]: [HACKERS] Connect from background worker thread to database

2013-11-24 Thread Michael Paquier
On Mon, Nov 25, 2013 at 1:02 PM, Alexey Vasiliev wrote: > Thanks, I just try this. This work if I working with database in loop inside > bgw_main function. But if I create threads inside bgw_main and try to > connect to database - I have errors "stack depth limit exceeded" . The code: > > https://

[HACKERS] Re[2]: [HACKERS] Re[2]: [HACKERS] Connect from background worker thread to database

2013-11-24 Thread Alexey Vasiliev
Понедельник, 25 ноября 2013, 8:31 +09:00 от Michael Paquier : >On Mon, Nov 25, 2013 at 2:10 AM, Alexey Vasiliev < leopard...@inbox.ru > wrote: >> Воскресенье, 24 ноября 2013, 14:06 +01:00 от Andres Freund >> < and...@anarazel.de >: >> >> Hi, >> >> >> On 2013-11-24 16:27:06 +0400, Олексій Васильєв

Re: [HACKERS] Re[2]: [HACKERS] Connect from background worker thread to database

2013-11-24 Thread Michael Paquier
On Mon, Nov 25, 2013 at 2:10 AM, Alexey Vasiliev wrote: > Воскресенье, 24 ноября 2013, 14:06 +01:00 от Andres Freund > : > > Hi, > > > On 2013-11-24 16:27:06 +0400, Олексій Васильєв wrote: >> This is part where I try to connect to database: >> https://github.com/le0pard/pg_web/blob/master/src/pg_w

[HACKERS] Re[2]: [HACKERS] Connect from background worker thread to database

2013-11-24 Thread Alexey Vasiliev
Воскресенье, 24 ноября 2013, 14:06 +01:00 от Andres Freund : >Hi, > >On 2013-11-24 16:27:06 +0400, Олексій Васильєв wrote: >> This is part where I try to connect to database:  >> https://github.com/le0pard/pg_web/blob/master/src/pg_web.c#L92-L132 , but  >> SPI functions give error in log (it is

[HACKERS] Re[2]: [HACKERS] Connect from background worker thread to database

2013-11-24 Thread Олексій Васильєв
If I remove comment from BackgroundWorkerInitializeConnection  https://github.com/le0pard/pg_web/blob/master/src/pg_web.c#L179  and comment  InitPostgres  https://github.com/le0pard/pg_web/blob/master/src/pg_web.c#L98 , I have the same errors in log: 2013-11-24 13:35:24 UTC ERROR:  stack depth