Re: Repeatable Read Isolation in SQL running via background worker

2018-08-16 Thread Jeremy Finzel
On Tue, Aug 14, 2018 at 11:18 AM, Robert Haas wrote: > On Mon, Aug 13, 2018 at 10:52 AM, Jeremy Finzel wrote: > > On Thu, Aug 9, 2018 at 4:34 PM, Jeremy Finzel wrote: > >> I am using worker_spi as a model to run a SQL statement inside a > >> background worker. From my browsing of the Postgres

Re: Repeatable Read Isolation in SQL running via background worker

2018-08-14 Thread Robert Haas
On Mon, Aug 13, 2018 at 10:52 AM, Jeremy Finzel wrote: > On Thu, Aug 9, 2018 at 4:34 PM, Jeremy Finzel wrote: >> I am using worker_spi as a model to run a SQL statement inside a >> background worker. From my browsing of the Postgres library, I believe that >> if I want repeatable read isolation

Re: Repeatable Read Isolation in SQL running via background worker

2018-08-13 Thread Jeremy Finzel
On Thu, Aug 9, 2018 at 4:34 PM, Jeremy Finzel wrote: > I am using worker_spi as a model to run a SQL statement inside a > background worker. From my browsing of the Postgres library, I believe > that if I want repeatable read isolation level, the proper way for me to > attain this is to add this

Repeatable Read Isolation in SQL running via background worker

2018-08-09 Thread Jeremy Finzel
I am using worker_spi as a model to run a SQL statement inside a background worker. From my browsing of the Postgres library, I believe that if I want repeatable read isolation level, the proper way for me to attain this is to add this line after StartTransactionCommand() in worker_spi_main: Xact