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 gagui...@aguilardelgado.com 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

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

2010-04-21 Thread Tom Lane
Scott Marlowe scott.marl...@gmail.com writes: On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado gagui...@aguilardelgado.com 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

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 scott.marl...@gmail.com writes: On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado gagui...@aguilardelgado.com wrote: Maybe but I ran even grant all on schema public for

[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

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 gagui...@aguilardelgado.com 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...

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

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

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 gagui...@aguilardelgado.com 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