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 1k3dAb-0000Kd-9r for pgsql-admin@arkaria.postgresql.org; Thu, 06 Aug 2020 10:30:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k3dAZ-0005Rr-To for pgsql-admin@arkaria.postgresql.org; Thu, 06 Aug 2020 10:30:43 +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 1k3dAZ-0005Rk-Jg for pgsql-admin@lists.postgresql.org; Thu, 06 Aug 2020 10:30:43 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1k3dAX-00049J-42 for pgsql-admin@postgresql.org; Thu, 06 Aug 2020 10:30:42 +0000 Received: by mail-ed1-x536.google.com with SMTP id l23so21055350edv.11 for ; Thu, 06 Aug 2020 03:30:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=edA6uBZBG0nAXQKLUugnoTN79uE9kn753IJVQ21o4dQ=; b=Z8qS7HGCoGRNq5hYpbOLrUe3ohEC08u7IFLBbjEkZ30MulGhVsSuo7YcAMmtxgA1JB tvwEDi9tfIcPEEImqmlT8XtHBc9G7fxQhxFQw4Vzi/fqtf12hKTANyqVbVLEthdl7YX6 IxgZmFB/K+6biUcheYZw2EExdjF9H6jei6KDhtzNaxKTYg2ONGRcli0kYXoI0Xo/2ywk AWzKY30+K3kjdFOlcA4mLN5jOHk6FthWxH9f4zsXajDv/ZOl5ZKsbVwUsuxiuc2h29Fe IejR59PBEwScZ6g7Czue0Yro0JWRwjpbi5ypH1a/sr8ybY/I5gt1LsUSahwsMhLamxnq 0kLA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=edA6uBZBG0nAXQKLUugnoTN79uE9kn753IJVQ21o4dQ=; b=PsIf4VYaKnk8ksUkbdcoy2EA9rpqCBPzRXpJXTL6I6EgMMWUviAGFIQoZZjJyCTGqQ +mTQH1GlmgCLN3OP96NdiDaoAVm6Jbp2gRyfMX2A6SdwtgOFOXBjEFj4PPwPHwfJ5nm6 FVRUkLlD6uIaokKAWwM51ysSTI92sRuIwxjR89CJuz4/zsyPLupg0TgmGpFk2850GOOi EzzqgWVlbxCJvKvQyga2TxalTqXDKSKSlmKZ08WEu+9Bl6iwbKxEqB8eg+6eDHcJc2/T BPn1Lr+gMZfd1FgU7q2ZcW84sOnTmCyFttsFMdgvplv7YR41nAlec2Ba9Xs4TF0XINIr dMQA== X-Gm-Message-State: AOAM530vIUjebGBuUfsJ/v94vwaSqCA5AnG7mbaxAXu5v6Lx3iKypfkG BupRspRAnaPttGF8+HJ/fD8WWBfC X-Google-Smtp-Source: ABdhPJyVyoHz5w8UDbIMQzSAqyXstlJ7fiEAT/nOwBmAMk+WQlPOlStVlU5pv6ZcVg5Sp80zcL879g== X-Received: by 2002:aa7:cdc4:: with SMTP id h4mr3343727edw.252.1596709839491; Thu, 06 Aug 2020 03:30:39 -0700 (PDT) Received: from [192.168.1.8] (241-57-239-77.dyn.cable.fcom.ch. [77.239.57.241]) by smtp.gmail.com with ESMTPSA id n5sm3479871eja.105.2020.08.06.03.30.38 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 06 Aug 2020 03:30:38 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.1\)) Subject: Re: UPDATE works on a view? From: =?utf-8?Q?Paul_F=C3=B6rster?= In-Reply-To: Date: Thu, 6 Aug 2020 12:30:34 +0200 Cc: Wells Oliver , pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: <04F57CD2-A4EC-4F2C-BD08-61AE300E9D65@gmail.com> References: To: Magnus Hagander X-Mailer: Apple Mail (2.3608.120.23.2.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Magnus, > On 06. Aug, 2020, at 12:20, Magnus Hagander = wrote: > For this type of high level features, the Feature Matrix is a pretty = good way to find out these things = (https://www.postgresql.org/about/featurematrix/#views-materialized-views)= . I didn't know that. Many thanks. :-) Cheers, Paul=