I have 3 users in the database: postgres, oleg, and boss. boss is the superuser and has permissions to modify both
originaland referenced table.
However, when I am logged in as boss, it won't let me modify the original ('set') table unless user oleg (!!!!) has
updatepermissions on the
referenced table ('activity'). Now I understand that I didn't have this problem before, because I just recently created
thissuperuser boss.
Another thing, I just noticed is that the tables I mentioned do not have permissions defined for user postgres. All the
othertables in my database
do have those permissions set. Can this be the cause of the problem?
thanks,
Oleg
Aasmund Midttun Godal wrote:
> The problem is that updating/inserting/deleting a row which references another table requires all permissions on that
table.This has been fixed.
>
> Regards,
>
> Aasmund.
>
> On Mon, 29 Oct 2001 17:23:25 -0700, Oleg Lebedev <olebedev@waterford.org> wrote:
> > I am using v7.1.2
> > I guess, this might be a table locking problem, but I don't have any transactions currently running.
> >
> > A couple of days ago I did a restore of 'set' table from a dump file, and it didn't go too well - I
> > had a couple of problems. I don't know if it's relevant, but smth's telling me that it is.
> >
> > Oleg
> >
> > Aasmund Midttun Godal wrote:
> >
> >
>
> Aasmund Midttun Godal
>
> aasmund@godal.com - http://www.godal.com/
> +47 40 45 20 46