On 12/11/10 7:47 PM, David Underhill wrote:
I have two tables. One has a foreign key referencing a serial
field in the other table. I've given INSERT privilege to a role
other than the owner, but I still can't insert into the table
containing the foreign key unless I grant the /owner/ of the
On Sun, Dec 12, 2010 at 08:11, Tom Lane wrote:
> David Underhill writes:
> > I have two tables. One has a foreign key referencing a serial field in
> the
> > other table. I've given INSERT privilege to a role other than the owner,
> > but I still can't insert into the table containing the fore
David Underhill writes:
> I have two tables. One has a foreign key referencing a serial field in the
> other table. I've given INSERT privilege to a role other than the owner,
> but I still can't insert into the table containing the foreign key unless I
> grant the *owner* of the table UPDATE pr
I have two tables. One has a foreign key referencing a serial field in the
other table. I've given INSERT privilege to a role other than the owner,
but I still can't insert into the table containing the foreign key unless I
grant the *owner* of the table UPDATE privilege on the table containing t