James Harper wrote: > 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 call > BackgroundWorkerInitializeConnection then SPI_connect I get a segfault.
You need to start a transaction after initializing the database connection. Did you see the sample worker_spi code in contrib? -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
