From: Scott Marlowe <scott.marlowe@gmail.com>
To: Gonzalo Aguilar Delgado <gaguilar@aguilardelgado.com>
Cc: pgsql-sql@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Problem with insert related to different schemas
Date: Wed, 21 Apr 2010 07:31:07 -0600
Message-ID: <o2pdcc563d11004210631o93ecd816za3501992a7064c2a@mail.gmail.com> (raw)
In-Reply-To: <1271856300.29798.4.camel@azul1>
References: <1271233402.10390.5.camel@azul1>
<m2rdcc563d11004200904r22b7b34fhea678e04c930beb7@mail.gmail.com>
<1271781155.6136.57.camel@azul1>
<15360.1271782885@sss.pgh.pa.us>
<1271856300.29798.4.camel@azul1>
On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado
<gaguilar@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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scott.marlowe@gmail.com, gaguilar@aguilardelgado.com, tgl@sss.pgh.pa.us
Subject: Re: Problem with insert related to different schemas
In-Reply-To: <o2pdcc563d11004210631o93ecd816za3501992a7064c2a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox