Re: Problem with insert related to different schemas

On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado
<gaguilar(at)aguilardelgado(dot)com> wrote:
> Hi Tom,
>
>
>
>> >> This is a select query.  I don't think that's the right error message.
>>
>> > Yes, but IS the correct error message.
>>
>> The query being complained of appears to be a generated foreign key
>> checking query.  It's not surprising it would appear in the context
>> of an insert.
>
> Yes, that's what I think too...
>
>>
>> > It appeared just after upgrading
>> > to 8.4 as 8.3 had no problem processing this query.
>>
>> You've either changed the permissions on schema public from what they
>> were in the old installation, or linked an FK constraint to the wrong
>> table.  I see no reason to think there is either a bug or a version
>> difference here.
>
> Maybe but I ran even grant all on schema public for this user to check
> if this was the problem.

That doesn't do what you think it does. You need to grant on the actual object.