Solution for RI permission problem

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Solution for RI permission problem
Дата
Msg-id
Pine.LNX.4.21.0009200033300.362-200000@peter
Список
Дерево обсуждения
Solution for RI permission problem Peter Eisentraut <peter_e@gmx.net>
Re: Solution for RI permission problem Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Solution for RI permission problem Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Solution for RI permission problem Peter Eisentraut <peter_e@gmx.net>
Re: Solution for RI permission problem Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: Solution for RI permission problem Jan Wieck <janwieck@Yahoo.com>
Re: Solution for RI permission problem Stephan Szabo <sszabo@megazone23.bigpanda.com>
Here's what I've come up with to avoid "permission denied" errors when a
RI trigger has to lock a PK table.  Whenever the SELECT FOR UPDATE is
executed I temporarily switch the current user id to the owner of the PK
table.  It's not the grand unified solution via setuid functions that was
envisioned now and then, but it does the same conceptually.  For a
terminally elegant solution I can only suggest not using the SPI
interface.

I recommend this patch to be checked out by someone knowledgeable in the
RI area.


-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/
В списке pgsql-hackers по дате отправления
От: Jerome Raupach
Дата:
Сообщение: error with COPY
От: Peter Eisentraut
Дата:
Сообщение: Re: Cascade delete views?
FAQ