Re: [SQL] Problem with insert related to different schemas

2010-04-21 Thread Gonzalo Aguilar Delgado
Hi Tom, This may be a clue... Will check El mié, 21-04-2010 a las 11:23 -0400, Tom Lane escribió: > Scott Marlowe writes: > > On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado > > wrote: > >> Maybe but I ran even grant all on schema public for this user to ch

Re: [SQL] Problem with insert related to different schemas

2010-04-21 Thread Gonzalo Aguilar Delgado
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,

Re: [SQL] Problem with insert related to different schemas

2010-04-20 Thread Gonzalo Aguilar Delgado
El mar, 20-04-2010 a las 10:34 -0600, Scott Marlowe escribió: > On Tue, Apr 20, 2010 at 10:32 AM, Gonzalo Aguilar Delgado > wrote: > > > >> Hi Everyone, > >> > >> I've come along with a problem that appeared with latest version of > >> Post

Re: [SQL] Problem with insert related to different schemas

2010-04-20 Thread Gonzalo Aguilar Delgado
> > 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_su

[SQL] Problem with insert related to different schemas

2010-04-20 Thread Gonzalo Aguilar Delgado
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: INSERT INTO "analisys"."response_quality" ("uuid","id_survey_question","id_survey","id_survey_status","id_shop","survey_question_response","id_s