worker_spi shouldn't execute again on sigterm - Mailing list pgsql-hackers

From Jeremy Finzel
Subject worker_spi shouldn't execute again on sigterm
Date
Msg-id CAMa1XUgOWqhUpHX_GKkM-YVoy6AOW0rPaRpYDbY01dyc6dtjPQ@mail.gmail.com
Whole thread Raw
Responses Re: worker_spi shouldn't execute again on sigterm  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
I noticed that the way the test module worker_spi is written, it will execute the main loop SQL one more time after it gets a sigterm, THEN exit 1.  This was surprising to me where I used this module as a pattern for my own background worker as I would have thought it should bail immediately without executing any more SQL.

Shouldn't we add something like this line before it enters the phase where it starts the transaction and executes the SQL?

                  /*
                 * In case of a SIGTERM, exit immediately
                 */
                if (got_sigterm)
                {
                        break;
                }

Please help me if I'm missing something.

Thanks,
Jeremy

pgsql-hackers by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Markdown format output for psql, design notes
Next
From: Evgeniy Efimkin
Date:
Subject: Re: [WIP] CREATE SUBSCRIPTION with FOR TABLES clause (table filter)