Samuel Gilbert writes:
> I have encountered a problem with inserts failing because of permissions
> issues when the table in which I try to insert has foreign key constraints to
> tables for which UPDATE has been revoked.
Yeah, this is because the insertion has to take a row lock on the
refere
Hello Alban,
You are right on both count of me not using the "test" user. At first, it
was set-up to use the "test" user, but later on, I wondered if owner of a
database got treated differently. The behaviour is the same regardless of if
it's the owner or any other role.
In the end, I go
On 23 Jul 2010, at 20:39, Samuel Gilbert wrote:
> Hello,
>
> I have encountered a problem with inserts failing because of permissions
> issues when the table in which I try to insert has foreign key constraints to
> tables for which UPDATE has been revoked.
>
> The script bellow show how to r
Hello,
I have encountered a problem with inserts failing because of permissions
issues when the table in which I try to insert has foreign key constraints to
tables for which UPDATE has been revoked.
The script bellow show how to reproduce the problem with a bare-bones test
case. Reproducib
