From: Gonzalo Aguilar Delgado <gaguilar@aguilardelgado.com>
To: 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 18:32:35 +0200
Message-ID: <1271781155.6136.57.camel@azul1> (raw)
In-Reply-To: <m2rdcc563d11004200904r22b7b34fhea678e04c930beb7@mail.gmail.com>
References: <1271233402.10390.5.camel@azul1>
<m2rdcc563d11004200904r22b7b34fhea678e04c930beb7@mail.gmail.com>
> > Hi Everyone,
> >
> > I've come along with a problem that appeared with latest version of
> > Postgresql 8.4.2.
> >
> > I'm trying to insert a row in the analysis schema:
> >
>
> This is an insert query:
Yes it is...
>
> > INSERT INTO
> > "analisys"."response_quality" ("uuid","id_survey_question","id_survey","id_survey_status","id_shop","survey_question_response","id_survey_answer","date_survey_answer") VALUES ('83968de5-eac7-4f52-bbec-7392a198f556',7,1,1,16,3,9987,'2009-12-01 00:00:00.000000 +01:00:00')
> >
> >
> > But it fails because:
>
> This is a select query. I don't think that's the right error message.
Yes, but IS the correct error message. It appeared just after upgrading
to 8.4 as 8.3 had no problem processing this query.
I think that something internally is done with foreign key validation
and it's the root cause of this error.
I can confirm this because removing the foreign key constraint solved
the problem (but will not maintain reference integrity).
That's why I see this strange...
I can try to isolate the problem if you want but it should be redoable
by using inserts with foreign keys in different schemas...
What do you think?
Thank you for your answer
>
> >
> > ERROR: permiso denegado al esquema public
> > LÍNEA 1: SELECT 1 FROM ONLY "public"."survey_question" x WHERE "id_su...
> > ^
> > CONSULTA: SELECT 1 FROM ONLY "public"."survey_question" x WHERE
> > "id_survey_question" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x
>
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
Subject: Re: Problem with insert related to different schemas
In-Reply-To: <1271781155.6136.57.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