Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9U0fNP55295 for ; Mon, 29 Oct 2001 19:41:23 -0500 (EST) (envelope-from olebedev@waterford.org) Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 385; Mon, 29 Oct 2001 17:31:39 -0700 Message-ID: <3BDDFBBA.99D3987E@waterford.org> Date: Mon, 29 Oct 2001 18:00:42 -0700 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Aasmund Midttun Godal CC: pgsql-sql@postgresql.org Subject: Re: table permissions References: <3BDDE4F0.D5F5758E@waterford.org> <20011029235725.552.qmail@ns.krot.org> <3BDDF2FD.9FFF6B6C@waterford.org> <20011030000917.28224.qmail@ns.krot.org> Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/412 X-Sequence-Number: 5363 I have 3 users in the database: postgres, oleg, and boss. boss is the superuser and has permissions to modify both original and referenced table. However, when I am logged in as boss, it won't let me modify the original ('set') table unless user oleg (!!!!) has update permissions on the referenced table ('activity'). Now I understand that I didn't have this problem before, because I just recently created this superuser boss. Another thing, I just noticed is that the tables I mentioned do not have permissions defined for user postgres. All the other tables 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 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