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 1pknVX-000523-VQ for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Apr 2023 14:56:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pknVW-0002qV-SH for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Apr 2023 14:56:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pknVW-0002qM-Fc for pgsql-hackers@lists.postgresql.org; Fri, 07 Apr 2023 14:56:06 +0000 Received: from mail-il1-x135.google.com ([2607:f8b0:4864:20::135]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pknVR-001Sab-Oq for pgsql-hackers@lists.postgresql.org; Fri, 07 Apr 2023 14:56:05 +0000 Received: by mail-il1-x135.google.com with SMTP id q8so7653149ilo.1 for ; Fri, 07 Apr 2023 07:56:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; t=1680879360; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=Whh59/Rrw1NhQmToGGPOj9DqfYUUy1QWUHEkB4KFWyo=; b=kyHmrym7JH0nB11EfdEYXetxEGw1N9SysVEiaUQAIL/6gPU81Q9yYD78rhQuA0gAJu CzW8175RQiJ9zEK2j/DYS9Ba/3w/D0CdxakZ9bS+N74wu34uJb/Gm2K3b96U457yZcLk lt4MFvF82Bh9wMO8+O5qgY0Xleykpm/3MryY313S1PBwU1yUvmcFVSxto4poAXc+Minu 71pclNfgLxAKb5roErI+K7SdT1OL19NqZL9fTd6QNP1MhpDye1fanMy4MncQhlqAkxMM Z+mKm2AFzeQHUVhGqH2HJf/z5zihKgFL+Jhm2ZShqOWtAGZ6BVPwmtQK/Fty+VekrXZx 8euA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1680879360; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Whh59/Rrw1NhQmToGGPOj9DqfYUUy1QWUHEkB4KFWyo=; b=xEI/uBXgynQgMHJqIAbqA7v3ahNhZ6Oki9QB1Sj2fpK9uSRZyZ9ltiIesQNmiZ+uvv wAN/cQp7du5IvLIjpurwFUUB0TjnBM3e9W2ngVVYDRdl3/p2XOqtdMXUqrHCb0W9orOx BBA+JcDrpH04VEpYOJRAq3zxHhr1KFaGK44gnrXAOBO+VlJUVuL+mPz9tOOtKJLKCnBG u8yK4PlcJYhDJ42zQQ4nlSIudwoOj/keTKxOQQHcElXDvX2NE0ykSJ/AzMxYU8j7+H04 KrXJ/CEZfZxLwMU6R9eMBG1Yb4YVrYzQ9cnOMIWA6KOHtNkoe/iSBfx98VxHhRE+NlE8 Nlew== X-Gm-Message-State: AAQBX9c0pP4WbZAhLMFsROEF57PrjIJmfG7Tv2wSR3WwJAmcpvkJh8s7 693MvM61VQquZMiTgdHMTRp3Hg== X-Google-Smtp-Source: AKy350avn9pYudZyWlXHElCrBvxtqDKlh4mqb3TfOlSV5U0Wj5cLuxmAbZUAKcWlWId7kTR/N6Nubg== X-Received: by 2002:a92:d44b:0:b0:326:2c14:a718 with SMTP id r11-20020a92d44b000000b003262c14a718mr1549237ilm.32.1680879359991; Fri, 07 Apr 2023 07:55:59 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id e10-20020a02210a000000b0040b38102b79sm1128675jaa.82.2023.04.07.07.55.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 07 Apr 2023 07:55:59 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id ADF678019C0; Fri, 7 Apr 2023 09:55:58 -0500 (CDT) Date: Fri, 7 Apr 2023 09:55:58 -0500 From: Justin Pryzby To: Alvaro Herrera Cc: Peter Eisentraut , pgsql-hackers@lists.postgresql.org Subject: Re: cataloguing NOT NULL constraints Message-ID: References: <20230407021413.dolhoh47nrvlthbq@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230407021413.dolhoh47nrvlthbq@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Apr 07, 2023 at 04:14:13AM +0200, Alvaro Herrera wrote: > On 2023-Apr-06, Justin Pryzby wrote: > > +ERROR: relation "c" already exists > > Do you intend to make an error here ? These still look like mistakes in the tests. > Also, I think these table names may be too generic, and conflict with > other parallel tests, now or in the future. > > > +create table d(a int not null, f1 int) inherits(inh_p3, c); > > +ERROR: relation "d" already exists > Sadly, the binary-upgrade mode is a bit of a mess and thus the > pg_upgrade test is failing.