Re: Problem with insert related to different schemas - Mailing list pgsql-sql

From Gonzalo Aguilar Delgado
Subject Re: Problem with insert related to different schemas
Date
Msg-id 1271781155.6136.57.camel@azul1
Whole thread Raw
In response to Re: Problem with insert related to different schemas  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Problem with insert related to different schemas
Re: Problem with insert related to different schemas
List pgsql-sql
<br /><blockquote type="CITE"><pre>
> 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:
</pre></blockquote><br /> Yes it is...<br /><br /><blockquote type="CITE"><pre>

> 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.
</pre></blockquote><br /> Yes, but IS the correct error message. It appeared just after upgrading to 8.4 as 8.3 had no
problemprocessing this query.<br /><br /> I think that something internally is done with foreign key validation and
it'sthe root cause of this error. <br /><br /> I can confirm this because removing the foreign key constraint solved
theproblem (but will not maintain reference integrity).<br /><br /> That's why I see this strange...<br /><br /> I can
tryto isolate the problem if you want but it should be redoable by using inserts with foreign keys in different
schemas...<br/><br /><br /> What do you think?<br /><br /> Thank you for your answer<br /><br /><br /><br /><br
/><blockquotetype="CITE"><pre>
 

>
> 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

</pre></blockquote>

pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Problem with insert related to different schemas
Next
From: Scott Marlowe
Date:
Subject: Re: Problem with insert related to different schemas