spi in bgworker

Поиск
Список
Период
Сортировка
От James Harper
Тема spi in bgworker
Дата
Msg-id F214C06498BC244DB3F9472E1C5368180F41E411@BITCOM1.int.sbss.com.au
обсуждение исходный текст
Ответы Re: spi in bgworker  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
The docs say I'm supposed to call BackgroundWorkerInitializeConnection in a bgworker and then I can start using spi
functions,but they aren't clear on if I should call SPI_connect too. 

If I call BackgroundWorkerInitializeConnection and then SPI_execute I get a return code of SPI_ERROR_UNCONNECTED. If I
callBackgroundWorkerInitializeConnection then SPI_connect I get a segfault. 

I'm initialising my worker as:

    strncpy(worker.bgw_name, "tds handler", sizeof(worker.bgw_name));
    worker.bgw_flags = BGWORKER_SHMEM_ACCESS | BGWORKER_BACKEND_DATABASE_CONNECTION;
    worker.bgw_start_time = BgWorkerStart_RecoveryFinished;
    worker.bgw_restart_time = BGW_NEVER_RESTART;
    //worker.bgw_main_arg = 1433;
    worker.bgw_main = tdsworker;
    RegisterDynamicBackgroundWorker(&worker, &handle);

What am I missing? (this is 9.4 obviously, as I'm using a dynamic bgworker)

Thanks

James


В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: 9.3 debian install setup failure
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: spi in bgworker