Received: from edge.consumercontact.com (dante.consumercontact.com.202.167.209.in-addr.arpa [209.167.202.10] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0VIiQq63075 for ; Wed, 31 Jan 2001 13:44:26 -0500 (EST) (envelope-from rick@consumercontact.com) Received: from consumercontact.com (obiwan.consumercontact.com [192.168.1.54]) by edge.consumercontact.com (8.11.0/8.11.0) with ESMTP id f0VIfiE10489; Wed, 31 Jan 2001 13:41:44 -0500 Message-ID: <3A785D00.5EE8655F@consumercontact.com> Date: Wed, 31 Jan 2001 13:44:16 -0500 From: Rick Delaney X-Mailer: Mozilla 4.7 [en] (Win95; U) X-Accept-Language: en MIME-Version: 1.0 To: "Ross J. Reedstrom" CC: pgsql-sql@postgresql.org Subject: Re: Permissions for foreign keys References: <3A77613D.184BB8D8@consumercontact.com> <3A797C29.62D812E1@mondo-live.com> <20010131095024.A16818@rice.edu> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/488 X-Sequence-Number: 1164 "Ross J. Reedstrom" wrote: > > This is a bug that was fixed in 7.1beta for sure, but also 7.0.3, > I believe. So it's as simple as upgrading. Thanks, I'll upgrade. I couldn't find this listed in any changes files so can you (or anyone) confirm that this is fixed in 7.0.3? And does fixed mean that NO permissions are required on the referencing or referenced tables, or are there still some restrictions? Also, where can I get the 7.1beta? I feel silly, but I can't seem to find it though postgresql.org. > > Rick Delaney wrote: > > > > > I'm using 7.0 and have noticed that I need to grant SELECT and UPDATE > > > permissions on any referentially-related tables. Can/should I get > > > around this? A somewhat contrived example: -- Rick Delaney