Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxD9k-0000Hj-6j for pgsql-www@arkaria.postgresql.org; Tue, 14 Dec 2021 19:08:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mxD9j-000645-0c for pgsql-www@arkaria.postgresql.org; Tue, 14 Dec 2021 19:08:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxD9i-00062H-Pm for pgsql-www@lists.postgresql.org; Tue, 14 Dec 2021 19:08:06 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxD9g-0001JD-11 for pgsql-www@postgresql.org; Tue, 14 Dec 2021 19:08:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=mOCDTQ7wKJqpac3uqElRsEBPjwbw4PTi1FVNqt+eqDM=; b=yexduEsfyFadHo3uBGLungz3PL /nd+pNvOsSYGW+wxE9yXTTl+QhBGqLsT6SSHunQplWkikfZEop1sGieWvFftrT8JTN0ApK1MZLjFg OX4qZN4ZpX/gyNQwV2GQEvqhdJZBnr7H37769nlXjwldeXBbJYsMaUWaexEfPcTdG+krdO40rSESs v3K7fH1CMvwtNFjNzG6TpvD6ymH8c5VH73u30p2cdCqaHXcpdBWr1EHRHpHZmk5XqabhcabVyr+iy 9goiJS3qjGowSbOmenRcnllFZeFZcZqB6BJYUULq3zWklRODEplmBtfIUZyNZ1aNHxr/D28j7Iej4 92c2xYkQ==; Received: from [166.205.180.116] (helo=[172.20.10.2]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mxD9a-0006jb-Cf; Tue, 14 Dec 2021 19:08:00 +0000 Message-ID: <70c4681a-b834-b694-ce2e-956a40fa7772@postgresql.org> Date: Tue, 14 Dec 2021 14:07:54 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.3.2 Subject: Re: bad style for SECURITY DEFINER Content-Language: en-US To: Daniel Gustafsson Cc: Justin Pryzby , Peter Eisentraut , pgsql-www@postgresql.org References: <20211213001707.GR17618@telsasoft.com> <236bee0a-b624-b35d-516a-da7e4c3d2358@enterprisedb.com> <212DF319-94A5-4827-9F78-74D29C888717@yesql.se> <20211213140110.GU17618@telsasoft.com> <3686660c-02a4-7b06-98e9-34a30bb7be08@postgresql.org> <49328270-4191-4915-ABD4-16AFE6905AE3@yesql.se> <3a1e4ece-d593-a8aa-3b23-280a8fd2eeb4@postgresql.org> <3BBA1EE5-BDC7-44D5-9062-2E1CFDEB1DFC@yesql.se> From: "Jonathan S. Katz" In-Reply-To: <3BBA1EE5-BDC7-44D5-9062-2E1CFDEB1DFC@yesql.se> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------ai9eaylc1GgJY0TKz4xifmh3" X-Host-Lookup-Failed: Reverse DNS lookup failed for 166.205.180.116 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------ai9eaylc1GgJY0TKz4xifmh3 Content-Type: multipart/mixed; boundary="------------LtK7k065137ku20Z5MQ0umF3"; protected-headers="v1" From: "Jonathan S. Katz" To: Daniel Gustafsson Cc: Justin Pryzby , Peter Eisentraut , pgsql-www@postgresql.org Message-ID: <70c4681a-b834-b694-ce2e-956a40fa7772@postgresql.org> Subject: Re: bad style for SECURITY DEFINER References: <20211213001707.GR17618@telsasoft.com> <236bee0a-b624-b35d-516a-da7e4c3d2358@enterprisedb.com> <212DF319-94A5-4827-9F78-74D29C888717@yesql.se> <20211213140110.GU17618@telsasoft.com> <3686660c-02a4-7b06-98e9-34a30bb7be08@postgresql.org> <49328270-4191-4915-ABD4-16AFE6905AE3@yesql.se> <3a1e4ece-d593-a8aa-3b23-280a8fd2eeb4@postgresql.org> <3BBA1EE5-BDC7-44D5-9062-2E1CFDEB1DFC@yesql.se> In-Reply-To: <3BBA1EE5-BDC7-44D5-9062-2E1CFDEB1DFC@yesql.se> --------------LtK7k065137ku20Z5MQ0umF3 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gMTIvMTQvMjEgNDoyNyBBTSwgRGFuaWVsIEd1c3RhZnNzb24gd3JvdGU6DQo+PiBPbiAx MyBEZWMgMjAyMSwgYXQgMjM6MTQsIEpvbmF0aGFuIFMuIEthdHogPGprYXR6QHBvc3RncmVz cWwub3JnPiB3cm90ZToNCj4+DQo+PiBPbiAxMi8xMy8yMSA0OjQzIFBNLCBEYW5pZWwgR3Vz dGFmc3NvbiB3cm90ZToNCj4+DQo+Pj4gVGhlIG1hcmdpbiBpc3N1ZSBsb29rcyByaWdodCBi dXQgSSB0aGluayB0aGUgZm9udC1zaXplIHNob3VsZCBtYXRjaCB0aGUgcmVzdCBvZg0KPj4+ IHRoZSB0aXRsZS4NCj4+DQo+PiBQbGVhc2Ugc2VlIGF0dGFjaGVkIGFuZCBiZWxvdyBmb3Ig cmV2aXNpb24uDQo+IA0KPiBJIHRoaW5rIHRoaXMgbG9va3MgbXVjaCBiZXR0ZXIsIGFuZCBp dCBtYXRjaGVzIGhvdyB0aGUgUERGJ3MgYXJlIHJlbmRlcmVkLg0KPiANCj4+IEknbSBub3Qg dGhyaWxsZWQgYWJvdXQgdGhlICFpbXBvcnRhbnQgb3ZlcnJpZGUgdGhhdCdzIG5lZWRlZCB0 byBkZWFsIHdpdGggYW5vdGhlciAhaW1wb3J0YW50LCBidXQgSSBkb24ndCB3YW50IHRvIHRy eSB0byB1bndlYXZlIHRoZSAhaW1wb3J0YW50IG5lc3QgZ2l2ZW4gdGhlIGxhY2sgb2Ygb3Zl cmFsbCBjYXNlcyBvZiBhIGNvZGUgYmxvY2sgbmVzdGVkIHdpdGhpbiBoMiB0aXRsZSB0YWdz Lg0KPiANCj4gQWdyZWVkIG9uIGJvdGggY291bnRzLg0KDQpUaGFua3MgZm9yIHRoZSByZXZp ZXcsIGFuZCB0aGFua3MgdG8gSnVzdGluIGZvciB0aGUgcmVwb3J0LiBJJ3ZlIHB1c2hlZCAN CnRoaXMgdXAuIEl0IHNob3VsZCBiZSBhdmFpbGFibGUgb24gdGhlIG5leHQgY2FjaGUgcmVm cmVzaC4NCg0KVGhhbmtzLA0KDQpKb25hdGhhbg0K --------------LtK7k065137ku20Z5MQ0umF3-- --------------ai9eaylc1GgJY0TKz4xifmh3 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmG464oFAwAAAAAACgkQ8QSccp8cZSfl 2BAAth5OXqgOAlNLn28mzS/OoDHTZm3jD80RrBENk5qU9+9KVCVFfKtcn8DJctTfHU+/wIG19BM5 3LOXwgyjeosUgFwuOEkbAwbxvc83OKs6gQLZf1oUsREu8kiTVw2dKfIQzbf9NvVfValxst1PD/9O vZfz0opXmzkjBFiOM/NwH9ZpXedc+HH+KKQeF2BW/vNTTCqdGby1tf/N6e+sXe8/CG4vG+Dg1wUq DVmjncZDgNS5+hvFLStUa0dR1Wd3lY8/bgpfJBZ5WJ1en8tjY8Hfh+l2vBLN3A4jY2KfFvbdgCv/ 6sqMfAvIotFNDbJwRP+C350hM042WRpPQD7saeUs1dGxr8sxX8K2oCPXUtFNnHH98NRusLdrHgla Qp3TLpuUfNfPf3bkv0IrBS6YO4jd1SCEK5+av5GAY+dJKSwbQuPJ7KLth3w96CGq60pLZRga1kQ7 ZB3np2OutuKPiDhkR2AtFYXCijVeYoG2EqMvGKNKOop39bBtwD6j/MjKlCObO5iKOeJRgPUzodRG Ebx4du9sqUQiaHJivvuc4cetrr4E0YQX03AZR0Ahd128Z6dT4MuKShldbveYA5IZIKGvzx/cuRud RjBoeb4gDi6lp0+Gih9q+HJamLrIzFXphsSrCNkpuu7VQjYmzV+/S0Cop4Hn6GfhfpIxKV1/Fv+s sDA= =6+j/ -----END PGP SIGNATURE----- --------------ai9eaylc1GgJY0TKz4xifmh3--