Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gKnK3-0000R9-Hi for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Nov 2018 16:38:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gKnK1-0003oh-7c for pgsql-hackers@arkaria.postgresql.org; Thu, 08 Nov 2018 16:38:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gKnK0-0003oY-PQ for pgsql-hackers@lists.postgresql.org; Thu, 08 Nov 2018 16:38:21 +0000 Received: from mail-qk1-x743.google.com ([2607:f8b0:4864:20::743]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gKnJt-0004uk-Eb for pgsql-hackers@lists.postgresql.org; Thu, 08 Nov 2018 16:38:19 +0000 Received: by mail-qk1-x743.google.com with SMTP id q1so27474847qkf.13 for ; Thu, 08 Nov 2018 08:38:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=JMJSZ11D/XrS37gmoI73ce8D4GXbmTPyD8nZbLyWU0w=; b=dGxkPlfbd5t2YSTiKg9b2NizyqTkOUg8G/p5OCUcBViwFdYoGpNz/uL9/sOd2aJFGt cU0FuapmXhdajZyz5adkRvmbfzGcOMul5/oaC6ioiikVtcfWCTQHTM5/0U879f2ZqCT3 P6Irn9/khZfNJmVxkzEOuMu21WxyXP4uMIbPj+2ArYimJ4kFme5qg2VjeIbSmrqzq8l3 56HAuJ6DZIqvopTOFZ2uFN7YhhcV0/SQPthVMdZ0hsWuib3b0BN3r9JGssp40+cPlShg pr+igGqqKqLlY5IfwVFBwG6Eku1W8VHCbIoVFn/vv23R/ILZywCRCYeKZ5KqZaizCKsh tveA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=JMJSZ11D/XrS37gmoI73ce8D4GXbmTPyD8nZbLyWU0w=; b=AlV32Xky5i439LaD96jCF9MK9wS2jv1hBWbQSK/cbpGZT55wNkS/0E9NCFCAr1vH1n KxoPhMSJEtiUl6TE4v2VjpsSXz+H9wWJDg5EH+wumhjEciFaDyo8hpTO1WxOl8IhraRa DzEUzDR9hyX02MzvtEJNQXqlPO/lzm0VPq7afiDhVBg6v/4JqMMJvKrIDzw8LaxnIPC0 oU3ztwXr8CrzagpYcrxfp+90K/4BjOvOiFp/gsnJLcWKUkXwd86H00yNwMSPrBrOOu8f Y/PEqBv3n4dULeGLekR3bT2i/xjVr9SIw69bOey1TPobPPdfRC4Q4EwSgFLbIAdzp4NA qW3w== X-Gm-Message-State: AGRZ1gK8GFoZSUNrq+Jei/wRxV+jJYDGEshDNWhU/gOm85quYSR/ZGWA 8iP55Pnk0rBuFrk133FaWFiNZQ== X-Google-Smtp-Source: AJdET5cQ/wcftOAUHMwq9ybM0Z2w2n5Glkf9NuoY8eKoO+HIhP78IkXTUaIzx5wLw9z3FT/vGUe+2w== X-Received: by 2002:ac8:3a22:: with SMTP id w31mr4975637qte.302.1541695092366; Thu, 08 Nov 2018 08:38:12 -0800 (PST) Received: from alvin.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id u123-v6sm2146363qkd.51.2018.11.08.08.38.11 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Thu, 08 Nov 2018 08:38:11 -0800 (PST) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 861045BE; Thu, 8 Nov 2018 13:38:09 -0300 (-03) Date: Thu, 8 Nov 2018 13:38:09 -0300 From: Alvaro Herrera To: Amit Langote Cc: Amit Langote , Ashutosh Bapat , PostgreSQL Hackers Subject: Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Message-ID: <20181108163809.mb7dstn2j244fvuf@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: NeoMutt/20180716 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2018-Nov-09, Amit Langote wrote: > On Fri, Nov 9, 2018 at 1:03 AM Alvaro Herrera wrote: > > On 2018-Nov-07, Amit Langote wrote: > > Hmm, I'm thinking perhaps we shouldn't backpatch this part. It's > > obviously a bug, but we might break somebody's working apps. Therefore > > I think I'd rather leave it out of the current bugfix and commit > > separately. > > Okay, that may be fine because nothing wrong is happening by silently > ignoring the partition's specified collation. Actually, how about we reduce the message to a WARNING in released branches, and ERROR in master? Broken applications would continue to work, but users might become aware that there might be a problem. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services