Re: Is it possible to call Postgres directly?

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Is it possible to call Postgres directly?
Дата
Msg-id 57187435.4050303@hogranch.com
обсуждение исходный текст
Ответ на Re: Is it possible to call Postgres directly?  (<david@andl.org>)
Список pgsql-general
On 4/20/2016 10:59 PM, david@andl.org wrote:
> So the question is: Can a C program link to the Postgres DLL and call SPI
> directly, rather than through a language function?
>
> Is there a way to launch a Thrift server or a Web server and call SPI
> directly?


no, those can only be called from the context of a function that was
called from SQL as part of a query.

if you want to completely replace SQL as the query language, why don't
you just provide your own Andl API, and have it run in the client
context and execute SQL queries via the normal libpq style API ?

you could still use pl/andl for things like triggers and such but not
for direct client queries.


--
john r pierce, recycling bits in santa cruz



В списке pgsql-general по дате отправления:

Предыдущее
От: martin.kamp.jensen@schneider-electric.com
Дата:
Сообщение: Invalid data read from synchronously replicated hot standby
Следующее
От: Sachin Kotwal
Дата:
Сообщение: Re: error while installing auto_explain contrib module