libpq and SPI

Поиск
Список
Период
Сортировка
Искать
От
Gerald L. Gay
Тема
libpq and SPI
Дата
Msg-id
018201be605a$30ad00c0$9a028a8f@2isdt54.korea.army.mil
Список
Hi,

    I sent an email a few days ago and I haven't seen any response yet.
Basically, the problem is, if you do any "utility" queries inside of a SPI
function, libpq will lock up.  You can see this by installing the execq()
example from the Programmer's Guide and doing the following from psql:

template1=>  select execq('create user fred', 1);
Backend sent D message without prior T


    And you will not get a prompt back.  I was looking for thoughts on this.
Is it not reasonable to allow utility calls inside SPI?  Should the backend
be sending data through libpq differently?  Or should the client-side libpq
be handling this better?  I patched the client-side libpq since I didn't
want to go messing with the backend.

    Should this discussion be on a different mailing list?

    Any ideas would be greatly appreciated.

Jerry


В списке pgsql-interfaces по дате отправления
От: Shoku Yanagawa
Дата:
От: David Hartwig
Дата:
FAQ