Received: from actarg.com (host25.actarg.com [209.180.91.25] (may be forged)) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3PIj7341419 for ; Wed, 25 Apr 2001 14:45:07 -0400 (EDT) (envelope-from kyle@actarg.com) Received: from chi.actarg.com (IDENT:root@chi.actarg.com [192.168.2.16]) by actarg.com (8.9.3/8.9.3) with ESMTP id MAA05555; Wed, 25 Apr 2001 12:45:06 -0600 Received: from actarg.com (IDENT:kyle@localhost [127.0.0.1]) by chi.actarg.com (8.9.3/8.9.3) with ESMTP id MAA06618; Wed, 25 Apr 2001 12:45:06 -0600 Message-ID: <3AE71B32.1040CF9@actarg.com> Date: Wed, 25 Apr 2001 12:45:06 -0600 From: Kyle Organization: Action Target Inc. X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12-20 i686) X-Accept-Language: en MIME-Version: 1.0 To: Peter Eisentraut CC: pgsql-sql@postgresql.org Subject: Re: RI permission problem References: Content-Type: multipart/mixed; boundary="------------E431319F52E8E2418C3ADD15" X-Archive-Number: 200104/383 X-Sequence-Number: 2741 This is a multi-part message in MIME format. --------------E431319F52E8E2418C3ADD15 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Peter Eisentraut wrote: > Kyle writes: > > > Is there a way to get this to work without granting update to table b? > > Update to 7.1.] I'm on 7.1. Should an RI trigger under 7.1 run as the DBA or as the current user? > > > > Tom, I understand someone was working on setuid functions. Is that a > > long way off? It would be nifty if triggers could execute with the > > privileges of the user that created them rather than the user who is > > executing them. This would help greatly in closing some security holes > > like this we are dealing with. --------------E431319F52E8E2418C3ADD15 Content-Type: text/x-vcard; charset=us-ascii; name="kyle.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Kyle Content-Disposition: attachment; filename="kyle.vcf" begin:vcard n:Bateman;Kyle x-mozilla-html:FALSE org:Action Target Inc. adr:;;;;;; version:2.1 email;internet:kyle@actarg.com title:President x-mozilla-cpt:;0 fn:Kyle Bateman end:vcard --------------E431319F52E8E2418C3ADD15--