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 check > >> if this was the pro

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

2010-04-21 Thread Tom Lane
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 check >> if this was the problem. > That doesn't do what you think it does. You need to grant on the actual > object. The error he was

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

2010-04-21 Thread Scott Marlowe
On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado wrote: > 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.  

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 > >> Postgresql 8.4.2. > >> > >> I'm trying to insert a row in the

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

2010-04-20 Thread Tom Lane
Gonzalo Aguilar Delgado 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.

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

2010-04-20 Thread Scott Marlowe
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 >> Postgresql 8.4.2. >> >> I'm trying to insert a row in the analysis schema: >> > > This is an insert query: > > Yes it is... > > >> INSERT

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

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

2010-04-20 Thread Scott Marlowe
On Wed, Apr 14, 2010 at 2:23 AM, Gonzalo Aguilar Delgado wrote: > 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: > INSERT INTO > "analisys"."response_qualit

[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