Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1j6y4j-0000ML-Af for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2020 14:54:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j6y4h-0006Ul-Bc for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2020 14:54:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j6y4g-0006Ud-V9 for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2020 14:54:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1j6y4Z-0006pq-AY for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2020 14:54:09 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j6y4Y-0002WC-F5 for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2020 14:54:02 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1j6y4X-0003tC-Vm for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2020 14:54:01 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: proposal: schema variables To: pgsql-hackers@lists.postgresql.org From: remi duval Cc: Pavel Stehule Date: Wed, 26 Feb 2020 14:53:55 +0000 User-Agent: pgcommitfest X-cfsender: remduv In-Reply-To: References: Message-ID: <158272883575.1651.2316685587547965508.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgbm90IHRlc3RlZApJbXBs ZW1lbnRzIGZlYXR1cmU6ICAgICAgIHRlc3RlZCwgcGFzc2VkClNwZWMgY29tcGxpYW50OiAgICAg ICAgICAgdGVzdGVkLCBmYWlsZWQKRG9jdW1lbnRhdGlvbjogICAgICAgICAgICB0ZXN0ZWQsIGZh aWxlZAoKSGVsbG8gUGF2ZWwNCg0KRmlyc3QgdGhhbmtzIGZvciB3b3JraW5nIG9uIHRoaXMgcGF0 Y2ggY2F1c2UgaXQgbWlnaHQgYmUgcmVhbGx5IGhlbHBmdWwgZm9yIHRob3NlIG9mIHVzIHRyeWlu ZyB0byBtaWdyYXRlIFBMIGNvZGUgYmV0d2VlbiBSREJNcy4NCg0KSSB0cmllZCB5b3VyIHBhdGNo IGZvciBtaWdyYXRpbmcgYW4gT3JhY2xlIHBhY2thZ2UgYm9keSB0byBQTC9wZ1NRTCBhZnRlciBh bHNvIHRlc3RpbmcgYSBzb2x1dGlvbiB1c2luZyBzZXRfY29uZmlnIGFuZCBjdXJyZW50X3NldHRp bmcgKHdoaWNoIHdvcmtzIGJ1dCBJJ20gbm90IHJlYWxseSBzYXRpc2ZpZWQgYnkgdGhpcyB3b3Jr YXJvdW5kIHNvbHV0aW9uKS4NCg0KU28gSSBjb21waWxlZCBsYXRlc3QgcG9zdGdyZXMgc291cmNl cyBmcm9tIGdpdGh1YiBvbiBMaW51eCAocmVkaGF0IDcuNykgdXNpbmcgb25seSB5b3VyIHBhdGNo IG51bWJlciAxIChJIGRpZCBub3QgdHJ5IHRoZSBzZWNvbmQgcGFydCBvZiB0aGUgcGF0Y2gpLg0K DQpGb3IgbXkgdXNlLWNhc2UgaXQncyB3b3JraW5nIGdyZWF0LCBwZXJmb3JtYW5jZXMgYXJlIGV4 Y2VsbGVudCAoY29tcGFyZWQgdG8gb3RoZXIgc29sdXRpb24gZm9yIHBvcnRpbmcgInBhY2thZ2Ug dmFyaWFibGVzIikuDQpJIGRpZCBub3QgdGVzdCBhbGwgdGhlIGZlYXR1cmVzIGludm9sdmVkIGJ5 IHRoZSBwYXRjaCAoZXNwZWNpYWxseSBBTFRFUiB2YXJpYWJsZSkuDQoNCkkgaGF2ZSBzb21lIGZl ZWRiYWNrIGhvd2V2ZXIgOg0KDQoxKSBGYWlsdXJlIHdoZW4gdXNpbmcgcGdfZHVtcCAxMyBvbiBh IDEyLjEgZGF0YWJhc2UNCg0KV2hlbiBleHBvcnRpbmcgYSAxMi4xIGRhdGFiYXNlIHVzaW5nIHBn X2R1bXAgZnJvbSB0aGUgbGF0ZXN0IGRldmVsb3BtZW50IHNvdXJjZXMgSSBoYXZlIGFuIGVycm9y IHJlZ2FyZGluZyB2YXJpYWJsZXMgZXhwb3J0IA0KDQpbcGcxMkBUU1QtTElOVVgtUEctMDMgfl0k IC9vcHQvcG9zdGdyZXMxMi9wZzEyL2Jpbi9wZ19kdW1wIC1oIGxvY2FsaG9zdCAtcCA1NDMyIC1V IHBvc3RncmVzIC1mIGR1bXBfcGcxMi5zcWwgZGF0YWJhc2UxDQpwZ19kdW1wOiBlcnJvcjogcXVl cnkgZmFpbGVkOiBFUlJPUjogIHJlbGF0aW9uICJwZ192YXJpYWJsZSIgZG9lcyBub3QgZXhpc3QN CkxJTkUgMTogLi4ub2cucGdfZ2V0X2V4cHIodi52YXJkZWZleHByLDApIGFzIHZhcmRlZmV4cHIg RlJPTSBwZ192YXJpYWJsLi4uDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgXg0KcGdfZHVtcDogZXJyb3I6IHF1ZXJ5IHdhczogU0VM RUNUIHYudGFibGVvaWQsIHYub2lkLCB2LnZhcm5hbWUsIHYudmFyZW94YWN0aW9uLCB2LnZhcm5h bWVzcGFjZSwgDQooU0VMRUNUIHJvbG5hbWUgRlJPTSBwZ19jYXRhbG9nLnBnX3JvbGVzIFdIRVJF IG9pZCA9IHZhcm93bmVyKSBBUyByb2xuYW1lDQosIChTRUxFQ1QgcGdfY2F0YWxvZy5hcnJheV9h Z2coYWNsIE9SREVSIEJZIHJvd19uKSBGUk9NIChTRUxFQ1QgYWNsLCByb3dfbiANCkZST00gcGdf Y2F0YWxvZy51bm5lc3QoY29hbGVzY2Uodi52YXJhY2wscGdfY2F0YWxvZy5hY2xkZWZhdWx0KCdW Jyx2LnZhcm93bmVyKSkpDQogV0lUSCBPUkRJTkFMSVRZIEFTIHBlcm0oYWNsLHJvd19uKSANCiBX SEVSRSBOT1QgRVhJU1RTICggU0VMRUNUIDEgRlJPTSBwZ19jYXRhbG9nLnVubmVzdChjb2FsZXNj ZShwaXAuaW5pdHByaXZzLHBnX2NhdGFsb2cuYWNsZGVmYXVsdCgnVicsdi52YXJvd25lcikpKSBB UyBpbml0KGluaXRfYWNsKSANCiAgICAgICAgICAgICAgICAgICAgV0hFUkUgYWNsID0gaW5pdF9h Y2wpKSBhcyBmb28pIGFzIHZhcmFjbCwgLi4uOg0KDQpJIHRoaW5rIHRoYXQgaXQgc2hvdWxkIGhh dmUgd29ya2VkIGFueXdheSBjYXVzZSB0aGUgZG9jdW1lbnRhdGlvbiBzdGF0ZXMgOg0KaHR0cHM6 Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy9jdXJyZW50L3VwZ3JhZGluZy5odG1sDQoiSXQgaXMg cmVjb21tZW5kZWQgdGhhdCB5b3UgdXNlIHRoZSBwZ19kdW1wIGFuZCBwZ19kdW1wYWxsIHByb2dy YW1zIGZyb20gdGhlIG5ld2VyIHZlcnNpb24gb2YgUG9zdGdyZVNRTCwgdG8gdGFrZSBhZHZhbnRh Z2Ugb2YgZW5oYW5jZW1lbnRzIHRoYXQgbWlnaHQgaGF2ZSBiZWVuIG1hZGUgaW4gdGhlc2UgcHJv Z3JhbXMuIiAodGhhdCdzIHdoYXQgSSBkaWQgaGVyZSkNCg0KSSB0aGluayB0aGVyZSBzaG91bGQg YmUgYSB3YXkgdG8gYXZvaWQgZHVtcGluZyB0aGUgdmFyaWFibGUgaWYgdGhleSBkb24ndCBleGlz dCwgc2hvdWxkJ250IGl0ID8NCg0KMikgRGlzcGxheWluZyB0aGUgdmFyaWFibGVzICsgY29tcGxl dGlvbg0KSSBjcmVhdGVkIDIgdmFyaWFibGVzIHVzaW5nIDoNCkNSRUFURSBWQVJJQUJMRSBteV9w a2cuZ19kYXRfZGViIHZhcmNoYXIoMTEpOw0KQ1JFQVRFIFZBUklBQkxFIG15X3BrZy5nX2RhdF9m aW4gdmFyY2hhcigxMSk7DQpXaGVuIEkgdHJ5IHRvIGRpc3BsYXkgdGhlbSwgSSBjYW4gb25seSBz ZWUgdGhlbSB3aGVuIHByZWZpeGluZyBieSB0aGUgc2NoZW1hIDoNCmJkZDEzPT4gXGRWDQoiRGlk IG5vdCBmaW5kIGFueSBzY2hlbWEgdmFyaWFibGVzLiINCmJkZDEzPT4gXGRWIG15X3BrZy4qDQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIExpc3Qgb2YgdmFy aWFibGVzDQogICBTY2hlbWEgICB8ICAgICAgTmFtZSAgICAgIHwgICAgICAgICBUeXBlICAgICAg ICAgIHwgSXMgbnVsbGFibGUgfCBEZWZhdWx0IHwgT3duZXIgfCBUcmFuc2FjdGlvbmFsIGVuZCBh Y3Rpb24NCi0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0NCiBteV9wa2d8IGdfZGF0X2RlYiAgIHwgY2hhcmFjdGVyIHZhcnlpbmcoMTEpIHwgdCAg ICAgICAgICAgfCAgICAgICAgIHwgbXlvd25lciAgIHwNCiBteV9wa2d8IGdfZGF0X2ZpbiAgICAg fCBjaGFyYWN0ZXIgdmFyeWluZygxMSkgfCB0ICAgICAgICAgICB8ICAgICAgICAgfCBteW93bmVy ICAgfA0KKDMgcm93cykNCg0KYmRkMTM9PiBcZFYgbXlfcGtnDQpEaWQgbm90IGZpbmQgYW55IHNj aGVtYSB2YXJpYWJsZSBuYW1lZCAibXlfcGNrIi4NCk5CIDogVXNpbmcgdGhpcyB0ZW1wbGF0ZSwg ZnVuY3Rpb25zIGFyZSByZXR1cm5lZCwgbWF5YmUgdmFyaWFibGVzIHNob3VsZCBhbHNvIGJlIGxp c3RlZCA/IChoZXJlIGJ5IHF1ZXJ5aW5nIG9uICJteV9wa2clIikNCmN0c19nZXQxMz0+IFxkViBt eV9wIFtUQUJdDQo9PiBjb21wbGV0aW9uIHVzaW5nIFtUQUJdIGtleSBpcyBub3Qgd29ya2luZw0K DQpJcyB0aGlzIG5vcm1hbCB0aGF0IEkgY2Fubm90IHNlZSBhbGwgdGhlIHZhcmlhYmxlcyB3aGVu IG5vdCBzcGVjaWZ5aW5nIGFueSBzY2hlbWEgPw0KQWxzbyB0aGUgY29tcGxldGlvbiB3b3JrcyBm b3IgZnVuY3Rpb25zLCBidXQgbm90IGZvciB2YXJpYWJsZS4NClRoYXQncyBqdXN0IHNvbWUgYm9u dXMgYnV0IGl0IG1pZ2h0IGJlIGdvb2QgdG8gaGF2ZSBpdC4NCg0KSSB0aGluayB0aGUgd2F5IHZh cmlhYmxlcyBhcmUgbGlzdGVkIHVzaW5nIFxkViBzaG91bGQgbWF0Y2ggd2l0aCBcZGYgZm9yIHF1 ZXJ5aW5nIGZ1bmN0aW9ucw0KDQozKSBBbnkgd2F5IHRvIGRlZmluZSBDT05TVEFOVHMgPw0KV2Ug YWxyZWFkeSB0YWxrZWQgYSBiaXQgYWJvdXQgdGhpcyBzdWJqZWN0IGFuZCBhbHNvIEdpbGxlcyBE YXJvbGQgaW50cm9kdWNlcyBpdCBpbiB0aGlzIG1haWxpbmctbGlzdCB0b3BpYyBidXQgSSdkIGxp a2UgdG8gaW5zaXN0IG9uIGl0Lg0KSSB0aGluayBpdCB3b3VsZCBiZSBuaWNlIHRvIGhhdmUgYSB3 YXkgdG8gc2F5IHRoYXQgYSB2YXJpYWJsZSBzaG91bGQgbm90IGJlIGNoYW5nZWQgb25jZSBkZWZp bmVkLg0KTWF5YmUgaXQncyBoYXJkIHRvIGltcGxlbWVudCBhbmQgY2FuIGJlIGltcGxlbWVudGVk IGxhdGVyLCBidXQgSSBqdXN0IHdhbnQgdG8ga25vdyBpZiB0aGlzIGNvbmNlcm4gaXMgb3Blbi4N Cg0KDQpPdGhlcndpc2UgdGhlIGRvY3VtZW50YXRpb24gbG9va3MgZ29vZCB0byBtZS4NCg0KUmVn YXJkcw0KDQpSw6ltaQ==