Re: Problem with insert related to different schemas

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. About linking the wrong FK... Everything is
posible. I have to take a look to them again and try isolate the
problem.

But I thought that it was a restriction of the jdbc driver used with
postgresql. It looks like when you specify a schema for the query no
other schema references are allowed... But I tried directly through the
psql client and returned same error so it must be isolated at database
level.

Anyway, let me provide a test case.

Thank you

>
> regards, tom lane
>