Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g8WgD-0004H7-6e for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Oct 2018 20:26:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g8WgB-0007r2-1Z for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Oct 2018 20:26:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g8WgA-0007qu-OG for pgsql-hackers@lists.postgresql.org; Fri, 05 Oct 2018 20:26:30 +0000 Received: from smtp-fw-9101.amazon.com ([207.171.184.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g8Wg7-0006Hw-8H for pgsql-hackers@postgresql.org; Fri, 05 Oct 2018 20:26:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1538771187; x=1570307187; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=e2yicDLVnttE5OWrxi15i/WXItuUmcMpNIiT6UL4vuA=; b=tKYG1ifPDVcyHghbibuWAte9XbxNt21KfjtmUZVvcBR10XrY9eVjeBZU x/NMMXOWQntoeH0LSn8sbEChxyje4e+bkhRC6KT1WiVABkntiYXHkqn/w Ep/YLbtj0HPDXWjiLrewyNisABTZq77P+tOG6UmGkFJbK/NV7l4Urg6EP Y=; X-IronPort-AV: E=Sophos;i="5.54,345,1534809600"; d="scan'208";a="762323918" Received: from sea3-co-svc-lb6-vlan3.sea.amazon.com (HELO email-inbound-relay-2c-397e131e.us-west-2.amazon.com) ([10.47.22.38]) by smtp-border-fw-out-9101.sea19.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 05 Oct 2018 20:26:23 +0000 Received: from EX13MTAUWC001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-2c-397e131e.us-west-2.amazon.com (8.14.7/8.14.7) with ESMTP id w95KQMar130196 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL) for ; Fri, 5 Oct 2018 20:26:23 GMT Received: from EX13D22UWC004.ant.amazon.com (10.43.162.198) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Fri, 5 Oct 2018 20:26:22 +0000 Received: from EX13D22UWC002.ant.amazon.com (10.43.162.29) by EX13D22UWC004.ant.amazon.com (10.43.162.198) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Fri, 5 Oct 2018 20:26:22 +0000 Received: from EX13D22UWC002.ant.amazon.com ([10.43.162.29]) by EX13D22UWC002.ant.amazon.com ([10.43.162.29]) with mapi id 15.00.1367.000; Fri, 5 Oct 2018 20:26:22 +0000 From: "Nasby, Jim" To: =?utf-8?B?0JDQu9C10LrRgdCw0L3QtNGAINCQ0L3QuNC60LjQvQ==?= CC: "borey2005@gmail.com" , "pgsql-admin@postgresql.org" Subject: Re: Create roles trigger Thread-Topic: Create roles trigger Thread-Index: AQHUVmmpHqlYnCaf9EaTLbrGziHxCqURJoeA Date: Fri, 5 Oct 2018 20:26:22 +0000 Message-ID: <666F78F5-0158-4E6C-AD23-9FD6E94A7794@amazon.com> References: <1538039268.772929533@f494.i.mail.ru> In-Reply-To: <1538039268.772929533@f494.i.mail.ru> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.161.25] Content-Type: text/plain; charset="utf-8" Content-ID: <3184BB753274B8429244D0300798C0D1@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 Precedence: Bulk List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk UGxlYXNlIGRvIG5vdCBwb3N0IHRvIG11bHRpcGxlIGxpc3RzLiBNb3ZpbmcgLWhhY2tlcnMgdG8g QkNDLg0KDQo+IE9uIFNlcCAyNywgMjAxOCwgYXQgNDowNyBBTSwg0JDQu9C10LrRgdCw0L3QtNGA INCQ0L3QuNC60LjQvSA8YW5pa2luMjRAbGlzdC5ydT4gd3JvdGU6DQo+IA0KPiBIZXksIGZvbGtz IQ0KPiANCj4gSSd2ZSBnb3QgYSBxdWVzdGlvbiBhYm91dCBldmVudHMgb24gcm9sZXMgY3JlYXRp b24uDQo+IA0KPiBJIG5lZWQgdG8gZXhlY3V0ZSBzb21lIGN1c3RvbSBsb2dpYyBvbiByb2xlIGNy ZWF0aW9uLg0KPiANCj4gQWxsIGluZm9ybWF0aW9uIGFib3V0IHJvbGVzIGxvY2F0ZWQgaW4gYHBn X2F1dGhpZGAgdGFibGUuIA0KPiBUaGUgZmlyc3QgdGhpbmcgdGhhdCBjb21lcyB0byBtaW5kIGlz IHRvIGNyZWF0ZSB0cmlnZ2VyIG9uIGBwZ19hdXRoaWRgIHRhYmxlLCBidXQgdGhpcyBpcyBub3Qg cG9zc2libGUsIGJlY2F1c2UgdGhpcyBpcyBhIHN5c3RlbSB0YWJsZS4NCj4gTmV4dCB0aGluZywg aXMgdG8gY3JlYXRlIGEgdmlldyAoc2VsZWN0ICogZnJvbSBwZ19hdXRoaWQpIGFuZCBjcmVhdGUg dHJpZ2dlciBvbiB2aWV3LCBidXQgdGhpcyBkaWRuJ3Qgd29yayBvdXQgdG9vLg0KDQpOb3Qgc3Vy ZSB3aGF0IHlvdSB3ZXJlIGF0dGVtcHRpbmcgd2l0aCB0aGUgdmlldywgYnV0IGNhdGFsb2cgdGFi bGVzIGFyZSBhIHNwZWNpYWwgY2FzZSwgc28gdGhvc2Uga2luZCBvZiB0cmlja3MgYXJlIHN0cmFp Z2h0LW91dCBub3QgZ29pbmcgdG8gd29yay4NCg0KPiBPbmUgbW9yZSB0aGluZyBpcyB0byBjcmVh dGUgZXZlbnQgdHJpZ2dlciAoQ1JFQVRFIEVWRU5UIFRSSUdHRVIgdHJpZ2dlciBPTiBkZGxfY29t bWFuZF9zdGFydCBXSEVOIFRBRyBJTiAoJ0NSRUFURSBST0xFJykpLCBidXQgaXQncyBhbHNvIG5v dCBwb3NzaWJsZSwgZXZlbnQgdHJpZ2dlcnMgYXJlIG5vdCBzdXBwb3J0ZWQgZm9yICdDUkVBVEUg Uk9MRScuDQo+IA0KPiBJcyB0aGVyZSBpcyBhbnkgcG9zc2liaWxpdHkgdG8gZG8gdGhhdCA/IE1h eSBiZSwgY3JlYXRlIGN1c3RvbSBleHRlbnNpb24gb3Igc29tZXRoaW5nIGVsc2UuDQoNCkkgd291 bGQgYWxzbyBsb3ZlIHRvIGhhdmUgZXZlbnQgdHJpZ2dlcnMgZm9yIGdsb2JhbCBvYmplY3RzLCBi dXQgdW5mb3J0dW5hdGVseSB0aGF04oCZcyBhIHZlcnkgdG91Z2ggbnV0IHRvIGNyYWNrLCBiZWNh dXNlIGNoYW5nZXMgdG8gZ2xvYmFsIG9iamVjdHMgY291bGQgaGFwcGVuIGZyb20gYW55IGRhdGFi YXNlIGluIHRoZSBlbnRpcmUgc3lzdGVtICh3aGljaCBjb3VsZCBlYXNpbHkgbnVtYmVyIGluIHRo ZSB0aG91c2FuZHMpLiBGb3IgZ2xvYmFsIGV2ZW50IHRyaWdnZXJzIHRvIHdvcmssIHRoZXJlIHdv dWxkIG5lZWQgdG8gYmUgYSBnbG9iYWwgbGlzdCBvZiBldmVudCB0cmlnZ2VycywgaW5jbHVkaW5n IHdoaWNoIGRhdGFiYXNlIHRoZSBldmVudCB0cmlnZ2VyIHdhcyBpbi4gVGhlcmUgd291bGQgYWxz byBuZWVkIHRvIGJlIGEgd2F5IHRvIGZpcmUgdGhvc2UgdHJpZ2dlcnMgKGN1cnJlbnRseSwgYSBi YWNrZW5kIGNhbiBub3QgcnVuIGFueXRoaW5nIGluIGEgc2VwYXJhdGUgZGF0YWJhc2UpLiBZb3Xi gJlkIGFsc28gZmFjZSB0aGUgY2hhbGxlbmdlIG9mIHdoZXRoZXIgdGhlIHVzZXIgcnVubmluZyB0 aGUgZXZlbnQgdHJpZ2dlciBoYWQgcGVybWlzc2lvbiB0byBjb25uZWN0IHRvIGFsbCBvZiB0aG9z ZSBkYXRhYmFzZXMuDQoNCkluIHNob3J0LCB0aGVyZeKAmXMgYSBsb3Qgb2Ygd29yayBsZWZ0IHRv IGJlIGRvbmUgaW4gb3JkZXIgdG8gc3VwcG9ydCB3aGF0IHlvdeKAmXJlIGxvb2tpbmcgZm9yLg0K DQpCVFcsIGlmIHlvdSBvbmx5IG5lZWQgYXVkaXRpbmcgdGhlbiB5b3Ugc2hvdWxkIHRha2UgYSBs b29rIGF0IHBnX2F1ZGl0Lg==