There are two tables
article_reviewers
Column | Type | Modifiers
-------------+---------+-----------
article_id | integer | not null
reviewer_id | integer | not null
Foreign-key constraints:
"$1" FOREIGN KEY (reviewer_id) REFERENCES reviewers(person_id)
reviewers
Column | Type | Modifiers
-----------+---------+-----------
person_id | integer | not null
status | text |
keywords | text |
Indexes:
"reviewers_pkey" PRIMARY KEY, btree (person_id)
Foreign-key constraints:
"$1" FOREIGN KEY (person_id) REFERENCES persons(id)
When I try to execute sql statement:
INSERT INTO article_reviewers (article_id, reviewer_id) VALUES (876,569);
ERROR: permission denied for relation reviewers
KONTEKST: SQL statement "SELECT 1 FROM ONLY "public"."reviewers" x
WHERE "person_id" = $1 FOR UPDATE OF x"
In person table there is ofcourse person with id=569.
User is super user and I did GRANT ALL on ALL TABLES :
public | article_reviewers | table |
{control=r/control,balcer=arwdRxt/control}
public | articles | table |
{control=r/control,balcer=arwdRxt/control}
public | persons | table |
{control=r/control,balcer=arwdRxt/control}
What is wrong, sorry if this is stupid question.
Jacek
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
