ToDo: API for SQL statement execution other than SPI

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: ToDo: API for SQL statement execution other than SPI
Date: 2016-06-29 05:55:59
Message-ID: CAFj8pRD5oik3Ln4dNGFwTHn3gJMN0MGjmsFOrFKCZmYahZ27sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kouhei Kaigai 2016-06-29 06:02:14 Re: make clean didn't clean up files generated from *.(y|l)
Previous Message Masahiko Sawada 2016-06-29 05:44:51 Re: Reviewing freeze map code