DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=rQXbL3Uibu+PZWxH9O8G8o8lONJshKXkJxWeVwNyNTRPDaizw/lquc7CeOmjCNOcS6
	XGJjgdeILIla1wVx1f6uggU4chzjqNZDhXd/WTjH1cdh+yOwnU3HwyZftA1VK4m3D2Ob
	gVG1Qggy4rnw8US7PbAojwsifGAJeBa5dv1S8=
MIME-Version: 1.0
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>
Date: Wed, 21 Apr 2010 07:31:07 -0600
Message-ID: <o2pdcc563d11004210631o93ecd816za3501992a7064c2a@mail.gmail.com>
Subject: Re: Problem with insert related to different schemas
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>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado
<gaguilar@aguilardelgado.com> wrote:
> Hi Tom,
>
>
>
>> >> This is a select query. =A0I don't think that's the right error messa=
ge.
>>
>> > Yes, but IS the correct error message.
>>
>> The query being complained of appears to be a generated foreign key
>> checking query. =A0It'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. =A0I 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 ob=
ject.