ToDo: API for SQL statement execution other than SPI - Mailing list pgsql-hackers

From Pavel Stehule
Subject ToDo: API for SQL statement execution other than SPI
Date
Msg-id CAFj8pRD5oik3Ln4dNGFwTHn3gJMN0MGjmsFOrFKCZmYahZ27sg@mail.gmail.com
Whole thread Raw
Responses Re: ToDo: API for SQL statement execution other than SPI  (Craig Ringer <craig@2ndquadrant.com>)
Re: ToDo: API for SQL statement execution other than SPI  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
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 REINDEX CONCURRENTLY is not possible call from SPI.

Can be nice to have this function in core.

Regards

Pavel

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Reviewing freeze map code
Next
From: Kouhei Kaigai
Date:
Subject: Re: make clean didn't clean up files generated from *.(y|l)