Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9U0P5P52072 for ; Mon, 29 Oct 2001 19:25:05 -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 143; Mon, 29 Oct 2001 17:15:19 -0700 Message-ID: <3BDDF7E7.3120A19A@waterford.org> Date: Mon, 29 Oct 2001 17:44:23 -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 , Postgres SQL Mailing List 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/411 X-Sequence-Number: 5362 I guess it's not fixed in release 7.1.2, since when I added all permissions on the referenced table, it started working. Do I need to download a new version again (I just did it 2 weeks ago)? thanks, 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