From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gonzalo Aguilar Delgado <gaguilar@aguilardelgado.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem with insert related to different schemas
Date: Tue, 20 Apr 2010 13:01:25 -0400
Message-ID: <15360.1271782885@sss.pgh.pa.us> (raw)
In-Reply-To: <1271781155.6136.57.camel@azul1>
References: <1271233402.10390.5.camel@azul1>
<m2rdcc563d11004200904r22b7b34fhea678e04c930beb7@mail.gmail.com>
<1271781155.6136.57.camel@azul1>
Gonzalo Aguilar Delgado <gaguilar@aguilardelgado.com> writes:
>> 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.
> 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.
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: tgl@sss.pgh.pa.us, gaguilar@aguilardelgado.com, scott.marlowe@gmail.com
Subject: Re: Problem with insert related to different schemas
In-Reply-To: <15360.1271782885@sss.pgh.pa.us>
* 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