Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9U047P47275 for ; Mon, 29 Oct 2001 19:04:07 -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 405; Mon, 29 Oct 2001 16:54:22 -0700 Message-ID: <3BDDF2FD.9FFF6B6C@waterford.org> Date: Mon, 29 Oct 2001 17:23:25 -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> Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/410 X-Sequence-Number: 5361 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: > I used to have this problem in earlier versions of postgres, after I upgraded they disappeared. > > Regards, > > Aasmund. > On Mon, 29 Oct 2001 16:23:28 -0700, Oleg Lebedev wrote: > > Hi everybody, > > I have a table called 'set' and I am trying to edit or insert an entry > > there. I made sure that I have ALL permissions to modify that table, but > > still I get the same error: > > ERROR: activity: Permission denied. > > > > I don't know where 'activity' part came from, but there is a reference > > to activity table in set table. > > I know this is a very vague descritption of the symptoms, but I don't > > know where to look to find out more info. I'll happily provide any > > further details. > > thanks, > > > > Oleg > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > Aasmund Midttun Godal > > aasmund@godal.com - http://www.godal.com/ > +47 40 45 20 46