Yes, this is a known issue due to the fact that the
triggers use SPI and need to use SELECT ... FOR UPDATE
to lock the rows it is reading (and select for update
requires the update permission). The workaround I
know about for now is to give update permission and make
triggers to disallow updates as appropriate.
(If this isn't in the TODO list or FAQ yet, it probably
should be.)
Stephan Szabo
sszabo@bigpanda.com
On Wed, 23 Aug 2000 pgsql-bugs@postgresql.org wrote:
> NAGY Andras (nagya@inf.elte.hu) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> Foreign keys referencing read-only tables fail