Re: [GENERAL] problem with GRANT postgres 8.0.4

2005-11-22 Thread Jacek Balcerski
Richard Huxton napisał(a): Don't forget to cc: the list when replying Jacek Balcerski wrote: Richard Huxton napisał(a): Jacek Balcerski wrote: ERROR: permission denied for relation reviewers KONTEKST: SQL statement "SELECT 1 FROM ONLY "public"."reviewers" x WHERE "person_id" = $1 FOR

Re: [GENERAL] problem with GRANT postgres 8.0.4

2005-11-22 Thread Richard Huxton
Don't forget to cc: the list when replying Jacek Balcerski wrote: Richard Huxton napisał(a): Jacek Balcerski wrote: 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

Re: [GENERAL] problem with GRANT postgres 8.0.4

2005-11-22 Thread Richard Huxton
Jacek Balcerski wrote: 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 : publi

[GENERAL] problem with GRANT postgres 8.0.4

2005-11-22 Thread Jacek Balcerski
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