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.89) (envelope-from ) id 1gjswn-0005TX-OC for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Jan 2019 21:42:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjsvo-00020s-HH for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Jan 2019 21:41:04 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjsvo-0001wW-93 for pgsql-hackers@lists.postgresql.org; Wed, 16 Jan 2019 21:41:04 +0000 Received: from lb1-smtp-cloud7.xs4all.net ([194.109.24.24]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjsvm-0003LN-A0 for pgsql-hackers@postgresql.org; Wed, 16 Jan 2019 21:41:03 +0000 Received: from webmailclassic.xs4all.nl ([IPv6:2001:888:0:22:194:109:20:208]) by smtp-cloud7.xs4all.net with ESMTPA id jsvjgSgvEBDyIjsvjg4TlU; Wed, 16 Jan 2019 22:41:00 +0100 Received: from 2001:983:39b6:1:85cf:3e20:e818:1bc0 by webmailclassic.xs4all.nl with HTTP (HTTP/1.1 POST); Wed, 16 Jan 2019 22:40:59 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Date: Wed, 16 Jan 2019 22:40:59 +0100 From: Erik Rijkers To: Peter Eisentraut Cc: pgsql-hackers , Sergei Kornilov , Michael Paquier , Jaime Casanova Subject: Re: [HACKERS] generated columns In-Reply-To: <26129f50-cf47-2013-8f9b-e7a98853aa69@2ndquadrant.com> References: <1bc948f8-3bab-6c54-50af-c0723a75b85f@2ndquadrant.com> <20180116063546.GA3679@paquier.xyz> <48502d9b-60c4-5b10-40a2-e34f562132b4@2ndquadrant.com> <20180119051804.GC12826@paquier.xyz> <2e3d5147-16f8-af0f-00ab-4c72cafc896f@2ndquadrant.com> <20180131131804.GB1586@paquier.xyz> <20180202022532.GA84623@paquier.xyz> <050e663d-d915-f61b-af96-5a09c10ade02@2ndquadrant.com> <79e4de23-52e3-2c45-9ba0-5f6932f590aa@2ndquadrant.com> <28574501540912440@iva5-750e13568e4d.qloud-c.yandex.net> <2ddd0bfa-0fcd-35ec-266c-f03cf72fc581@2ndquadrant.com> <26129f50-cf47-2013-8f9b-e7a98853aa69@2ndquadrant.com> Message-ID: <17fd00ff02ede468e2a3d63ff8cd5ff7@xs4all.nl> X-Sender: er@xs4all.nl User-Agent: XS4ALL Webmail X-CMAE-Envelope: MS4wfD0pNN/9wwDS8lwKeLZGMmgnl8n/0u9RX7tkrkNq0XkschpV7onYRzo+TQPT1BpWGphkzVFXgvzmjkEpD6BvT5Kjf0nasK2/sx6u6oEED8wGKkh0RXjU cSBb0/PGOxgj55mDCS4++6FryIvRR5hEaLf4xiBeEJRZUIIFCSAfiGGhNta3pBnwXEPY4iUQeWLkIVoT/yu4t2GzF4EJcTzWQo0irmPhknTujQ7bQOEXJzdw JWf0Wey53bsw82aJwGtztcO+vjthDaUe8jPBmN1IVFBnFVE3KoBeZ0dUM7K1vRPOxnr4bC04LYC/g4KLlQSgR0qrDfNOCZmEVKbcXxt8fzYh63V3Bv9Ol9Pg ME/qlaJ3YF7kihpgim0vlfyOW7wv7g== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I couldn't compile v7-0001 and I am testing with the older v6-0001 (of which I still had an instance). So the problem below may have been fixed already. If you add a generated column to a file_fdw foreign table, it works OK wih VIRTUAL (the default) but with STORED it adds an empty column, silently. I would say it would make more sense to get an error. Erik Rijkers