Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0VFokq48057 for ; Wed, 31 Jan 2001 10:50:47 -0500 (EST) (envelope-from reedstrm@rice.edu) Received: by rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-sql@postgresql.org; Wed, 31 Jan 2001 09:50:24 -0600 (CST) Date: Wed, 31 Jan 2001 09:50:24 -0600 From: "Ross J. Reedstrom" To: Najm Hashmi Cc: Rick Delaney , pgsql-sql@postgresql.org Subject: Re: Permissions for foreign keys Message-ID: <20010131095024.A16818@rice.edu> Mail-Followup-To: Najm Hashmi , Rick Delaney , pgsql-sql@postgresql.org References: <3A77613D.184BB8D8@consumercontact.com> <3A797C29.62D812E1@mondo-live.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <3A797C29.62D812E1@mondo-live.com>; from najm@mondo-live.com on Thu, Feb 01, 2001 at 10:09:29AM -0500 X-Archive-Number: 200101/480 X-Sequence-Number: 1156 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. Ross On Thu, Feb 01, 2001 at 10:09:29AM -0500, Najm Hashmi wrote: > Hey Rick, > I am sure there are more elegant solutions but I have a simple > one. Write a trigger that will grant the permissions before insert or > update and and revoke all privileges after the insert or update. > -Najm > > > 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: > > -- Ross J. Reedstrom, Ph.D., NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005