From: Gonzalo Aguilar Delgado <gaguilar@aguilardelgado.com>
To: pgsql-sql@postgresql.org
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Problem with insert related to different schemas
Date: Wed, 21 Apr 2010 15:25:00 +0200
Message-ID: <1271856300.29798.4.camel@azul1> (raw)
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>
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
>
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: gaguilar@aguilardelgado.com, scott.marlowe@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Problem with insert related to different schemas
In-Reply-To: <1271856300.29798.4.camel@azul1>
* 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