Re: C vs plpgsql and child processes

Поиск
Список
Период
Сортировка
Искать
От
Sean Chittenden
Тема
Re: C vs plpgsql and child processes
Дата
Msg-id
20030817184810.GB88411@perrin.int.nxad.com
Ответ на
Список
Дерево обсуждения
C vs plpgsql and child processes Jason Godden <jasongodden@optushome.com.au>
Re: C vs plpgsql and child processes Sean Chittenden <sean@chittenden.org>
Re: C vs plpgsql and child processes Jason Godden <jasongodden@optushome.com.au>
Re: C vs plpgsql and child processes Jan Wieck <JanWieck@Yahoo.com>
Re: C vs plpgsql and child processes Jason Godden <jasongodden@optushome.com.au>
> Problem is that when I call these particular functions from within
> plpgsql rather than through a single sql command the child never
> actually starts (or starts and then exits immediately).

Are you sure?  I can't think of much that'd prevent a C function from
executing other than how you've declared the function (ie, is PgSQL
caching the results of the function?).  Make sure you've declared it
as VOLATILE (or don't declare it anything and it'll default to
VOLATILE).

http://developer.postgresql.org/docs/postgres/sql-createfunction.html

-sc

-- 
Sean Chittenden
В списке pgsql-general по дате отправления
От: Karsten Hilbert
Дата:
От: James Moe
Дата:
Сообщение: Too many clients
FAQ