Re: [HACKERS] ToDo: API for SQL statement execution other than SPI

2016-07-01 Thread Vibhor Kumar
> On Jul 1, 2016, at 11:39 AM, Robert Haas wrote: > > On Wed, Jun 29, 2016 at 1:55 AM, Pavel Stehule > wrote: >> I am writing two background workers - autoreindex and scheduler. In Both I >> need to execute

Re: [HACKERS] ToDo: API for SQL statement execution other than SPI

2016-07-01 Thread Robert Haas
On Wed, Jun 29, 2016 at 1:55 AM, Pavel Stehule wrote: > I am writing two background workers - autoreindex and scheduler. In Both I > need to execute queries from top level. I had to wrote redundant code > https://github.com/okbob/autoreindex/blob/master/utils.c >

Re: [HACKERS] ToDo: API for SQL statement execution other than SPI

2016-06-29 Thread Craig Ringer
On 29 June 2016 at 13:55, Pavel Stehule wrote: > Hi > > I am writing two background workers - autoreindex and scheduler. In Both I > need to execute queries from top level. I had to wrote redundant code > https://github.com/okbob/autoreindex/blob/master/utils.c >

[HACKERS] ToDo: API for SQL statement execution other than SPI

2016-06-28 Thread Pavel Stehule
Hi I am writing two background workers - autoreindex and scheduler. In Both I need to execute queries from top level. I had to wrote redundant code https://github.com/okbob/autoreindex/blob/master/utils.c autoreindex_execute_sql_command .Same code is in pglogical. Some statements - like VACUUM or