Re: Problem with insert related to different schemas

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