Received: from mailout04.sul.t-online.com (mailout04.sul.t-online.com [194.25.134.18]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3PKKL374160 for ; Wed, 25 Apr 2001 16:20:21 -0400 (EDT) (envelope-from peter_e@gmx.net) Received: from fwd05.sul.t-online.com by mailout04.sul.t-online.com with smtp id 14sVlO-0007kY-05; Wed, 25 Apr 2001 22:19:50 +0200 Received: from peter.localdomain (520083510237-0001@[217.80.146.114]) by fmrl05.sul.t-online.com with esmtp id 14sVlS-0dAdwuC; Wed, 25 Apr 2001 22:19:54 +0200 Date: Wed, 25 Apr 2001 22:31:16 +0200 (CEST) From: Peter Eisentraut To: Kyle cc: Subject: Re: RI permission problem In-Reply-To: <3AE71B32.1040CF9@actarg.com> Message-ID: MIME-Version: 1.0 Content-Type: MULTIPART/MIXED; BOUNDARY="-1463811484-746282116-988230676=:762" X-Sender: 520083510237-0001@t-dialin.net X-Archive-Number: 200104/388 X-Sequence-Number: 2746 This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---1463811484-746282116-988230676=:762 Content-Type: TEXT/PLAIN; charset=US-ASCII Kyle writes: > 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? Okay, we missed a few cases. Try the attached patch. -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter ---1463811484-746282116-988230676=:762 Content-Type: APPLICATION/x-gzip; name="ri-perm.patch.gz" Content-Transfer-Encoding: BASE64 Content-ID: Content-Description: Patch Content-Disposition: attachment; filename="ri-perm.patch.gz" H4sICJgx5zoAA3JpLXBlcm0ucGF0Y2gA7VltT+M4EP4cfoUP6aQWUmI776xA QmzZrYB21YJ0p9MqyiZumyUkxXEL/PsbJzSYXrhj2YOj4iqUxpN4PDOPnxlP 6WUxu9lFPAkETyYTxoudaGPv5z8bw8MRGicp20XGNL9kxozn31kkCmM2Ka5S I1oUPM/F3ajgkfEtjC5YFhtzkaSFEcbCeGCUvtjgDIZskWQTxOGrSPIMkR1q bsTJeIw6EepwOVxxZmtr66FEoxgTA5sGpQg7uwT+XK3U0+l0Gl+1DGojinex v4ttqVD9lAv4FtF9y0GlQKqpBB6C+84GQlo0DbmmxSwNsnmaFn8Me8HpwW9B //z0uPv7CG0j8vWDfO9bnqealhTyrVKQZEIDwYeNbaQNkhjui3DBgnkSK6Lx RZBfZ4zLGXLSkI0ZZ5lIwrSXCTbhibgdZeGsmOZisGCcJzFDe0jwOSunNLrk errvmYpLHgaBU7uEtpCYz1K2Uw0M+QWGcJaC6ikLZ0E+YxlviUnIJ6XHR8fB sHvSPzjtBgfDT/3BVx3185M8umiXviy9gOlDloYC8P3ExFHOL1uV3nZnH661 p9psuZpELA5F2NkXEykq55av5Gkc8Px69R05KI1/1H2CPaLDxb8PAIwsEPlu HQJNM7aqbwhGH5YBgJlgKMqzQvAQsFs+NaSD99iBPeDaecF4L25V3mvaqJYs I1E+qVQkY9QafekF7IZFs9bVLA0zXS4XLMJ0zorqvtxbOsJt9Msekm8PjoOP 3ZPuWbddadEgfJNWdzgcDHW0ea+vjcYhkDVGSYZKoNhtEIVFFMYsAMWt9ma7 jNSKnUt3GuwcJ1lSTFuqJUe9fm/0+YEl/cFZ77B7Z0o95Wm2NKJGqKcTYirb FkYOiCyzRu1xjtX331+fb4Q4NtjpYtV0V4o8onIuzGIEu3oNuJex6ybugbim 3hP42Rgr6rs6MbGtxMrEgLxJyePknM9AP0NiyhC7SQpRFZISuYgVL8tUWLtm qrxvYur5l48HP8VUUPxmmKra0gihafmAl22pEEoGmC5d46pJTA+yjekTxS0L Q9mwCH4vldPyTZ3YWA2BTSiI4BT1KDmjKYsu0Djnr8/NR6ooURkxgip6ePYM bnIGJ4EkEs8so3BsBv8L0LkPyaJp+V+LZaDkxoWl73YuWiR5BSfqoM27mRra vGC30j6YBlFO0/sox2jM80t4sKk342rbsI9th1a4/lMhXaUduN1Bj0LXeRYD YYqx3GFwXCW2Zz+tyr9YTqgsag5fSQvfU2jhEEgWDqX/1/eVWLmymLtEPca5 JqQQ18L/dQq5f7gayNlqINvLLfFjh4LGxNMcJgcY6Tpqj+L60La4/mrnWatf hxrqYfDBw0o7TTwTg8h8N92nT+Ao5FOVAL4lRbb3Dg+4BRNS35toRZtsaYbQ gXzvO2q+931PpxjfF6m/dp6XoYimgbidMYWV84LBwRryWxxczRm/fX1OgtW4 Mr32hmLTBZHSWK8FJ1+ualGo5zpclHRMAXKdUkLfMWnfQlfaZEsjhBQ7Ei+l d6HUkhDazhpXVPDBBB8sT3XLg1xEfWu92PvsikplF04tQpUQWDbkNMsx3yc5 YzYO5+lzG9N/nZ9N5jQDaUOWtWzldEhtTHW4+D/yE69aaF+dj5Ykn+Wbqg8W uGVb7nrx8QWrqeNCKnbU/0BRF7oA6lrvtJouGVIXse2/I+xq5/lihK3N+ROk GzyjTB4AAA== ---1463811484-746282116-988230676=:762--