On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado <gagui...@aguilardelgado.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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
