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 1jbPwW-0006uW-0P for pgsql-bugs@arkaria.postgresql.org; Wed, 20 May 2020 14:43:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jbPwU-0004T8-KA for pgsql-bugs@arkaria.postgresql.org; Wed, 20 May 2020 14:43:34 +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 1jbPwT-0004T1-JC for pgsql-bugs@lists.postgresql.org; Wed, 20 May 2020 14:43:34 +0000 Received: from forward5-smtp.messagingengine.com ([66.111.4.239]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jbPwQ-00048F-RK for pgsql-bugs@lists.postgresql.org; Wed, 20 May 2020 14:43:32 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailforward.nyi.internal (Postfix) with ESMTP id 689631941F1A; Wed, 20 May 2020 10:43:29 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 20 May 2020 10:43:29 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm2; bh=DP5Hg/MO2fLgLUigyr8Ijd5wfMAg5sz740KbL1F1e mk=; b=DUBrqKQA5urnjxYYbItCkL++pA45NwPStE07ppUg+t8g1wx5ygAo1CG4j iGOgeMPvTM6pshH7o5UetBBedyx3AoqVlK7jHTFlVC9alKI/PpHH8Xe9Hz7BxeUp 7pC8ZGAZ5qRz8/zzV3sbU8eOGB1bSDTgRNg1sZ4nnUhf7xi67IThv+7fb1rYb6Kc hm0o1piuppqKQa0KSHIp90jFRSxHM023BIVyCc3/2LguqzqzrvJf6hTDu6Iyg5F8 Hi3ycYtRnK5hOB1XLL7ypzd/3XiUWDpdE1vNqxXvjeQfXKFHGVmS/jqn00D7C/DV 3CbdeuDarWM7QFkLUM0JzoqXjvupA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedruddtledgjeekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtjeertddtfeejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvdhnug hquhgrughrrghnthdrtghomheqnecuggftrfgrthhtvghrnheptdevgeehtdejvdevvdel jeeuveejjedtleelgfekleefieekjeelgfektdduuedvnecuffhomhgrihhnpedvnhguqh hurggurhgrnhhtrdgtohhmnecukfhppeelfedrvdegfedrkedvrddvgeeinecuvehluhhs thgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghish gvnhhtrhgruhhtsedvnhguqhhurggurhgrnhhtrdgtohhm X-ME-Proxy: Received: from april.pezone.net (p5df352f6.dip0.t-ipconnect.de [93.243.82.246]) by mail.messagingengine.com (Postfix) with ESMTPA id 3F5683280060; Wed, 20 May 2020 10:43:28 -0400 (EDT) Subject: Re: Re : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value To: Colin Darie References: <16441-f26a1a93b7a4bf7b@postgresql.org> <3a66b26f-0154-3216-1ed5-a63bf63ec61a@2ndquadrant.com> Cc: pgsql-bugs@lists.postgresql.org From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: Date: Wed, 20 May 2020 16:43:25 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-05-18 17:10, Colin Darie wrote: > Rails test framework insert fixtures records this way, and there is currently no way to tell Rails to ignore these columns for insertion (it should obviously). In my case, this breaks all my test suite. AFAIK this is the same for other frameworks or batch records tools. OK, that makes sense. I'll take another look. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services