Foreign keys breaks tables permissions

Raul Chirea <raul@brahms.ro>

From: Raul Chirea <raul@brahms.ro>
To: pgsql-bugs@postgresql.org, pgsql-sql@postgresql.org
Date: 2000-04-12T02:49:44Z
Lists: pgsql-bugs, pgsql-hackers
Hi,

If one does:

 create table master (
  id integer not null,
  primary key (id)
 );

 create table detail (
  id integer not null,
  master_id integer not null,
  primary key (id),
  foreign key (master_id) references master (id)
 );

 insert into master (id) values (1);

 grant select on master to a_user;
 grant select, insert, update, delete on detail to a_user;

then if login as "a_user" and does:

  insert into detail (id, master_id) values (1, 10);

this will result in: "ERROR:   master: Permission denied".

This seems a bug to me ? Isn't it ?

Regards,
Raul Chirea.