Received: from ns.krot.org (ns.krot.org [193.212.103.165]) by postgresql.org (8.11.3/8.11.4) with SMTP id f9U0AvP48884 for ; Mon, 29 Oct 2001 19:10:57 -0500 (EST) (envelope-from postgresql@envisity.com) Received: (qmail 18703 invoked by uid 67); 30 Oct 2001 00:09:17 -0000 Message-ID: <20011030000917.28224.qmail@ns.krot.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline MIME-Version: 1.0 From: "Aasmund Midttun Godal" To: olebedev@waterford.org Cc: pgsql-sql@postgresql.org Subject: Re: table permissions Date: Tue, 30 Oct 2001 00:09:17 GMT X-Mailer: Googley-Moogley In-Reply-To: <3BDDF2FD.9FFF6B6C@waterford.org> from Oleg Lebedev on Mon, 29 Oct 2001 17:23:25 -0700 References: <3BDDE4F0.D5F5758E@waterford.org> <20011029235725.552.qmail@ns.krot.org> <3BDDF2FD.9FFF6B6C@waterford.org> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f9U0LkM51289 X-Archive-Number: 200110/409 X-Sequence-Number: 5360 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