Subject: Re: Problem with insert related to different schemas
From: Gonzalo Aguilar Delgado <gaguilar@aguilardelgado.com>
To: pgsql-sql@postgresql.org
Cc: Scott Marlowe <scott.marlowe@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
In-Reply-To: <15360.1271782885@sss.pgh.pa.us>
References: <1271233402.10390.5.camel@azul1>
	<m2rdcc563d11004200904r22b7b34fhea678e04c930beb7@mail.gmail.com>
	<1271781155.6136.57.camel@azul1>  <15360.1271782885@sss.pgh.pa.us>
Content-Type: text/plain; charset="UTF-8"
Date: Wed, 21 Apr 2010 15:25:00 +0200
Message-ID: <1271856300.29798.4.camel@azul1>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

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
>