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 1fkxDa-0004dW-52 for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Aug 2018 19:55:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fkxDX-0000H6-6a for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Aug 2018 19:55: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 1fkxDW-0000Gy-Ns for pgsql-hackers@lists.postgresql.org; Wed, 01 Aug 2018 19:55:31 +0000 Received: from mail-wr1-x443.google.com ([2a00:1450:4864:20::443]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fkxDN-000701-HA for pgsql-hackers@postgresql.org; Wed, 01 Aug 2018 19:55:29 +0000 Received: by mail-wr1-x443.google.com with SMTP id h10-v6so21272731wre.6 for ; Wed, 01 Aug 2018 12:55:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=bvKOBAqY95G4/F8/yJmsIl9V+LmNNbC4+1PhL1LpZuQ=; b=jSg0/XJfuvPAMDSBv8YsgbjVrkRs03tnCGz1t7uL5WL/CSCZ1SR0TgfSvyX8KiTBsb k6ZTT999H64KO+8d9FcsVQSKqF/7AssKIyBXfboEPoex4HpTGFLMuLAmYANQJ2FEtJ+X +gmeRiiSoNwAT1pVXM+s1HbVfFcAMzFjyJ5NROrbgBiU6l0+fjQKXOWOPh8VYJc5408w LM3HK9Luv3cb83EialBQOly/ZF7ngjyj2xSHsS08c4eCAEkfIYGvWdGQlNaTBD4MiE9m keVtIt2cJQN2mLYg3k1Df1Y7U8+nTImzFU6/nwSOfUsgXguP3Stfh40G33v2rvefJ+PZ pwkg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to :content-language:content-transfer-encoding; bh=bvKOBAqY95G4/F8/yJmsIl9V+LmNNbC4+1PhL1LpZuQ=; b=PMOP0SkYhO6q0Uo3wNi35CK7VOJQnsbV8E70BAkkm94R9cUnx6nI+tl8qg2N+ihhvP 6igQ+IEBJS79NppMreSUSttnYvzubDyZD5JNQrmrjpV4JRv/JLOhpdIrX48xa0ZoP1yQ ttv8HF1PIk5W43P1uu9Lz8bqtKDk4zbDbrC4s3VgM6lSIrL3sxweBfqdQtIjPttxFhrJ eL3oNIxYnliOYjVvoVC99p4OPBQhhhc8YD+q2SWOTBbR5ZHxMtHUumbN2TPt1Rdoo1tC 20SaAh1+ir4j9ldGWwMw8pL6vSV/DzL/mTPypzYOUs/UyPtpAYzTvFqDjZAIyp9zFC1W SGCg== X-Gm-Message-State: AOUpUlE4zDoO6YKFmkYtHNehkuOvtz6SuM5cG2ZmR4P3OrJgohWj78hv 0WS3ZvDzb31Qw911kDtjjDpf53zUhySkPZUc2YPZm1AXBUpRpxFdRm/umb6iNmSycMdhuVQOWaM 2Ljl6uwELN3OxJU+auVeox4yU9qWKh6t1d9sqxUS1EkkugLy8u1wgIXNqECbiobEvw7hOSwZP3H mPcdY52XXDU7s= X-Google-Smtp-Source: AAOMgpd4KI6RSrniMgodlmwgsk/Zv1sLMr/FaQL6Zwcf1KbvpERVuHBRcaeuBwd6KoKL8mEf4JRZAQ== X-Received: by 2002:adf:bbd4:: with SMTP id z20-v6mr25529348wrg.183.1533153320456; Wed, 01 Aug 2018 12:55:20 -0700 (PDT) Received: from [192.168.0.99] (150.123.broadband11.iol.cz. [90.178.123.150]) by smtp.gmail.com with ESMTPSA id 188-v6sm345984wmv.11.2018.08.01.12.55.19 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 01 Aug 2018 12:55:19 -0700 (PDT) Subject: Re: [HACKERS] logical decoding of two-phase transactions To: Nikhil Sontakke , Andres Freund Cc: Robert Haas , Tomas Vondra , David Steele , Andrew Dunstan , Simon Riggs , Craig Ringer , Peter Eisentraut , Sokolov Yura , Stas Kelvich , Dmitry Dolgov <9erthalion6@gmail.com>, Tom Lane , Masahiko Sawada , PostgreSQL Hackers References: From: Petr Jelinek Openpgp: preference=signencrypt Autocrypt: addr=petr.jelinek@2ndquadrant.com; prefer-encrypt=mutual; keydata= xsFNBFawwSABEAC45Vua8rSggpM2kkMMmoOHz51a+fi3OXFfnrStVh80pM2/J9nSzjrIKQKf H5PtRnoYzSKnoUDoLOkLwDYitK3HzUUWXma+AWAqef2Y0GSZ7A3jJkD+JHOfkpS1CIpkEB/e WjA8Wqegwzc/OEE5111/l0Q1e6jxgZI86h8MMnm35Of1Y6Lz4kqWCyxHhaTJKTCkq66ICQ2C VJkbvuUoEE+Hr/I38dPHTAqIlCnycVnJPLHBQ/UYGHR/USF8qI/qJJx6tJcNAEqz69QZ/VlY 31UyJHdYe5NtBVz+rYZCOVWfpe3crbHuq9FjAPT+xcZefdxridmMKuW8eBmmXI9iZ3EG+X8J IsdLWL8QoqW0lnO1otYz1QDjdOvbEpq+u5/TAU8pgtaYH2J+6/GaQ6hMLyLBkaIAtnqlLCzq pxXcxMsFT14P5/rZA7EbBI8RS1ZIWJBlS2oO+dtVuENLJUC0SpptaRyn/uyOIopt7hSmBekL SzFnet7P9qofFJY+fQEz84v0G1gvwonHGHiCGgLpbMdPtnfPzda1aiTURvvOD7w/RmX1/ogk TqSGO4ejVNO/28QYouxmxzy8jbbIEiLCbHpLR/M/TvYHHPURxcx+MxVl3G+d/4Ihy4abxOdW pe9zLIcVMvqiUFQO28/79Gfhb7G4K+L21ORB82QYkzm3M7ebXQARAQABzSNQZXRyIEplbMOt bmVrIDxwam1vZG9zQHBqbW9kb3MubmV0PsLBgAQTAQoAKgIbAwUJBaOagAULCQgHAwUVCgkI CwUWAgMBAAIeAQIXgAUCVrDBqwIZAQAKCRBci2l0giH4y/QJEACfiLHyvxlwMvo3Y88Qa9QI i7Hu3ZW+xxojojdRd7do0nBnf2a4YstD9u6ZOLJx4f5Ijb/8LxY10NgLugmfQ7sw2W8ui6wT NiAeNHpr4wpT3IV+V53psOMRYPdq2zNTLO4iNxqPFPgNufR/m4FqcGe0Wo7U0wd1p0MErXTg EXJDVmjPDkYnzE9ejSCOxF57+o3xs6+eW9Al2m3nqP8JCzpauCr0gqpQzCaw0VZ05aLL0t9E B0fdm90+ydVe10Wg+I348005smuSSckBCHZqUfjjWvjwE6v/6dZ3/50ycAbi6cTe7Fo4kOSO sXBFXkzYGWYrEFPkzK0zDH65D98gL1+l9uokCR2t/OYVwudbUCV3cS3xRd0eFgHbXuzV+aZc jRjqkPfpCA2loKtrX2U739mpVSHnpIfSBf48fLg7O5dVn5ZCrydGkEzgvyynPo7IikQrIA02 91IoSp4RisKsJpaXHwHu6DH2rDCbYFumAMgXk2osLFX6VMPoSWKVRkr87A0VLafCtwaqr6Hy sFE6Lmu7jP4/BDr+9A2MXK+v0yYrXqqsZN6V9856ywlZrWK3MB6jc2bKpKS2YshneKxpitNV 0ITs2Li0OlAXOEHE0eXwI93POgLoyH+8JiNbem3orw3Mnc+7XpIY86AejwUiYl8T7EO/2tIx HDaXLK3BPNOdH87BTQRWsMEgARAA6Z3NrDLdcFF/P3TD/F7WQtMALEEKn5TXSF/K2VHt21GD 8tGY1DZhbxjLuQJeheY/2L4F4Y5WCkAoUdBXQs7nIauN+63EL88/qPdH6f3+/HZ+cmPG1E5o dBABCkC42eGcI5O8/9TAaFQcSzg86pdAE8v927tnc6aH4W4/Mj7RJNlQiZaz2ngCC9mr5uu+ CysOTfKCS0llNUkExZOJzZsQU3zDkcg3+xmgtHkCjglJ006KuytHj55HR6TzaKaAW8coHGoS OI/BQ9KAzvlj+32/zS8FSISZSTY3spMpraADsYklejCeJOmqQ3nTrCtwlX3hTSggfr4eelKA hdZKs1rIimNBtX90jJc0u2A/GmC959aTSrCUcfaPRweKUuexg7jxuhXyg9br2GscD2G6W7EV c+3s4dOHgoJFVMBBIqTtZviaNJ63IsZIFTYJzGKKMHOioZ3naoBVav0w63waDzj82nPYMIPj TxnClKiecuBQQPzMaG0jTmK0lis6rO0nIXrCwca8e/3Xzvi7sykOdcz9t4ef8HrDCCkG0yDO o8qHy1e7EtmJD7kWffIXZMt4TZVxpiOqgWtv+heJAfmqzr8pkNLUubmgvNdnakXJOJT41Lui 50C5OhpU9mfFCIDOeZXTQLsHA4KYaL8W/qcjv/YDmvpJtnK24y6tByWuTu7r/SMAEQEAAcLB ZQQYAQoADwUCVrDBIAIbDAUJBaOagAAKCRBci2l0giH4yyWpD/91jd4BMN2CDYqLtU7kaoAa aXnRVpf0z+R8rJ4LZJX1UNbHjsdClMQLfdBuZeDsdYar4iMfwScz6fiCiRwaRpr3XT6znaM0 wba6fjzEqVSHr3WB1jrb/TMiNaNgQJaRPhI5C7VsLuPrv5/L8gFmyjl712q7F3busGFBKrjK qTESMu+sHNvVeC3QyBFCe2fudbAJdaaRsUoTbAZYiowVoQHOow8eBoWY+RzQoYGuw1fls5Ck 85N73pYHXzjfk1s49sDKTYI263h9wbGGA234biHRI3NQN6sSYWRr/u5GOwTm/tzyadRj0pnZ S6KyLSEL4qx8jiyniD/XLoftlvR4YWQ0BXveEElx2n3TThLL1cVtOI4qE9BZKm32euBqwLta k9Jc659hmZB9E9aWLo8KcLjngwqSZupoHRPZ3yAlgZkpDoTIZpMCGxGEuuxgnosRbNpOJ1fE nNXenYYfi87tHRUCRKeHhoKkfGZEgC9zv9Y97j75npqV2tQyh4fNQT1tGdBigtvzI4nHM1/1 PLJtJBdRHucP76vUH9RlP9EE/Sg5DFQqsfSYPqxLW9r+ZfSEeT0APdz7TQC9MzNzUhyXvA5a RQQCRMXKbGaYhKkYEYiYOGqtTxN+PmyvNUBmFEcagBX2TXqEkgnI6zOnN13mB4SihJ2lne2r 9RNiPYs/hmRxYg== Message-ID: <87ab8e6e-ae35-154d-e3b5-3d8c83ea1eff@2ndquadrant.com> Date: Wed, 1 Aug 2018 21:55:18 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 01/08/18 16:00, Nikhil Sontakke wrote: > >> I was wondering if anything else would be needed for user-defined >> catalog tables.. >> > > We don't need to do anything else for user-defined catalog tables > since they will also get accessed via the systable_* scan APIs. > They can be, but currently they might not be. So this requires at least big fat warning in docs and description on how to access user catalogs from plugins correctly (ie to always use systable_* API on them). It would be nice if we could check for it in Assert builds at least. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services